GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64

Boot Attempt for application server and Batch Server on the RHEL7 was failing with the error as below

PSPPMSRV.32692 (0) [2016-05-02T15:01:15.608] - - - (0) PeopleTools Release 8.55.03 (Linux) starting. Tuxedo server is PPMGRP(91)/100
PSPPMSRV.32692 (0) [2016-05-02T15:01:15.609] - - - (3) Detected time zone is ACST
PSPPMSRV.32692 (0) [2016-05-02T15:01:15.751] - - - (0) Cache Directory being used: /home/fs91dmf/psft/pt/8.55/appserv/fin91dmo/CACHE/PSPPMSRV_100/
PSPPMSRV.32692 (0) [2016-05-02T15:01:15.760] - - - (1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64
PSPPMSRV.32692 (0) [2016-05-02T15:01:15.762] - - - (1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database FIN91DMO with user VP1.
PSPPMSRV.32692 (0) [2016-05-02T15:01:15.762] - - - (0) Server failed to start
PSADMIN.32658 (0) [2016-05-02T15:01:22.616] - - - (0) End boot attempt on domain

Further review of stderr file was showing the error which was pointing to the Oracle file libclntsh.so.11.1

dlopen in libpscompat failed for 'libpsora64.so': libclntsh.so.11.1: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora64.so': libclntsh.so.11.1: cannot open shared object file: No such file or directory

Solution

Application server was not starting because of bad link.The application server is looking for a library that does not exist dlopen in libpscompat failed for 'libpsora64.so': libclntsh.so.11.1: cannot open shared object file: No such file or directory

As PeopleSoft now supports 64 bit Oracle for PeopleTools, the library libclntsh.so.11.1 need to link with the 64 bit lib directory.

I navigated to $Oracle_HOME/lib to check if the library are pointing to 64 bit lib directory. I found that soft link though exist in the lib directory pointing to 64 Bit lib directory but was actually broken as it was flashing in Red.

Note that softlink if broken will flash in Red colour in the linux directory structure.

I have unlinked the broken link: command as below
unlink libclntsh.so

Created the softlink again

ln -s libclntsh.so.12.1 libclntsh.so

Recreating the softlink fixed the issue







Post fixing the broken links to point to 64 bit library, both application server and batch server booted with success.