Tuesday, 12 November 2013

Missing or invalid version of SQL library libpsora (200,0)

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.

No comments:

Post a Comment