Monday, August 27, 2012

psadmin Utility in Oracle PeopleSoft Application



Hi DBAs,
       psadmin is very vital utility for PeopleSoft DBAs. PeopleSoft administration like start/stop,purging of cache,PeopleSoft Application server Administration,Process Scheduler administration and lot of administration tasks related to PeopleSoft Applications can be done with utiliy  'psadmin'.
This utility is similar to adadmin utility in Oracle EBS Application.Since I'm from Oracle Apps DBA background,so I always compare and do PeopleSoft administration tasks,it also help me to sharp my apps dba skills.Let me share the below task of Starting/Stopping the PeopleSoft Application server.Here I'm using 'psoftsvc' OS user which is quite similar to 'applmgr' OS user in EBS applications.PeopleSoft Server  Administration can be done using 'psadmin' utility.


Stopping PeopleSoft Applications:
=======================================

Login with 'psoftsvc' user and set the PeopleSoft environment by executing 'psconfig.sh' file(as we do in Oracle EBS application by executing APPSContext.env file) and then run the psadmin utility.

login as: psoftsvc
Using keyboard-interactive authentication.
Password:
Last login: Sun Aug 19 12:33:42 2012 from 10.157.223.9
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
TERM = xterm
psoftsvc@[PeopleSoftApps_1]->su - psoftsvc

Password:

TERM = xterm
Please enter the menu command to get started.
PeopleSoftApps_1(/product/psoftsvc >menu
Select a Peoplesoft Environment:
1) PeopleSoftApps_1
2) PeopleSoftApps_2
3) Statistics
4) Quit
Selection:1
Welcome to the Peoplesoft PeopleSoftApps_1 Environment.
Tuxedo Installation Directory: /product/bea/tuxedo81
Cobol Installation Directory:  /product/microfocus/cobol

psoftsvc@PeopleSoftApps_1(PeopleSoftApps_1):/product/psoft/PeopleSoftApps_1>cd appserv
/product/psoft/PeopleSoftApps_1/appserv
psoftsvc@PeopleSoftApps_1(PeopleSoftApps_1):/product/psoft/PeopleSoftApps_1/appserv>./psadmin

PSADMIN -- Tools Release: 8.48.11
Copyright (c) 1988-2005 PeopleSoft, Inc.  All Rights Reserved.

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


  1) Application Server
  2) Process Scheduler
  3) Search Server
  q) Quit


Command to execute (1-3, 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


Tuxedo domain list:

  1)  PeopleSoftApps_1

Select domain number to administer: 1


--------------------------------
PeopleSoft Domain Administration
--------------------------------
     Domain Name: PeopleSoftApps_1

  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 File Cache
 10) Clean IPC resources of this domain
  q) Quit

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


-------------------------------
PeopleSoft Domain Boot Menu
-------------------------------
     Domain Name: PeopleSoftApps_1

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

Command to execute (1-2, q) [q]: 1
psappsrv.cfg has changed archiving old one...
Copying PeopleSoftApps_1/Archive/psappsrv.cfg to PeopleSoftApps_1/Archive/psappsrv_080712_2252_05.cfg
Attempting to boot bulletin board...
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
INFO: BEA Tuxedo, Version 8.1, 64-bit, Patch Level 192
INFO: Serial #: 650522264138-1184269388129, Expiration NONE, Maxusers 1000000
INFO: Licensed to: PeopleSoft - ISV

Booting admin processes ...

exec BBL -A :
        CMDTUX_CAT:821: INFO: Duplicate server.
0 processes started.
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
Attempting to boot ...
INFO: BEA Tuxedo, Version 8.1, 64-bit, Patch Level 192
INFO: Serial #: 650522264138-1184269388129, Expiration NONE, Maxusers 1000000
INFO: Licensed to: PeopleSoft - ISV

Booting server processes ...

exec PSWATCHSRV -A -- -ID 44130 -C psappsrv.cfg -D PeopleSoftApps_1 -S PSWATCHSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSQCKSRV -s@../psqcksrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSQCKSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSQRYSRV -p 1,250:5,10 -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSQRYSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSSAMSRV -A -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSSAMSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSBRKHND -p 1,250:5,10 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSBRKHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSBRKHND -p 1,250:5,10 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSBRKHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSBRKHND -p 1,250:5,10 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSBRKHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSBRKHND -p 1,250:5,10 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSBRKHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSBRKDSP -s PSBRKDSP_dflt:Dispatch -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSBRKDSP_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSPUBHND -p 1,250:5,10 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSPUBHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSPUBHND -p 1,250:5,10 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSPUBHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSPUBHND -p 1,250:5,10 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSPUBHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSPUBHND -p 1,250:5,10 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSPUBHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSPUBDSP -s PSPUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSPUBDSP_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSSUBHND -p 1,250:5,10 -s PSSUBHND_dflt:SubConProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSSUBHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSSUBHND -p 1,250:5,10 -s PSSUBHND_dflt:SubConProcess -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSSUBHND_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSSUBDSP -s PSSUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSSUBDSP_dflt :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec PSMONITORSRV -A -- -ID 44130 -C psappsrv.cfg -D PeopleSoftApps_1 -S PSMONITORSRV :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec WSL -A -- -n //PeopleSoftApps_1:7000 -z 0 -Z 0 -d /dev/tcp -I 5 -T 30 -m 1 -M 2 -x 40 -c 100000 -p 7001 -P 7002 :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec JSL -A -- -d /dev/tcp -n //PeopleSoftApps_1:9000 -m 20 -M 20 -I 5 -j ANY -x 30 -S 5 -c 10000000 -w JSH :
        CMDTUX_CAT:821: INFO: Duplicate server.
exec JREPSVR -A -- -W -P /product/psoft/PeopleSoftApps_1/appserv/PeopleSoftApps_1/jrepository :
        CMDTUX_CAT:821: INFO: Duplicate server.
0 processes started.


Starting PeopleSoft Applications:
===================================

TERM = xterm
psoftsvc@[PeopleSoftApps_1]->su - psoftsvc

Password:

TERM = xterm
Please enter the menu command to get started.
PeopleSoftApps_1(/product/psoftsvc >cd appserv
ksh: appserv:  not found
PeopleSoftApps_1(/product/psoftsvc >menu
Select a Peoplesoft Environment:
1) PeopleSoftApps_1
2) PeopleSoftApps_2
3) Statistics
4) Quit
Selection:1
Welcome to the Peoplesoft PeopleSoftApps_1 Environment.
Tuxedo Installation Directory: /product/bea/tuxedo81
Cobol Installation Directory:  /product/microfocus/cobol

psoftsvc@PeopleSoftApps_1(PeopleSoftApps_1):/product/psoft/PeopleSoftApps_1>cd appserv
/product/psoft/PeopleSoftApps_1/appserv
psoftsvc@PeopleSoftApps_1(PeopleSoftApps_1):/product/psoft/PeopleSoftApps_1/appserv>./psadmin

PSADMIN -- Tools Release: 8.48.11
Copyright (c) 1988-2005 PeopleSoft, Inc.  All Rights Reserved.

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


  1) Application Server
  2) Process Scheduler
  3) Search Server
  q) Quit


Command to execute (1-3, 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


Tuxedo domain list:

  1)  PeopleSoftApps_1

Select domain number to administer: 1



--------------------------------
PeopleSoft Domain Administration
--------------------------------
     Domain Name: PeopleSoftApps_1

  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 File Cache
 10) Clean IPC resources of this domain
  q) Quit

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


-------------------------------
PeopleSoft Domain Boot Menu
-------------------------------
     Domain Name: PeopleSoftApps_1

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

Command to execute (1-2, q) [q]: 1
psappsrv.cfg has changed archiving old one...
Copying PeopleSoftApps_1/Archive/psappsrv.cfg to PeopleSoftApps_1/Archive/psappsrv_081912_1238_55.cfg
Attempting to boot bulletin board...
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
No bulletin board exists. Entering boot mode.
INFO: BEA Tuxedo, Version 8.1, 64-bit, Patch Level 192
INFO: Serial #: 650522264138-1184269388129, Expiration NONE, Maxusers 1000000
INFO: Licensed to: PeopleSoft - ISV

Booting admin processes ...

exec BBL -A :
        process id=2356 ... Started.
1 process started.
Attempting to boot ...
INFO: BEA Tuxedo, Version 8.1, 64-bit, Patch Level 192
INFO: Serial #: 650522264138-1184269388129, Expiration NONE, Maxusers 1000000
INFO: Licensed to: PeopleSoft - ISV

Booting server processes ...

exec PSWATCHSRV -A -- -ID 44130 -C psappsrv.cfg -D PeopleSoftApps_1 -S PSWATCHSRV :
        process id=2391 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2393 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2413 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2417 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2421 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2443 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2447 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2451 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2463 ... Started.
exec PSAPPSRV -p 1,250:5,10 -s@../psappsrv.lst -- -C psappsrv.cfg -D PeopleSoftApps_1 -S PSAPPSRV :
        process id=2467



Enjoy PeopleSoft DBA tasks,


Best regards,

Rafi.

5 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. PeopleSoft online training by the smart mind online training b Inc. makes software for businesses and organizations for Human Resource Management Systems, Financial Management Solutions, Customer Relationship Management and more. All of PeopleSoft's software can be easily accessed through a web browser, making it easier than ever to stay PeopleSoft online training organized through the use of technology. Getting trained is easy and accessible to everyone with course offerings for both online and in the classroom.

    ReplyDelete
  3. Thanks for giving Good Example.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Peoplesoft DBA. Thanks a lot.It is uaefull to me and my training Ithubonlinetraining center.

    ReplyDelete
  4. Thanks for giving Good Example, It is very useful to us.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Microstrategy. Thanks a lot.It is uaefull to me and my training Microstrategyonlinetraining center.

    ReplyDelete