8 Replies Latest reply: Sep 24, 2013 12:17 PM by user8860348 RSS

    Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin

    user8860348

      Folks,

       

      Hello. I am installing PeopleTools 8.53 Internet Architecture. Database Server is Oracle Database 11gR1. OS is Oracle Linux 5. I have installed JDK7, WebLogic 10.3.6, Tuxedo 11gR1 and PeopleTools 8.53 successfully into Oracle Linux 5. I have set up PeopleTools 8.53 Database Instance into Oracle Database Server successfully. Data Mover and Application Designer login into the Database Instance successfully. Web Server has been configured successfully.

       

      Now, I confront the issue regarding configuring Application Server as below:

       

      In Windows, I run /PT8.53/appserv/psadmin.exe to create a domain for the PeopleTools Database Instance successfully. But in Linux, the file /PT8.53/appserv/psadmin is light blue color and not executable, I try to run it in the following way:

       

      [user@userlinux appserv]$ ./psadmin

      Its output: ./psadmin: error while loading shared libraries: libtrio64.so: cannot open shared object file: No such file or directory


      My question is:

      Can any folk tell me how to configure Application Server using psadmin in Linux for PeopleTools Internet Architecture ? How to solve the above issue ?


      Thanks.

        • 2. Re: Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin
          user8860348

          Folks,

           

          Hello. Thanks a lot for replying. Application Server Domain PT853 Configuration is completed successfully. While Oracle Database is listening, I run psadmin to boot the domain PT853 in the following way:

           

          [user@userlinux tuxedo11gR1]$ pwd
          /home/user/Oracle/Middleware/tuxedo11gR1

           

          $ export TUXDIR=/home/user/Oracle/Middleware/tuxedo11gR1
          $ export LD_LIBRARY_PATH=$TUXDIR/lib:$LD_LIBRARY_PATH;
          $ export PATH=$TUXDIR/bin:$PATH;


          [user@userlinux PT8.53]$ . ./psconfig.sh

           

          [user@userlinux appserv]$ ./psadmin

          PSADMIN -- PeopleTools Release: 8.53
          Copyright (c) 1996, 2013, Oracle. All rights reserved.

          --------------------------------
          PeopleSoft Server Administration
          --------------------------------

            PS_CFG_HOME            /home/user/psft/pt/8.53
            PS_HOME                /opt/PT8.53


            1) Application Server
            2) Process Scheduler 
            3) Search Server 
            4) Web (PIA) Server 
            5) Switch Config Home 
            6) Replicate Config Home
            q) Quit


          Command to execute (1-6, q): 1


          --------------------------------------------
          PeopleSoft Application Server Administration
          --------------------------------------------

            1) Administer a domain
            2) Create a domain
            3) Delete a domain
            4) Import domain configuration
            q) Quit

          Command to execute (1-4, q) : 1


          Domain list:

             1) PT853            

          Select domain: 1

           

          --------------------------------
          PeopleSoft Domain Administration
          --------------------------------
               Domain Name: PT853

            1) Boot this domain
            2) Domain shutdown menu
            3) Domain status menu
            4) Configure this domain
            5) TUXEDO command line (tmadmin)
            6) Edit configuration/log files menu
            7) Messaging Server Administration menu
            8) Purge Cache
            9) Preload Cache
          10) Clean IPC resources of this domain
            q) Quit

          Command to execute (1-10, q) : 1


          -------------------------------
          PeopleSoft Domain Boot Menu
          -------------------------------
               Domain Name: PT853

            1) Boot (Serial Boot)
            2) Parallel Boot
            q) Quit

          Command to execute (1-2, q) [q]: 1

          Attempting to boot bulletin board...
          tmadmin - Copyright (c) 1996-2010 Oracle.
          Portions * Copyright 1986-1997 RSA Data Security, Inc.
          All Rights Reserved.
          Distributed under license by Oracle.
          Tuxedo is a registered trademark.
          No bulletin board exists. Entering boot mode.

          > INFO: Oracle Tuxedo, Version 11.1.1.3.0, 64-bit, Patch Level (none)

          Booting admin processes ...

          exec BBL -A :
                  process id=5177 ... Started.
          1 process started.
          Attaching to active bulletin board.

          > Attempting to boot ...
          INFO: Oracle Tuxedo, Version 11.1.1.3.0, 64-bit, Patch Level (none)

          Booting server processes ...

          exec PSWATCHSRV -o ./LOGS/stdout -e ./LOGS/stderr -A -- -ID 115171 -D PT853 -S PSWATCHSRV :
                  process id=5181 ... Started.
          exec PSAPPSRV -o ./LOGS/stdout -e ./LOGS/stderr -s@psappsrv.lst -- -D PT853 -S PSAPPSRV :
                  CMDTUX_CAT:1685: ERROR: Application initialization failure

          tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler

          exec tmshutdown -qy

           

          --------------------------------
          PeopleSoft Domain Administration
          --------------------------------
               Domain Name: PT853

            1) Boot this domain
            2) Domain shutdown menu
            3) Domain status menu
            4) Configure this domain
            5) TUXEDO command line (tmadmin)
            6) Edit configuration/log files menu
            7) Messaging Server Administration menu
            8) Purge Cache
            9) Preload Cache
          10) Clean IPC resources of this domain
            q) Quit

          Command to execute (1-10, q) :

           


          My question is:

          In Windows, I created the domain in the same way and boot the domain with 22 processes successfully.  But in Linux, when boot the domain PT853, I get the above error.  Do we need to install any patch ?  How to solve the above error ?

           

          Thanks.


          • 3. Re: Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin
            Nicolas.Gasparotto

            Well, difficult to say, check and maybe post the APPSERV.LOG file of the domain you are trying to start.

             

            Nicolas.

            • 4. Re: Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin
              user8860348

              Folks,

              Hello. Thanks a lot for replying. I run psadmin in the way below:


              [user@userlinux PT8.53]$ . ./psconfig.sh
              [user@userlinux appserv]$ export TUXDIR=/home/user/Oracle/Middleware/tuxedo11gR1
              [user@userlinux appserv]$ export LD_LIBRARY_PATH=$TUXDIR/lib:$LD_LIBRARY_PATH
              [user@userlinux appserv]$ export PATH=$TUXDIR/bin:$PATH
              [user@userlinux appserv]$ ./psadmin


              For Application Designer login, I use UserId PSADMIN and password PSADMIN, it works successfully.
              For Data Mover Bootstrap Mode login, I use UserId MYNAME and password MYNAME, it works successfully.

               

              When configure Application Server, I use UserID PSADMIN and password PSADMIN. But when boot the domain, the current server log file "APPSRV_0919.LOG" indicates that "Database Signon: Could not sign on to database PT853 with user PSADMIN."

               

              Then I use UserId MYNAME and password MYNAME to configure the Application server again. I boot this domain again. Strangely, the log file APPSRV_0919.LOG gets the same error message "Database Signon: Could not sign on to database PT853 with user PSADMIN."


              I purge the cache and clean IPC resources of this domain, and boot this domain again but get the same error message as above.


              The content of current server log file /home/user/psft/pt/8.53/appserv/PT853/LOGS/APPSRV_0919.LOG is below:


              PSADMIN.5732 (0) [2013-09-19T11:01:10.841](0) Begin boot attempt on domain PT853
              PSAPPSRV.9537 (0) [2013-09-19T11:01:30.338](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
              PSAPPSRV.9537 (0) [2013-09-19T11:01:30.484](0) Cache Directory being used: /home/user/psft/pt/8.53/appserv/PT853/CACHE/PSAPPSRV_1/
              PSAPPSRV.9537 (0) [2013-09-19T11:01:30.539](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64 (200,0)
              PSAPPSRV.9537 (0) [2013-09-19T11:01:30.548](0) Database Options: override_connection_reset: 0
              PSAPPSRV.9537 (0) [2013-09-19T11:01:30.550](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PT853 with user PSADMIN.
              PSAPPSRV.9537 (0) [2013-09-19T11:01:30.551](0) Server failed to start
              PSADMIN.5732 (0) [2013-09-19T11:01:38.906](0) End boot attempt on domain PT853
              PSADMIN.10674 (0) [2013-09-19T11:02:20.766](0) Begin boot attempt on domain PT853
              PSAPPSRV.11239 (0) [2013-09-19T11:02:34.736](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
              PSAPPSRV.11239 (0) [2013-09-19T11:02:34.823](0) Cache Directory being used: /home/user/psft/pt/8.53/appserv/PT853/CACHE/PSAPPSRV_1/
              PSAPPSRV.11239 (0) [2013-09-19T11:02:34.848](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64 (200,0)
              PSAPPSRV.11239 (0) [2013-09-19T11:02:34.854](0) Database Options: override_connection_reset: 0
              PSAPPSRV.11239 (0) [2013-09-19T11:02:34.855](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PT853 with user PSADMIN.
              PSAPPSRV.11239 (0) [2013-09-19T11:02:34.856](0) Server failed to start
              PSADMIN.10674 (0) [2013-09-19T11:02:41.270](0) End boot attempt on domain PT853
              PSADMIN.5107 (0) [2013-09-19T11:56:37.435](0) Begin boot attempt on domain PT853
              PSAPPSRV.5182 (0) [2013-09-19T11:56:57.842](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
              PSAPPSRV.5182 (0) [2013-09-19T11:56:58.068](0) Cache Directory being used: /home/user/psft/pt/8.53/appserv/PT853/CACHE/PSAPPSRV_1/
              PSAPPSRV.5182 (0) [2013-09-19T11:56:58.134](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64 (200,0)
              PSAPPSRV.5182 (0) [2013-09-19T11:56:58.142](0) Database Options: override_connection_reset: 0
              PSAPPSRV.5182 (0) [2013-09-19T11:56:58.144](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PT853 with user PSADMIN.
              PSAPPSRV.5182 (0) [2013-09-19T11:56:58.145](0) Server failed to start
              PSADMIN.5107 (0) [2013-09-19T11:57:05.737](0) End boot attempt on domain PT853
              PSADMIN.4966 (0) [2013-09-19T18:55:48.131](0) Begin boot attempt on domain PT853
              PSAPPSRV.5009 (0) [2013-09-19T18:56:08.869](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
              PSAPPSRV.5009 (0) [2013-09-19T18:56:09.071](0) Cache Directory being used: /home/user/psft/pt/8.53/appserv/PT853/CACHE/PSAPPSRV_1/
              PSAPPSRV.5009 (0) [2013-09-19T18:56:09.130](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64 (200,0)
              PSAPPSRV.5009 (0) [2013-09-19T18:56:09.138](0) Database Options: override_connection_reset: 0
              PSAPPSRV.5009 (0) [2013-09-19T18:56:09.140](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PT853 with user PSADMIN.
              PSAPPSRV.5009 (0) [2013-09-19T18:56:09.141](0) Server failed to start
              PSADMIN.4966 (0) [2013-09-19T18:56:16.253](0) End boot attempt on domain PT853
              PSADMIN.4966 (0) [2013-09-19T19:40:11.049](0) Begin boot attempt on domain PT853
              PSAPPSRV.6475 (0) [2013-09-19T19:40:26.633](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
              PSAPPSRV.6475 (0) [2013-09-19T19:40:26.731](0) Cache Directory being used: /home/user/psft/pt/8.53/appserv/PT853/CACHE/PSAPPSRV_1/
              PSAPPSRV.6475 (0) [2013-09-19T19:40:26.776](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64 (200,0)
              "~/psft/pt/8.53/appserv/PT853/LOGS/APPSRV_0919.LOG" 64L, 7012C


              My question are:

              1) I have changed UserId from PSADMIN to MYNAME and password from PSADMIN to MYNAME in Application Server configuration, why the log file APPSRV_0919.LOG gets the same error message "Database Signon: Could not sign on to database PT853 with user PSADMIN." ?


              2) I purge the cache and clean IPC resources of this domain and reboot this doamin, why the log file APPSRV_0919.LOG gets the same error message "Database Signon: Could not sign on to database PT853 with user PSADMIN." ?


              3) How to solve the above issues ?


              Thanks.

              • 6. Re: Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin
                Nicolas.Gasparotto

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

                What's your plateform/wordsize ? What's your db client version/wordsize ? All must be 64bit on Linux.

                 

                Nicolas.

                • 7. Re: Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin
                  user8860348

                  Folks,

                  Hello. Thanks a lot for replying. My environemnt is below:
                  Database Server is Oracle Database 11gR1. OS is Oracle Linux 5. Installed JDK7, WebLogic 10.3.6, Tuxedo 11gR1 and PeopleTools 8.53 are for Linux. All of above systems are 64-bit for Linux.


                  The thing is that the setup PeopleTools Database Wizard has a problem, I set up PeopleTools 8.53 Database Instance PT853 manually by running the following scripts:

                  1) createdb10.sql
                  2) utlspace.sql
                  3) dbowner.sql
                  4) psadmin.sql
                  5) psroles.sql

                  6) ptddl.sql
                  7) connect.sql


                  Then, we run Data Mover script in a Windows XP Client machine to populate PeopleTools Database instance PT853 in Linux Sever machine. I installed Oracle Database 11gR2 client for 32-bit Windows in my 64-bit Windows XP Virtual Machine and run it successfully.


                  I run psadmin again with 6 exports in the way below:

                  [user@userlinux PT8.53]$ . ./psconfig.sh
                  [user@userlinux appserv]$ export SYSTEM_PASS=SYS/SYS
                  [user@userlinux appserv]$ export ORACLE_HOME=/home/user/OracleDB_Home
                  [user@userlinux appserv]$ export  ORACLE_SID=PT853

                  [user@userlinux appserv]$ export TUXDIR=/home/user/Oracle/Middleware/tuxedo11gR1
                  [user@userlinux appserv]$ export LD_LIBRARY_PATH=$TUXDIR/lib:$LD_LIBRARY_PATH
                  [user@userlinux appserv]$ export PATH=$TUXDIR/bin:$PATH
                  [user@userlinux appserv]$ ./psadmin


                  I get the same 2 errors in the current server log file /home/user/psft/pt/8.53/appserv/PT853/LOGS/APPSRV_0919.LOG as below:

                  First, GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora64 (200,0)
                  Second, GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PT853 with user PSADMIN.


                  I examine my entire system including 2 parts: Linux Database Server and Windows XP Database client. Both Operating Systems are 64-bit and all of softwares are 64-bit except only one 32-bit software that is Oracle Database 11gR2 client for 32-bit Windows installed in my 64-bit Windows XP Virtual Machine.


                  I think the first error causes the second error beacuse Data Mover Bootstrap and Application Designer login successfully using PSADMIN.


                  My question are:

                  Does Windows XP client 32-bit Oracle Database Client cause the above 2 errors ? Or the script createdb10.sql cause the 2 errors ? How to solve the 2 errors ?


                  Thanks.

                  • 8. Re: Install PeopleTools 8.53 with Linux Issue: Configure Application Server using psadmin
                    user8860348

                    Folks,

                    Let's end this thread and start a new discussion because it's long.