PSAPPSRV LOG:
PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
Database Signon: Could not sign on to database FTST with user PSAPPS.
On new install of PplTools 8.49,unable to boot the application server domain on AIX Unix system
Errors : PSAPPSRV LOG shows :
PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
Database Signon: Could not sign on to database HRMSDV with user PSAPPS.
StdErr shows :
open in libpscompat failed for 'libpsora.so':/oracle/10.2.0.3/lib32/libclntsh.so.9.0:file too short
Cause :
The cause of the problem is the incorrect size of Oracle library in use.
<xxxxxxxxxxx: test></oracle/10.2.0.3/lib32> ls -l /oracle/10.2.0.3/lib32/libclnt*
lrwxrwxrwx 1 oracle dba 85 Feb 11 10:56 /oracle/10.2.0.3/lib32/libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 oracle dba 0 Feb 01 02:18 /oracle/10.2.0.3/lib32/libclntsh.so.10.1
Here, -rwxrwxr-x 1 oracle dba 0 Feb 01 02:18 /oracle/10.2.0.3/lib32/libclntsh.so.10.1
shows that the file everything is pointed to has 0 bytes
Solution :
1. Run the following as the UNIX account that boots the Application Server:
ls -l $ORACLE_HOME/lib32/libclnt*
Review the listing results to determine if the libclntsh soft links are accurate
and that the files/links returned have some size value.
2. Output should show files with a size greater than 0 bytes and not like below:
<xxxxxxxxx: test></oracle/10.2.0.3/lib32> ls -l /oracle/10.2.0.3/lib32/libclnt*
lrwxrwxr-- 1 oracle dba 85 Feb 11 10:56 /oracle/10.2.0.3/lib32/libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-- 1 oracle dba 0 Feb 01 02:18 /oracle/10.2.0.3/lib32/libclntsh.so.10.1
3. If the Oracle client lib has a size of '0' then you will need to re-create it
using the Oracle DB delivered '$ORACLE_HOME/bin/genclntsh' script using the UNIX Oracle account.
4 . To resolve the issue install the 32 bit Oracle client on your application server machine
and setup your environment to only find the 32 bit libraries.
Make sure ORACLE_HOME, PATH, LD_LIBRARY_PATH are all configured to find 32 bit Oracle libraries.
PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
Database Signon: Could not sign on to database FTST with user PSAPPS.
On new install of PplTools 8.49,unable to boot the application server domain on AIX Unix system
Errors : PSAPPSRV LOG shows :
PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
Database Signon: Could not sign on to database HRMSDV with user PSAPPS.
StdErr shows :
open in libpscompat failed for 'libpsora.so':/oracle/10.2.0.3/lib32/libclntsh.so.9.0:file too short
Cause :
The cause of the problem is the incorrect size of Oracle library in use.
<xxxxxxxxxxx: test></oracle/10.2.0.3/lib32> ls -l /oracle/10.2.0.3/lib32/libclnt*
lrwxrwxrwx 1 oracle dba 85 Feb 11 10:56 /oracle/10.2.0.3/lib32/libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 oracle dba 0 Feb 01 02:18 /oracle/10.2.0.3/lib32/libclntsh.so.10.1
Here, -rwxrwxr-x 1 oracle dba 0 Feb 01 02:18 /oracle/10.2.0.3/lib32/libclntsh.so.10.1
shows that the file everything is pointed to has 0 bytes
Solution :
1. Run the following as the UNIX account that boots the Application Server:
ls -l $ORACLE_HOME/lib32/libclnt*
Review the listing results to determine if the libclntsh soft links are accurate
and that the files/links returned have some size value.
2. Output should show files with a size greater than 0 bytes and not like below:
<xxxxxxxxx: test></oracle/10.2.0.3/lib32> ls -l /oracle/10.2.0.3/lib32/libclnt*
lrwxrwxr-- 1 oracle dba 85 Feb 11 10:56 /oracle/10.2.0.3/lib32/libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-- 1 oracle dba 0 Feb 01 02:18 /oracle/10.2.0.3/lib32/libclntsh.so.10.1
3. If the Oracle client lib has a size of '0' then you will need to re-create it
using the Oracle DB delivered '$ORACLE_HOME/bin/genclntsh' script using the UNIX Oracle account.
4 . To resolve the issue install the 32 bit Oracle client on your application server machine
and setup your environment to only find the 32 bit libraries.
Make sure ORACLE_HOME, PATH, LD_LIBRARY_PATH are all configured to find 32 bit Oracle libraries.
