Kbase P18713: How to define a specific Oracle installation to run with Progress
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to define a specific Oracle installation to run with Progress
FACT(s) (Environment):
Oracle 7.3.4
Oracle 8.x
FIX:
Oracle uses the value of ORACLE_HOME and Progress has no control over this setting. If you have two versions of Oracle installed, Progress will use whatever ORACLE_HOME is set first on the PATH.
The DataServer is just a client from the Oracles point of view and all Oracle client settings will be applied equally to all clients. Progress uses a Oracle dll to make calls to the Oracle database and other calls to other Oracles dlls are indented to this initial call, making Progress powerless to what happen after the first call.
That is why there is no way to direct Progress to a specific Oracle installation. The shell expects the variable ORACLE_HOME and PATH before the program is executed.
A possible workaround would be create .bat file to reset the ORACLE_HOME and PATH to match the desired Oracle version. This would avoid any permanent changes to the Windows environment.