Kbase P17723: Oracle error 1012 after installing new oracle client on Windows
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Progress 9.1D
SYMPTOM(s):
Oracle error 1012 after installing new oracle client
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
Two oracle clients installed on the same windows machine
In the dataserv.lg, ORACLE_HOME is pointing to Oracle 9i client installation
In the dataserv.lg, the shared library being loaded is pointing to Oracle 8 client's DLL
ORADLLNAME is not set
CHANGE:
Installed a 9.2 oracle client
CAUSE:
The ORACLE_HOME is correctly set for Oracle 9i client, but PATH environment variable has Oracle 8i client's bin directory in front of Oracle 9i client's bin directory, thus the Oracle client DLL (OCIW32.DLL) that is loaded by data server is from Oracle 8i.
Please reference notes for more details on how Progress loads Oracle client DLL on windows.
FIX:
Add Oracle 9i installation's bin directory to the very beginning of PATH system environment variable