Kbase P51864: How to connect from a windows client to a schema holder and Oracle DataServer on UNIX?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2007 |
|
Status: Verified
GOAL:
How to connect from a windows client to a schema holder and Oracle DataServer on UNIX?
FACT(s) (Environment):
Oracle DataServer
FIX:
On UNIX server:
1. In the session make sure you set following environment variables;
Set DLC to Progress installation
Set ORACLE_HOME to Oracle client installation directory
Set PATH to include DLC, ORACLE_HOME, and ORACLE_HOME\bin
Set ORACLE_SID to Oracle SID name if Oracle instance is local
2. Make sure that host and service files on both machines are configured correctly to allow for a client/server connection
3 Start Oracle DataServer Broker via _probrkr executable
_probrkr -H UNIXhostname -S brkrservice -N tcp
4. Proserve the schema holder
proserve myholder -H UNIXhostname -S dbservice -N tcp
On Windows Server:
5. Perform a client/server connection from windows client to unix schema holder and broker.
prowin32 myholder -H UNIXhostname -S dbservice -N tcp -ld myora -dt Oracle -H UNIXhostname -S brkrservice -N tcp
Please note, using the above configuration forces you to go through the network. You can avoid TCP/IP overhead and move the schema holder to a windows machine and connect to the SH via -RO (read only).
To move the schema holder to windows, do the following:
On UNIX server:
1. Dump schema holder .df
On Windows server:
2. Create an empty database
prodb myholder empty
3. Load .df file into empty db
4. Connection string from windows client to schema holder/Dsrv broker on UNIX;
prowin32 myholder -RO -ld myora -dt Oracle -H UNIXhostname -S brkrservice -N tcp