Kbase P18037: How to connect a Progress Client on UNIX with an Oracle DataServer on a Windows server.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/21/2011 |
|
Status: Unverified
GOAL:
How to connect a Progress Client on UNIX with an Oracle DataServer on a Windows server?
GOAL:
How to create an Oracle DataServer schema holder in UNIX for Oracle DataServer installed on Windows?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
On the Windows Server:
______________________
1) Set the following environment variables:
ORACLE_HOME=<Directory where Oracle was installed>
ORACLE_SID=<Name of the Oracle instance>
ORASRV=%DLC%\bin\_orasrv.exe
2) Start a broker like this from Proenv:
_probrkr -S <service name> -H <Windows host name> -N TCP
3) Make sure you can query the Oracle tables with your user and password using Oracle's SQLPLUS utility.
4) Verify that the port designated for the _probrkr is listening by issuing the command:
netstat -na
In the UNIX server:
_________________
5) Test the connectivity with the Oracle Data Server broker on the Windows server using the telnet command like this:
telnet <Windows Host Name> <service name>
It must show a connected message, meaning that the broker is listening, then discard the telnet session.
6) Create an schema holder using the command:
prodb <holder name> empty
7) Start a Progress session
pro <holder name> -p dict.p
8) Go to the DataServer menu and choose
ORACLE Utilities > Create DataServer Schema...
9) Connect with the Oracle instance through _probrkr
Here is the UNIX screen:
__________Create/Modify Database Record for DataServer Schema__________
| Logical Database Name: <Name of the Oracle instance> |
| Server Type: ORACLE
| Code Page: ibm850
|
| Oracle Version: <7 or 8>
|
| Connection Parameters:
| -S <service name> -H <Windows Host Name>
| -U <Oracle User>@<Name of the Oracle instance>
| -P <Oracle password>
| _______________________________________________
| _______________________________________________
|
| <OK> <Cancel>
|_____________________________________________________________________
Example: -S serbrk -H pcwindow1 -U ronda@orasales -P secret
10) You will be prompted again for the user and password for the ORACLE instance, ignore it and just press the <OK> button.
11) Select the required Oracle tables
12) Once all the definitions are pulled from Oracle, the schema holder will be ready.
13) To connect to it, following the previous example type:
pro holder -RO -db orasales -dt ORACLE -S serbrk -H pcwindow1