This discussion is archived
8 Replies Latest reply: Sep 24, 2013 10:17 AM by user8860348 RSS

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

user8860348 Explorer
Currently Being Moderated

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 Explorer
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    >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 Explorer
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    Folks,

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points