Kbase P75145: What licenses do I need to install for remote oracle DataServer configuration
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/09/2008 |
|
Status: Verified
GOAL:
What licenses do I need to install for remote oracle DataServer configuration
GOAL:
What licenses do I need to install in the machine for the distributed oracle DataServer configuration
FACT(s) (Environment):
Oracle DataServer
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
A. Configuration scenario:
1. First Machine: Windows - running the Progress Application
2. Second Machine: Unix or Windows - hosting Oracle DataServer License
3. Third Machine: Unix or Windows Machine - hosting Oracle Database
In the above configuration, The following licenses needs to be installed:
1. Progress Client networking (Run-time license)
2. Oracle DataServer and Oracle database client
3. Oracle Database
In this case the second machine is important to be configured correctly.
Second machine configuration:
Oracle SQL*NET service needs to be created to communicate to Oracle database. After successful creation of the SQL*NET service, test it with SQL*PLUS to verify it is working. The following environment variables needs to be set in UNIX before starting the DataServer broker:
ORACLE_HOME=<Path of Oracle Installation Directory>;export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH (solaris)
ORALIB=$ORACLE_HOME/lib;export ORALIB (AIX)
SHLIB_PATH=$ORACLE_HOME/lib;export SHLIB_PATH (HPUX)
After the above configuration, start the _probrkr or unified broker (mssbroker1).
Now using first machine, create an empty schema holder (progress database). Connect to it in a single user mode also using -rx switch in the connection parameter. Go through the the Dataserver menu to create oracle DataServer schema holder.
In the above scenario, if 2 and 3 are on the same machine, the Oracle client and the SQL*NET service are not necessary.