8 Replies Latest reply: Oct 7, 2010 1:58 PM by 724293 RSS

    PS General SQL Routines: Missing or invalid version of SQL library libpsora

    724293
      Hi Everyone,

      Need your assistance. Perhaps someone of you encountered this already. I have completed setting up everything until the application server part. If I try to boot the application server I get the error below. I have tried several solution published in Oracle Support and these did not resolve the issue.

      Appserv log

      PSADMIN.15894 (0) [10/01/10 16:17:21](0) Begin boot attempt on domain hc91dmo
      PSAPPSRV.15941 (0) [10/01/10 16:17:50](0) PeopleTools Release 8.50 (Linux) starting. Tuxedo server is APPSRV(99)/1
      PSAPPSRV.15941 (0) [10/01/10 16:17:51](0) Cache Directory being used: /applications/psoft/hc91/appserv/hc91dmo/CACHE/PSAPPSRV_1/
      PSAPPSRV.15941 (0) [10/01/10 16:17:51](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
      PSAPPSRV.15941 (0) [10/01/10 16:17:51](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database HC91DMO with user PS.
      PSAPPSRV.15941 (0) [10/01/10 16:17:51](0) Server failed to start
      PSADMIN.15894 (0) [10/01/10 16:17:58](0) End boot attempt on domain hc91dmo

      Tuxedo log

      161730.TESTLAB-03!BBL.15902.2248875168.0: 10-01-2010: client high water (0), total client (0)5900.2137364080.-2: TMADMIN_CAT:1330: INFO: Command: boot -A
      161728.TESTLAB-03!tmboot.15901.2219435552.-2: 10-01-2010: Tuxedo Version 10.3.0.0, 64-bit
      161728.TESTLAB-03!tmboot.15901.2219435552.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds
      161728.TESTLAB-03!tmboot.15901.2219435552.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected
      161730.TESTLAB-03!BBL.15902.2248875168.0: 10-01-2010: Tuxedo Version 10.3.0.0, 64-bit, Patch Level (none)
      161730.TESTLAB-03!BBL.15902.2248875168.0: LIBTUX_CAT:262: INFO: Standard main starting
      161733.TESTLAB-03!tmboot.15905.1855951168.-2: 10-01-2010: Tuxedo Version 10.3.0.0, 64-bit
      161733.TESTLAB-03!tmboot.15905.1855951168.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds
      161733.TESTLAB-03!tmboot.15905.1855951168.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected
      161735.TESTLAB-03!PSWATCHSRV.15906.1160363616.-2: 10-01-2010: Tuxedo Version 10.3.0.0, 64-bit
      161735.TESTLAB-03!PSWATCHSRV.15906.1160363616.-2: LIBTUX_CAT:262: INFO: Standard main starting
      161750.TESTLAB-03!PSAPPSRV.15941.4117513168.0: 10-01-2010: Tuxedo Version 10.3.0.0, 64-bit
      161750.TESTLAB-03!PSAPPSRV.15941.4117513168.0: LIBTUX_CAT:262: INFO: Standard main starting
      161751.TESTLAB-03!PSAPPSRV.15941.4117513168.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed
      161751.TESTLAB-03!tmboot.15905.1855951168.-2: tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler
      161755.TESTLAB-03!BBL.15902.2248875168.0: CMDTUX_CAT:26: INFO: The BBL is exiting system
      161758.TESTLAB-03!PSADMIN.15894: End boot attempt on domain hc91dmo

      stderr.log

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


      Here is my environment configuration.
      CentOS 5.4 64 bit
      PeopleTools 8.50
      HCM 9.1 MultiLanguage
      WebLogic 11g R1
      Tuxedo 11g R3
      VmWare Server 2
      Oracle 11g

      Thanks ....