Missing or Invalid Version of SQL Library libpsora

Taken from customer connection..

E:AS Missing or Invalid Version of SQL Library libpsora PeopleTools 8.48+ on Oracle 10g and 11i [ID 650409.1]
		Modified 30-MAR-2012     Type PROBLEM     Status ARCHIVED

In this Document
  Symptoms
  Cause
  Solution

---

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.48 to 8.51   [Release: 8.4 to 8.4]
Generic Linux
***Checked for relevance on 23-Aug-2011***

Symptoms

Application server can't start because of bad link.  The application server is looking for a library that does not exist: dlopen in libpscompat failed for libpsora.sl: ld.so.1: PSAPPSRV: fatal: libclntsh.sl.9.0: open failed: No such file or directory

stderr file has errors similar to:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.9.0'.

stdout file has the error:

shl_load in libpscompat failed for libpsora.sl

Cause

Not Applicable

Solution

PeopleSoft now supports 64 bit Oracle for PeopleTools 8.48 and later. The library libclntsh.so.10.1 (Oracle 10g) libclntsh.so.11.1 (Oracle 11i) must be linked in the 64 bit lib directory.

NOTE: On Linux platforms for PeopleTools 8.48 and 8.49 we are still using the 32 bit libraries for the application server. Starting with PeopleTools 8.50 Linux now uses the 64 bit libraries. Make sure you are linking the libclntsh.sl.9.0 file from the $ORACLE_HOME/lib32 directory if running 64 bit Linux prior to PeopleTools 8.50. If you have only installed the Oracle 32 bit client on Linux you may only have the lib directory and not lib32, so do the link from the lib directory in this case.

If stderr error reports an error with libclntsh.sl.9.0, run the link command in the $ORACLE_HOME/lib directory as the oracle user :

     ln -s $ORACLE_HOME/lib/libclntsh.sl.10.1 libclntsh.sl.9.0    (Oracle 10g)

     ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.sl.9.0    (Oracle 11i)

If stderr error reports an error with libclntsh.so.9.0, run the link command in the $ORACLE_HOME/lib directory as the oracle user :

     ln -s $ORACLE_HOME/lib/libclntsh.so.10.1  libclntsh.so.9.0   (Oracle 10g)
     
     ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.so.9.0 (Oracle 11i)

** NOTE ** Check your library name in the $ORACLE_HOME/lib directory to make sure it it the exact name above. It the name differs replace above name with yours.

Make sure your LIBPATH, SHLIB_PATH or LD_LIBRARY_PATH references the $ORACLE_HOME 64 bit libraries ($ORACLE_HOME/lib).

Check your $PS_HOME/install/psdb.sh script and make sure the PATH's in there points to the 64 bit libraries for Oracle.

On PeopleTools 8.48+ the location of psdb.sh is $PS_HOME/setup

After fixing this, re-logon as the psoft account to reset your environment. Make sure you reconfigure your domain so it picks up the new changes. Check your $PS_HOME/appserv/DomainName/psappsrv.env file to ensure that your environment has the Oracle 64 bit libraries in your LIBPATH, SHLIB_PATH or LD_LIBRARY_PATH and not $ORACLE_HOME/lib32.