Tuesday, November 01, 2011

Peopletools 8.52 : psadmin

There are few interesting changes in the Peopletools 8.52 psadmin menu :
PeopleSoft Server Administration
--------------------------------

  Config Home:  /appl/psoft/hcm91fp1_dom

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

Option 4 and 5 have been added compared to the previous Peopletools version.
The option 5 is rather good, be able to change the PS_CFG_HOME on-line without exiting from the program. Managing different home is now greatly simplified :
Command to execute (1-6, q): 5

Please provide new Config Home location or q to quit:

The option 4, managing the PIA within the psadmin is useful if and only if the webserver is hosted on the same server.
[ptools852@orion5 appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.52.02
Copyright (c) 1996, 2011, Oracle. All rights reserved.

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

  Config Home:  /appl/psoft/hcm91fp1_dom

  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): 4

-----------------------------
PeopleSoft PIA Administration
-----------------------------

  PIA Home:   /appl/psoft/hcm91fp1_web

  1) Administer a domain
  2) Create a domain
  3) Delete a domain

Here we can see the output of the PIA_HOME variable, if it is not set in the environment, it is set by default to PS_CFG_HOME (Config Home).
Well, I’m not sure how to quantify the customer having such configuration (Peopletools installed onto the webserver), but as far as I know from the shops I worked for, that’s rather rare. Anyway, I’ll test this option in a coming blog entry.

There’s also some new options in the psadmin command line, PIA management, delete an application domain, find out more within the command “psadmin –help”.
Find out more in the OTN hosted Peoplebooks : http://download.oracle.com/docs/cd/E25688_01/pt852pbr0/eng/psbooks/tsvt/book.htm?File=tsvt/htm/tsvt06.htm#H2001

Now, building a new environment for Peopletools 8.52 on Oracle Linux 6.1 (well, it is not certified yet, but looks to work like a charm), create a new application domain can return the following error :
----------------------------------------------
Quick-configure menu -- domain: hcm91fp1
----------------------------------------------
      Features                      Settings
     ==========                    ==========
  1) Pub/Sub Servers   : No    16) DBNAME     :[hcm91fp1]
  2) Quick Server      : No    17) DBTYPE     :[ORACLE]
  3) Query Servers     : No    18) UserId     :[PS]
  4) Jolt              : Yes   19) UserPswd   :[PS]
  5) Jolt Relay        : No    20) DomainID   :[hcm91fp1]
  6) WSL               : No    21) AddToPATH  :[.]
  7) PC Debugger       : No    22) ConnectID  :[people]
  8) Event Notification: No    23) ConnectPswd:[peop1e]
  9) MCF Servers       : No    24) ServerName :[]
10) Perf Collator     : No    25) WSL Port   :[7000]
11) Analytic Servers  : No    26) JSL Port   :[9000]
12) Domains Gateway   : No    27) JRAD Port  :[9100]

      Actions
     =========
13) Load config as shown
14) Custom configuration
15) Edit environment settings
  h) Help for this menu
  q) Return to previous menu

Enter selection (1-27, h, or q): 13
Performing load prechecks ...
/appl/psoft/ptools852/bin/ubbgen: error while loading shared libraries: libtux.so: cannot open shared object file: No such file or directory

==============ERROR!================
UBBGEN encountered an error while configuring!

==============ERROR!================

It is nothing but LD_LIBRARY_PATH not set. Adding it in the .bash_profile as below :
[ptools852@orion5 ~]$ more .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

TUXDIR=/appl/mdlware/tuxedo; export TUXDIR
ORACLE_BASE=/appl/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
ORACLE_BIN=$ORACLE_HOME/bin

PS_HOME=/appl/psoft/ptools852; export PS_HOME
PS_CFG_HOME=/appl/psoft/hcm91fp1_dom; export PS_CFG_HOME
PIA_HOME=/appl/psoft/hcm91fp1_web; export PIA_HOME

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$TUXDIR/lib; export LD_LIBRARY_PATH

PATH=$TUXDIR/bin:$ORACLE_BASE:$ORACLE_HOME:$ORACLE_BIN:$PATH

. $PS_HOME/psconfig.sh
[ptools852@orion5 ~]$

Now, disconnect, reconnect and rerun the configuration menu, it should work :
----------------------------------------------
Quick-configure menu -- domain: hcm91fp1
----------------------------------------------
      Features                      Settings
     ==========                    ==========
  1) Pub/Sub Servers   : No    16) DBNAME     :[hcm91fp1]
  2) Quick Server      : No    17) DBTYPE     :[ORACLE]
  3) Query Servers     : No    18) UserId     :[PS]
  4) Jolt              : Yes   19) UserPswd   :[PS]
  5) Jolt Relay        : No    20) DomainID   :[hcm91fp1]
  6) WSL               : No    21) AddToPATH  :[.]
  7) PC Debugger       : No    22) ConnectID  :[people]
  8) Event Notification: No    23) ConnectPswd:[peop1e]
  9) MCF Servers       : No    24) ServerName :[]
10) Perf Collator     : No    25) WSL Port   :[7000]
11) Analytic Servers  : No    26) JSL Port   :[9000]
12) Domains Gateway   : No    27) JRAD Port  :[9100]

      Actions
     =========
13) Load config as shown
14) Custom configuration
15) Edit environment settings
  h) Help for this menu
  q) Return to previous menu

Enter selection (1-27, h, or q): 13
Performing load prechecks ...
Loading validation table...
  setting DBName=hcm91fp1
  setting DBType=ORACLE
  setting UserId=PS
  setting UserPswd=PS
  setting ConnectId=people
  setting ConnectPswd=peop1e
  setting ServerName=
  setting Port=7000
  setting Port=9000
  setting Listener Port=9100
  setting Domain ID=hcm91fp1
  setting Add to PATH=.
New CFG file written with modified Startup parameters

Log Directory entry not found in configuration file.
Setting Log Directory to the default... [PS_SERVDIR/LOGS]
Spawning disabled for server PSAPPSRV.
Configuration file successfully created.
CFG setting changes completed
Loading configuration...
Domain configuration complete.

Nothing new here, it has always been like that on Linux, but that’s always good to remind it. 

As an other side note, creating a new process scheduler domain, you also may encounter the following warning (I don’t like warning, they sound like repeating error !) :
WARNING: PSDSTSRV is configured with Min instance set to 1. To avoid loss of service, configure Min instance to atleast 2.
Rather strange to have this when creating a default prcs, better to change it now, modify the configuration file $PS_CFG_HOME/appserv/prcs/hcm91fp1/psprcs.cfg and reload.

Nicolas.

2 comments:

vissu said...

Hi: I have the exact same error..but when i checked the environment path variables, they are already set correctly.

Please help me in resolving this.

angiemo said...

execute chmod 777 for tuxedo dir.