Kbase P132298: Can not connect to Oracle database error unable to allocate memory in the user side
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/06/2008 |
|
Status: Unverified
FACT(s) (Environment):
IBM AIX
Progress 9.x
Oracle 9i
Oracle 10g
Oracle DataServer
SYMPTOM(s):
Can not connect to Oracle database
Error connecting to Oracle database
ORACLE error -1019 see "ORACLE Error Messages and Codes Manual". (1252)
unable to allocate memory in the user side
Failed to connect to ORACLE database. (1451)
Errors only occur to executables built against Oracle 10.2
No problem connecting through Oracle 9i
Oracle 10.2 and Oracle 9i coexist on the same machine
Oracle executables were probuilt both against oracle 10.2 and oracle 9i (with ORALIB set to point to different libraries)
Soft link added in /usr/lib to point to $ORACLE_HOME/lib32/libclntsh.a
Oracle dataserver executables all have SUID bit on
CAUSE:
The soft link in /usr/lib points to Oracle 9i's libclintsh.a, when SUID is on, the OS would only load the library from /usr/lib. Thus in Oracle 10.2's environment, the Oracle 9i's libclntsh.a is picked up from /usr/lib but ORACLE_HOME still points to Oracle 10.2, thus causing Oracle errors
FIX:
Soft link Oracle 10.2's libclntsh into /usr/lib, in this case both Oracle 9i and Oracle 10.2 work as Oracle 10.2's libclntsh has no problem with ORACLE_HOME pointing to Oracle 9i installation.