Sunday, January 27, 2008

On The Peoplesoft Road : Peoplesoft Process Scheduler

In order to create the Process Scheduler, you have to connect to your application within the "super user" PS (or the default one for your application).

1. In Peopletools/Process Scheduler/Report Nodes menu, add a report node definition :

2. In Peopletools/Process Scheduler/Servers, look for the Server Definition which you want to use (here PSUNX) :

Go on the Distribution tab, and change the report node as the one you created at the step 1 :3. In Peopletools/Security/User Profile, look for the PS user which you want to use to run the Process Scheduler server (here PS), andd add the role ReportDistAdmin :
4. Create the new Process Scheduler
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. All rights reserved.

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


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


Command to execute (1-3, q): 2


-------------------------------------------
PeopleSoft Process Scheduler Administration
-------------------------------------------

1) Start a Process Scheduler Server
2) Stop a Process Scheduler Server
3) Configure a Process Scheduler Server
4) Create a Process Scheduler Server Configuration
5) Delete a Process Scheduler Server Configuration
6) Edit a Process Scheduler Configuration File
7) Import an existing Process Scheduler Configuration
8) Show Status of a Process Scheduler Server
9) Kill a Process Scheduler Server
10) Clean IPC resources of a Process Scheduler Domain

q) Quit

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


Please enter name of Database that server will access :DMOHRMS9

Process Scheduler Configuration templates:

1) unix

Selecting the only Process Scheduler Configuration template available...

Creating Process Scheduler Server for Database DMOHRMS9...
Copying Process Scheduler Server configuration file(s)...
Stripping Annotations...
Process Scheduler Server configuration created.

Would you like to configure this Process Scheduler Server now? (y/n) [y] :

5. Configure the Process Scheduler and load the new config
------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[QEDMO]
9) UserPswd :[QEDMO]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

HINT: Enter 5 to edit DBNAME, then 3 to load

Enter selection (1-15, h, or q): 8


Enter new setting for UserId [QEDMO]:PS



------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[PS]
9) UserPswd :[QEDMO]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

Enter selection (1-15, h, or q): 9


Enter new setting for UserPswd [QEDMO]:PS



------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[PS]
9) UserPswd :[PS]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

Enter selection (1-15, h, or q): 3
Loading validation table...
setting DBName=DMOHRMS9
setting DBType=ORACLE
setting UserId=PS
setting UserPswd=PS
setting ConnectId=people
setting ConnectPswd=peop1e
setting ServerName=
setting PrcsServerName=PSUNX
setting Log/Output Directory=%PS_SERVDIR%/log_output
setting Add to PATH=%PS_HOME%/cblbin
setting SQRBIN=%PS_HOME%/bin/sqr/%PS_DB%/bin
New CFG file written with modified Startup parameters

Spawning enabled for server PSDSTSRV.
Configuration file successfully created.
CFG setting changes completed, loading configuration...
Process Scheduler Server configuration complete.

6. Run the Process Scheduler
-------------------------------------------
PeopleSoft Process Scheduler Administration
-------------------------------------------

1) Start a Process Scheduler Server
2) Stop a Process Scheduler Server
3) Configure a Process Scheduler Server
4) Create a Process Scheduler Server Configuration
5) Delete a Process Scheduler Server Configuration
6) Edit a Process Scheduler Configuration File
7) Import an existing Process Scheduler Configuration
8) Show Status of a Process Scheduler Server
9) Kill a Process Scheduler Server
10) Clean IPC resources of a Process Scheduler Domain

q) Quit

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


Database list:

1) DMOHRMS9

Select item number to start: 1

No Archive subdirectory, creating it...
No psprcs.cfg in the Archive subdirectory, creating it...

Starting Process Scheduler Server PSUNX for Database DMOHRMS9 ...

Booting all admin and server processes in /apps/psoft/hrms9/appserv/prcs/DMOHRMS9/PSTUXCFG
INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV

Booting admin processes ...

exec BBL -A :
process id=13307 ... Started.

Booting server processes ...

exec PSMSTPRC -A -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSMSTPRC :
process id=13321 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13330 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13338 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13346 ... Started.
exec PSDSTSRV -p 1,600:1,1 -sPostReport -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSDSTSRV :
process id=13354 ... Started.
exec PSPRCSRV -sInitiateRequest -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSPRCSRV :
process id=13363 ... Started.
exec PSMONITORSRV -A -- -ID 215198 -C psprcs.cfg -PS PSUNX -S PSMONITORSRV :
process id=13375 ... Started.
8 processes started.


7. In Peopletools/Process Scheduler/System Process Request, add a Run Control, then Run, then choose the Process Scheduler name you are running, and check the process you want to run :

Enjoy with your complete Application up and running.

On The Peoplesoft Road : Web Server - Weblogic

Assuming you've already install the Weblogic.

1. Add the weblogic user (used to install weblogic) in the psoft group


2. Allowed the psoft group to write in the PS_HOME directory


3. As root

[root@orion:/]$ mkdir psreports
[root@orion:/]$ chown root:psoft psreports

[root@orion:/]$ chmod -R g+rw psreports
[root@orion:/]$



4. create web server (from $PS_HOME/setup/PsMpPIAInstall)
[weblogic@orion:/apps/psoft/hrms9/setup/PsMpPIAInstall]$ export DISPLAY=0.0
[weblogic@orion:/apps/psoft/hrms9/setup/PsMpPIAInstall]$ ./setup.linux -console

Initializing Wizard........
Launching InstallShield Wizard........


Welcome to the InstallShield Wizard for PeopleSoft Internet Architecture.

Using the InstallShield Wizard you will install PeopleSoft Internet
Architecture on your computer.

Version: 8.49.08



Note: If installing onto a BEA WebLogic Server, make sure to shutdown any
running web servers to avoid web server corruption.

Select Next to continue or Cancel to exit.

Press 1 for Next, 3 to Cancel or 5 to Redisplay [1]


Choose the directory where you installed PeopleSoft, commonly known as
"PS_HOME":

Please specify a directory name or press Enter [/] /apps/psoft/hrms9 ***generally, your PS_HOME directory***

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]

Choose the installation type that best suits your needs.

[X] 1 - Oracle Application Server

[ ] 2 - BEA WebLogic Server

[ ] 3 - IBM WebSphere Server

To select an item enter its number, or 0 when you are finished: [0] 2

Enter 0 to continue or 1 to make another selection: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Select the web server root directory:

Please specify a directory name or press Enter [/opt/bea] /apps/bea/weblogic/9.2
***generally, your BEA_HOME directory which is common accross your Peopletools installations***

Detected web server version: WebLogic 9.2.1

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Please enter the administrator login and password for WebLogic domain.

Login ID:

[system]

Password:[password]

:

Re-type Password:[password]

:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Select domain type:


[X] 1 - Create New WebLogic Domain

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Enter domain name or click Next to select default:

[peoplesoft]

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]

Please select the configuration to install.

[X] 1 - Single Server Domain
[ ] 2 - Multi Server Domain
[ ] 3 - Distributed Managed Server

To select an item enter its number, or 0 when you are finished: [0]


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Please specify a name for the PeopleSoft web site:

Website name:

[ps] dmohrms9
***generally, your database name***

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Enter port numbers and summaries.

AppServer name:

[orion]

JSL Port:

[9000]
***take the jolt port from your Application server configuration file***

HTTP Port:

[80] 8000

HTTPS Port:

[443] 8443

Authentication Token Domain:(optional)

[]
***make mandatory the domain name if you fill it, good to set it especially for production application***

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Please enter the Name of the Web Profile used to configure the webserver. The
user id and password will be used to retrieve the web profile from the
database. (NOTE: Other available preset web profile names are "TEST", "PROD",
and "KIOSK".)

Web Profile Name:

[DEV]
***generally, DEV for test or dev database, PROD for production, you can change it later***

User ID:

[PTWEBSERVER]
***UserId to start the WebServer***

Password:[PTWEBSERVER]

:

Re-type Password:[PTWEBSERVER]

:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Select the Report Repository location:

Please specify a directory name or press Enter [/opt/psreports] /psreports
***the report repository***

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]


Setup Type :

Web server root directory :

Web server version :

Web server domain :

Internet Architecture app name :

Integration Gateway app name :

PeopleSoft Business Interlink app name :

PeopleSoft Online Library Infrastructure :

Environment Management Hub :

Hello Portlet app name :

Portlet Container app name :

Testsuite app name :

Wsrptest app name :

Site name :

Authentication Token Domain :

Application server name :

JSL port :

HTTP port :

HTTPS port :

Report repository directory :

PIA webserver directory :

weblogic

/apps/bea/weblogic/9.2

9.2

peoplesoft

PORTAL

PSIGW

PSINTERLINKS

PSOL

PSEMHUB

helloportletapp

pspc

testsuite

wsrptest

dmohrms9

.phoenix-nga

orion

9000

8000

8443

/psreports

/apps/psoft/hrms9/webserv

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
[...]
BUILD SUCCESSFUL
Total time: 0 seconds


Deploy Completed. Click next to finish the install.

The InstallShield Wizard has successfully installed PeopleSoft Internet
Architecture. Choose Finish to exit the wizard.

Press 3 to Finish or 5 to Redisplay [3]

[weblogic@orion:/apps/psoft/hrms9/setup/PsMpPIAInstall]$

5. You're now able to start the Web Server from $PS_HOME/webserv/domain_name/bin :
[weblogic@orion:/apps/psoft/hrms9/setup/PsMpPIAInstall]$ cd ../../webserv
[weblogic@orion:/apps/psoft/hrms9/webserv]$ ls
peoplesoft
[weblogic@orion:/apps/psoft/hrms9/webserv]$ cd peoplesoft/
[weblogic@orion:/apps/psoft/hrms9/webserv/peoplesoft]$ ls
applications bin config init-info lib PSLogAnalyzer security user_staged_config
autodeploy businterlink.txt fileRealm.properties keystore piaInstallLog.xml psvault servers
[weblogic@orion:/apps/psoft/hrms9/webserv/peoplesoft]$ cd bin
[weblogic@orion:/apps/psoft/hrms9/webserv/peoplesoft/bin]$ ./startPIA.sh
Attempting to start WebLogic Server PIA
No activity will be logged to this window.
Server activity will be logged to /apps/psoft/hrms9/webserv/peoplesoft/servers/PIA/logs/PIA_*
PID for WebLogic Server PIA is: 18637

6. The Web Server is started when status is RUNNING, wait few seconds before it's avalaible for service open :
[weblogic@orion:/apps/psoft/hrms9/webserv/peoplesoft/bin]$ tail -f /apps/psoft/hrms9/webserv/peoplesoft/servers/PIA/logs/PIA_stdout.log
7. You're able to connect to the Application within a client browser, the default url is htt://IP_server:listening_port/WebSite/signon.html

8. Use PS/PS for a HRMS application, or the default one for your application :

Still the Process Scheduler has to be done.

Enjoy with your application.

On The Peoplesoft Road : Application Server

Before continuing on the installation, please, be sure about your /etc/hosts file :
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost loopback localhost.localdomain
192.168.1.21 orion.phoenix-nga orion


Before continuing on the installation, please, create the links as oracle user :
[ora102@orion:/apps/oracle/10.2.0/lib]DMOHRMS9$ ln -s libclntsh.so libclntsh.so.9.0
[ora102@orion:/apps/oracle/10.2.0/lib]DMOHRMS9$ ls -lrt libclntsh.so*
-rwxr-xr-x 1 ora102 oinstall 18762500 Dec 28 22:38 libclntsh.so.10.1
lrwxrwxrwx 1 ora102 oinstall 17 Dec 28 22:38 libclntsh.so -> libclntsh.so.10.1
lrwxrwxrwx 1 ora102 oinstall 12 Jan 8 21:02 libclntsh.so.9.0 -> libclntsh.so
[ora102@orion:/apps/oracle/10.2.0/lib]DMOHRMS9$

1. Update your .bash_profile (application OS user hrms9)
# .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
unset USERNAME
export ORACLE_HOME=/apps/oracle/10.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PS_HOME=/apps/psoft/hrms9
. $PS_HOME/psconfig.sh


2. Check the access database within the application user hrms9
[hrms9@orion:/home/hrms9]$ sqlplus sysadm/sysadm@DMOHRMS9

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jan 8 20:16:38 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>


3. Create, configure and launch the AppServer
[hrms9@orion:/home/hrms9]$ cd $PS_HOME/appserv
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. 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) : 2


Please enter name of domain to create :DMOHRMS9

Configuration templates:

1) small
2) medium
3) large
4) developer


Select config template number: 1

Creating domain...
Copying application server configuration files...
Stripping Annotations...
Copying Jolt repository file...
Copying Java Query client files...
Domain created.

Would you like to configure this domain now? (y/n) [y] :y



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

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

HINT: Enter 15 to edit DBNAME, then 13 to load

Enter selection (1-26, h, or q): 8


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

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

Enter selection (1-26, h, or q): ***comment***enter the number of the option you want to (de)activate or to change a paramter value***

----------------------------------------------
Quick-configure menu -- domain: DMOHRMS9
----------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 15) DBNAME :[DMOHRMS9]
2) Quick Server : No 16) DBTYPE :[ORACLE]
3) Query Servers : No 17) UserId :[PS]
4) Jolt : Yes 18) UserPswd :[PS]
5) Jolt Relay : No 19) DomainID :[DMOHRMS9]
6) WSL : Yes 20) AddToPATH :[/appl/oracle/10.2.0/bin]
7) PC Debugger : No 21) ConnectID :[people]
8) Event Notification: No 22) ConnectPswd:[peop1e]
9) MCF Servers : No 23) ServerName :[]
10) Perf Collator : No 24) WSL Port :[7000]
11) Analytic Servers : No 25) JSL Port :[9000]
12) Domains Gateway : No 26) JRAD Port :[9100]

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

Enter selection (1-26, h, or q): 13 ***to load your config in a binary file***
Performing load prechecks ...
Loading validation table...
setting DBName=DMOHRMS9
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=DMOHRMS9
setting Add to PATH=/appl/oracle/10.2.0/bin
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.

4. Start the AppServer
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. 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) DMOHRMS9

Select domain number to administer: 1



--------------------------------
PeopleSoft Domain Administration
--------------------------------
Domain Name: DMOHRMS9

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: DMOHRMS9

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 DMOHRMS9/Archive/psappsrv.cfg to DMOHRMS9/Archive/psappsrv_010808_2021_18.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 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV

Booting admin processes ...

exec BBL -A :
process id=9412 ... Started.
1 process started.
Attempting to boot ...
INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV

Booting server processes ...

exec PSWATCHSRV -A -- -ID 248284 -C psappsrv.cfg -D DMOHRMS9 -S PSWATCHSRV :
process id=9414 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PSAPPSRV :
process id=9415 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PSAPPSRV :
process id=9436 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PSAPPSRV :
process id=9444 ... Started.
exec PSSAMSRV -A -- -C psappsrv.cfg -D DMOHRMS9 -S PSSAMSRV :
process id=9452 ... Started.
exec PSMONITORSRV -A -- -ID 248284 -C psappsrv.cfg -D DMOHRMS9 -S PSMONITORSRV :
process id=9459 ... Started.
exec WSL -A -- -n //orion.phoenix-nga:7000 -z 0 -Z 0 -d unused -I 5 -T 60 -m 1 -M 3 -x 40 -c 5000 -p 7001 -P 7003 :
process id=9466 ... Started.
exec JSL -A -- -d unused -n //orion.phoenix-nga:9000 -m 5 -M 7 -I 5 -j ANY -x 40 -S 10 -c 1000000 -w JSH :
process id=9468 ... Started.
exec JREPSVR -A -- -W -P /apps/psoft/hrms9/appserv/DMOHRMS9/jrepository :
process id=9474 ... Started.
9 processes started.

5. Then, from your client machine, configure the Application ass well, within the Configuration Manager first :


Name your remote server IP address, the Application Server name, and the WSL port :
6. Lastly, open the Application Designer
Choose the connection type "Application Server" instead of Oracle.
Verify you're connect onto the databasee through the Application Server.

On The Peoplesoft Road : Peoplesoft Database creation - Part III

The easiest part, and the shortest, the post-requisites :
1. Run application engine from your client, go to $PS_HOME/bin/client/winx86:
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI VERSION
***note CD => dbname, CT => dbtype, CO => user, CP => pwd, R => run control, AI => AppEngine name***

2. Run the $PS_HOME\sqr\SETSPACE.SQR from your client $PS_HOME\bin\sqr\ORA\BINW\sqrw.exe
Use the SYSADM user, and parameter -ZIFE:\apps\psoft\hrms9\sqr\pssqr.ini (replace E:\apps\psoft\hrms9 by your PS_HOME string)

3. Take a backup of your database.

Check the number of objects against your SYSADM's schema :
SQL> conn sysadm/sysadm
Connected.
SQL> select count(*), object_type from user_objects group by object_type;

COUNT(*) OBJECT_TYPE
---------- -------------------
2592 LOB
14 TRIGGER
25921 TABLE
30245 INDEX
18120 VIEW


Now, going on AppServer...

On The Peoplesoft Road : Peoplesoft Database creation - Part II

After loading the Peoplesoft Application (including PeopleTools objects) in the database creation part I, we should upgrade the database to the latest release we curretly use. This step is not required if your application has been built (I mean the Appliatin database version) on the same PeopleTools which you use.
Since we currently install HRMS9.0 on PT8.49, and like for all the version 9.0 it has been built on PT8.48, we should upgrade the Applicatin database version. It consists on several scripts (sql, dms) and application of projects. Some of the following steps below are also for multilingual application, don't apply these step if your only in english.
The scripts to be apply are under $PS_HOME/scripts, the projects under $PS_HOME/projects

1. Run the sql script update of maintenance table (/apps/psoft/hrms9/scripts) :
[hrms9@orion:/apps/psoft/hrms9/scripts]$ sqlplus sysadm/sysadm@DMOHRMS9

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jan 6 20:58:53 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @rel849un.sql
SQL> UPDATE PSSTATUS SET TOOLSREL='8.49',
2 LASTREFRESHDTTM = SYSDATE
3 ;

1 row updated.

SQL>
SQL> CREATE UNIQUE INDEX PSAPSROLECLASS ON PSROLECLASS (CLASSID,
2 ROLENAME) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
3 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
4 ;

Index created.

SQL> ALTER INDEX PSAPSROLECLASS NOPARALLEL LOGGING
2 ;

Index altered.

SQL>
SQL> CREATE INDEX PSCPSTREELEAF ON PSTREELEAF
2 (SETID,
3 TREE_NAME,
4 EFFDT DESC,
5 TREE_NODE_NUM,
6 RANGE_FROM,
7 RANGE_TO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
8 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
9 ;

Index created.

SQL> ALTER INDEX PSCPSTREELEAF NOPARALLEL LOGGING
2 ;

Index altered.

SQL>
SQL> COMMIT
2 ;

Commit complete.

SQL> SPOOL OFF
SQL>

2. Run the grant script to allow the PEOPLE user to read the tables as well (PSSTATUS, PSOPRDEFN, PSACCESSPRFL) :
[hrms9@orion:/apps/psoft/hrms9/scripts]$ sqlplus sysadm/sysadm@DMOHRMS9 @grant.sql

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jan 6 21:03:03 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options


Grant succeeded.


Grant succeeded.


Grant succeeded.


Commit complete.

SQL>


3. As user PS, open the DataMover, modify and run storeddl.dms (comment out the database you are not running on) :


4. In bootstrap mode (user which is the owner of objests), SYSADM in the current case, open DataMover, modify (only the log output file) and run msgtlsupg.dms

5. In Application Designer, as PS user (you cannot connect in bootstrap mode - SYSADM - within the AppDesigner), copy the project PPLTLS84CUR
=> Don't build it now !
Take care, the project is very big and take age to copy (network avaibility !)
Some messages can be ignore. Don't build the project now !

6. In Application Designer, as PS user, copy the project PPLTLS84CURML or if you installed French, copy the project PPLTLSML
=> Don't build it !
Don't build the project !

7. In Application Designer, as PS user, copy the project PPLTLS84CURDEL
=> Don't build it !
Don't build the project !

8. In Application Designer, as PS user, open and build the project PPLTLS84CUR
Open the settings to set all the parameters as well :Name a sql script to be run after project building :Take care to all the alter and create tabs options :Some warning are raised, you can ignore them.

9. Run the SQL script created by the previous project's build in SQL*Plus
At this step, you shouldn't have any error, check the spool file as well.

10. In Application Designer, as PS user, copy and build the project PT84TBLSPC
In the copy option, take care to check the DDL from source option :Build the project :Take care of the build settings, they are a different than previously :
No warnings, no errors.

11. Run the SQL script created by the previous project's build in SQL*Plus

12. Update the Peopletools system data, run the following DMS scripts in bootstrap mode (from $PS_HOME/scripts) : pt849tls.dms, pslanguages.dms, tlsupgnoncomp.dms

13. For ML application, run the following statement in DMS (take from the install doc the three letter code of your language, FRA is for french) :
UPDATE PSLANGUAGES SET INSTALLED = 1 WHERE LANGUAGE_CD='FRA';

14. In DMS, as PS user, run the following DMS scripts (from $PS_HOME/scripts):
pt849tlsfra.dms (if you installed French db), msgtleng.dms, ptstreng.dms, $PS_HOME/src/cbl/base/storept.dms, ptdefnsec.dms
and createvw.dms, this last one will (re)create around 18000 views, so take care to the time to apply.

15. Run application engine from your client, go to $PS_HOME/bin/client/winx86:
This query define the user who can run the AEs
SQL> select roleuser, rolename from psroleuser where rolename in ('PeopleSoft Administrator', 'Portal Administrator');

ROLEUSER ROLENAME
------------------------------ ------------------------------
PSEM PeopleSoft Administrator
PSHC PeopleSoft Administrator
PS Portal Administrator
PSEM Portal Administrator

Better to use PS, then in a DOS Window :
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPG844PORTAL
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGQRYDUPHED
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPTSMDAT
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPT846PP
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPT848PP
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPT848IBUG (addendum : you should NOT run this AE if the Application you are installing has been built on Peopletools 8.48 or later)

***note CD => dbname, CT => dbtype, CO => user, CP => pwd, R => run control, AI => AppEngine name***

16. In Application Designer, as PS user, open the project PTUPGIBCLONE and copy to a file

(addendum : if the Application you are installing has been built on Peopletools 8.48 or later go directly to step 20)

17. In DMS, as PS user, run $PS_HOME/scripts/ptupg_trx_export.dms

18. In Application Designer, as PS user, open the project PTUPGIBDELETE and copy to a file.

19. In Application Designer, as PS user, copy the project PTUPGIBDELETE from the file previously created, since the project already exists in database, you should be sure to check "From File"
20. Within SQL*Plus, run the grant.sql script.

The PeopleTools upgrade is finished.