Kbase 18686: How to configure Oracle DataServer as Unified broker?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/29/2009 |
|
Status: Verified
GOAL:
How to configure Oracle DataServer within the Unified Broker framework?
GOAL:
Step by step instructions on how to configure and connect a unified oracle broker
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
OpenEdge 10.x
FIX:
Before outlining the configuratin steps, this solution assumes the following:
1. Working with Oracle database present on a remote UNIX machine, Oracle service name myora. Windows Oracle client can connect to Oracle SID on UNIX via NET8 using service name myora.
2. The Oracle schema that we will pull exists for:
USERID 'orauser'
password 'orapw'.
(It is possible to use another user/password.)
3. Client and DataServer licenses exist on the same machine, for this example, Windows NT.
Configuration Steps:
1. Make sure the Admin Service has been started
(Check Start->Settings->control Panel/Services to
see if the 'AdminService for Progress version 9.1x'
has been started.)
2. Bring up the Progress Explorer tool (start menu-> v9.1x)
3. File->Connect in the Progress Explorer to connect
to the Admin Service
4. In the Progress Explorer, you should now see a list
of the different types of unified brokers that you are able to
start such as WebSpeed, ORACLE DataServer etc...
Click on ORACLE DataServer.
5. Right click on orabroker1, go to Properties. (For this test, we will use the default broker 'orabroker1' but you could create a new broker with different names).
6. Click on Server Parameters tab. Note that the server
executable that we are going to start is called _orasrv.
Make sure that it exists in your DLC/bin directory.
7. Note that the default Server Startup Parameters for 9.1D are:
-svub -S X -N TCP -U X -P X -hs 0 -s 40
Troubleshooting tips:
-svub: Necessary on the client connection to indicate
using unified broker service -- if you don't use this you
may get error 778.
-U,-P: The X that is passed for -U and -P are place holders
for the ORACLE userid and password that will be passed
later. Do not change these from X to anything else. If you
do change them, you may end up with error 5483.
8. Go to Broker -> Controlling NameServer, we will use default NS1 as controlling name server, port number is 5162.
9. Make sure NS1 is started (default is auto start). Also make sure in Properties-> Data Service, orabroker1 is in App service name list.
10. Go to orabroker1 -> Properties -> Broker->Environment. Check that
ORACLE_HOME is set correctly (ORACLE_SID also needs to be set if you do not go through NET8).
11. Press the START button. After the broker has started, go to orabroker1 -> Status and verify there are available servers.
12. Now connect to the orabroker1 that we have
just started. Bring up Progress V9.1 Data Administration.
Create an empty database called 'holder'. Create a schema
holder using menu Dataserver->oracle utilities->create schema
holder.
13. Fill in the logical Database name as 'orac' or whatever you
choose.
14. select the version of ORACLE (8 or 9).
15. For the connection parameters type in the following:
-DataService orabroker1 -S 5162 -H localhost -N tcp -U orauser@myora -P orapw -Dsrv svub,1
(In 9.1D if you choose to bypass name server - deselect Register with Nameserver toggle in Broker->Properties->Controlling NameServer , the connection parameters are:
-DataService none -S 4445 -H localhost -N tcp -U orauser@myora -P orapw -Dsrv svub,1 )
16. Once you are connected, continue pulling the schema
by selecting the objects that you want from the list
and you are done.