On The Peoplesoft Road: January 2008

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.

Thursday, January 10, 2008

On The Peoplesoft Road : Peoplesoft Database creation - Part I

Please, before to run the installation ensure you understood the concepts explain previously here.

This first part of the Peoplesoft Database Creation concern the Oracle database creation itself and the Application (including PeopleTools) data.
Of course, you need to have install the Database server previously, see here.

Peoplesoft provide scripts to create the database, you can find all the required scripts under $PS_HOME/scripts/unix. Because we'll need to modify some of these files, it's better to copy all the files under a working directory, or like me, under $ORACLE_BASE/admin/$ORACLE_SID/create folder.

So, I'll use that ones.
Step 1 to 14 have to be run on the database server.

1. Modify the script createdb10.sql (for the 10g customer), character set and strings :
[ora102@orion:/oradata/DMOHRMS9/create]$ vi createdb10.sql
set termout on
set echo on
spool createdb.log

startup nomount pfile=$ORACLE_HOME/dbs/initDMOHRMS9.ora
CREATE DATABASE "DMOHRMS9"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/oradata/DMOHRMS9/datafiles/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oradata/DMOHRMS9/datafiles/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/DMOHRMS9/datafiles/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "PSUNDOTS" DATAFILE '/oradata/DMOHRMS9/datafiles/psundots01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('/oradata/DMOHRMS9/redologs/redo01.log') SIZE 51200K,
GROUP 2 ('/oradata/DMOHRMS9/redologs/redo02.log') SIZE 51200K,
GROUP 3 ('/oradata/DMOHRMS9/redologs/redo03.log') SIZE 51200K;
spool off

2. Create the directories to receive your new database, and your init.ora file. Please refer to the Oracle Database Documentation http://docs.oracle.com

3. Ensure your NLS_LANG env variable is set correctly.

4. Create the password file

5. Add the tns entry for the new database in tnsnames.ora (and listener.ora for fixed addressing)

6. Set the ORACLE_SID, and run the creation database script :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jan 6 14:50:12 2008

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

Connected to an idle instance.

SQL> @createdb10.sql
SQL>
SQL> startup nomount pfile=$ORACLE_HOME/dbs/initDMOHRMS9.ora

ORACLE instance started.

Total System Global Area 767557632 bytes
Fixed Size 1264136 bytes
Variable Size 205522424 bytes
Database Buffers 557842432 bytes
Redo Buffers 2928640 bytes
SQL> CREATE DATABASE "DMOHRMS9"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE '/oradata/DMOHRMS9/datafiles/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 SYSAUX DATAFILE '/oradata/DMOHRMS9/datafiles/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
10 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/DMOHRMS9/datafiles/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
11 SMALLFILE UNDO TABLESPACE "PSUNDOTS" DATAFILE '/oradata/DMOHRMS9/datafiles/psundots01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
12 CHARACTER SET AL32UTF8
13 NATIONAL CHARACTER SET UTF8
14 LOGFILE GROUP 1 ('/oradata/DMOHRMS9/redologs/redo01.log') SIZE 51200K,
15 GROUP 2 ('/oradata/DMOHRMS9/redologs/redo02.log') SIZE 51200K,
16 GROUP 3 ('/oradata/DMOHRMS9/redologs/redo03.log') SIZE 51200K;

Database created.

7. Modify and run the utlspace.sql script (dictionaries views)
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ vi utlspace.sql
-- ******************************************************************

REM * Set terminal output and command echoing on; log output of this script.
REM *
set termout on

REM * The database should already be started up at this point from createdb.sql

set echo off
spool utlspace.log

REM * Creates data dictionary views. Must be run when connected AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql;

REM * Creates views of oracle locks
@$ORACLE_HOME/rdbms/admin/catblock.sql;

REM * Scripts for procedural option. Must be run when connected AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catproc.sql;

set echo on

REM * Create a temporary tablespace for database users.
REM *
CREATE TEMPORARY TABLESPACE PSTEMP
TEMPFILE '/oradata/DMOHRMS9/datafiles/pstemp01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
;

REM * Create a tablespace for database users default tablespace.
REM *
CREATE TABLESPACE PSDEFAULT
DATAFILE '/oradata/DMOHRMS9/datafiles/psdefault.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
;

spool off

[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @utlspace.sql

8. Modify (don't change the PS user name) and run the dbowner.sql script
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ vi dbowner.sql
-- ******************************************************************

set echo on
spool dbowner.log

GRANT CONNECT, RESOURCE, DBA TO PS IDENTIFIED BY PS;
CONNECT PS/PS;
CREATE TABLE PSDBOWNER (DBNAME VARCHAR2(8) NOT NULL, OWNERID VARCHAR2(8) NOT NULL ) TABLESPACE PSDEFAULT;
CREATE UNIQUE INDEX PS_PSDBOWNER ON PSDBOWNER (DBNAME) TABLESPACE PSDEFAULT;
CREATE PUBLIC SYNONYM PSDBOWNER FOR PSDBOWNER;
GRANT SELECT ON PSDBOWNER TO PUBLIC;
CONNECT system/manager;
REVOKE CONNECT, RESOURCE, DBA FROM PS;

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @dbowner.sql

9. . To create the specific tablespaces (for HRMS hcddl.sql), modify and run hcddl.sql :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ vi hcddl.sql
-- **************************************************************
REMARK * This script is used to create tablespaces for the PeopleSoft 9 HRMS Products
REMARK * on Oracle UNIX.
REMARK * Date last modified: 01/30/2007

REMARK * NOTE: The sizing of the tablespaces here are only sample sizes that will
REMARK * hold the demo database tables. This is not sized correctly for a
REMARK * production database.

REMARK * Users can choose to use the autoextending tablespace feature.
REMARK * The syntax is at the end of this script.

set echo on
spool hcddl.log

CREATE TABLESPACE AAAPP DATAFILE '/oradata/DMOHRMS9/datafiles/aaapp.dbf' SIZE 21M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/
[...]
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @hcddl.sql
[...]
You may want to set AUTOEXTEND to ON to avoid space extension problem against the tablespace during the application load.

10. Check and run the database ROLES creation : [ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ more psroles.sql
-- ******************************************************************

REMARK -- These are the minimum privileges required to run PeopleSoft
REMARK -- applications. If you plan to run SQL<>Secure, you will need to
REMARK -- grant "execute any procedure" to PSUSER and PSADMIN.

set echo on
spool psroles.log

DROP ROLE PSUSER;
DROP ROLE PSADMIN;

CREATE ROLE PSUSER;
GRANT CREATE SESSION TO PSUSER;

CREATE ROLE PSADMIN;
GRANT
ANALYZE ANY,
ALTER SESSION, ALTER TABLESPACE, ALTER ROLLBACK SEGMENT,
CREATE CLUSTER, CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK,
CREATE PUBLIC SYNONYM, CREATE SEQUENCE, CREATE SNAPSHOT,
CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW,
CREATE PROCEDURE, CREATE TRIGGER, CREATE TABLESPACE, CREATE USER,
CREATE ROLLBACK SEGMENT,
DROP PUBLIC DATABASE LINK, DROP PUBLIC SYNONYM, DROP ROLLBACK SEGMENT,
DROP TABLESPACE, DROP USER, MANAGE TABLESPACE, RESOURCE,
EXP_FULL_DATABASE, IMP_FULL_DATABASE,
GRANT ANY ROLE, ALTER USER, BECOME USER
TO PSADMIN WITH ADMIN OPTION;

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @psroles.sql

11. Check and modify if necessary the ceation of the owner of the Peoplesoft objects (psadmin.sql script). Commonly, The admin user is named SYSADM, the default tablespace is PSDEFAULT :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ more psadmin.sql
-- ******************************************************************

REMARK -- This script sets up the PeopleSoft Owner ID. An Oracle DBA is
REMARK -- required to run this script.

set echo on
spool psadmin.log

ACCEPT ADMIN CHAR PROMPT 'Enter name of PeopleSoft Owner ID: '
ACCEPT PASSWORD CHAR PROMPT 'Enter PeopleSoft Owner ID password:'
PROMPT
PROMPT Enter a desired default tablespace for this user.
PROMPT
PROMPT Please Note: The tablespace must already exist
PROMPT If you are unsure, enter PSDEFAULT or SYSTEM
PROMPT
ACCEPT TSPACE CHAR PROMPT 'Enter desired default tablespace:'

REMARK -- Create the PeopleSoft Administrator schema.

create user &ADMIN identified by &PASSWORD default tablespace &TSPACE
temporary tablespace pstemp;
grant PSADMIN TO &ADMIN;

REMARK -- PeopleSoft Administrator needs unlimited tablespace in order to
REMARK -- create the PeopleSoft application tablespaces and tables in Data
REMARK -- Mover. This system privilege can only be granted to schemas, not
REMARK -- Oracle roles.

grant unlimited tablespace to &ADMIN;

REMARK -- Run the commands below to create database synonyms.
REMARK -- Modify the connect string appropriately for your organization.

connect system/manager

set echo off

@$ORACLE_HOME/rdbms/admin/catdbsyn
@$ORACLE_HOME/sqlplus/admin/pupbld

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @psadmin.sql

12. Check and modify if necessary the creation script of the security check user people - connector user -, take care the default password is peop1e (1, one, instead of the letter l) :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ more connect.sql
-- ******************************************************************

REMARK -- This script sets up the PeopleSoft Connect ID.
REMARK -- An Oracle DBA is required to run this script prior
REMARK -- to loading a PSOFT database.
REMARK --
REMARK -- If you wish to use the default CONNECTID and PASSWORD,
REMARK -- then run this script as is.
REMARK -- If you wish to change the default CONNECTID and PASSWORD,
REMARK -- DELETE the default CREATE and GRANT statements below and
REMARK -- uncomment the template version modifying the following
REMARK -- parameters , ,
REMARK --

REMARK -- Create the PeopleSoft Administrator schema.

set echo on
spool connect.log

REMARK -- drop user people cascade;

create user people identified by peop1e default tablespace PSDEFAULT
temporary tablespace PSTEMP;

GRANT CREATE SESSION to people;

REMARK -- drop user cascade;

REMARK -- create user identified by default tablespace
REMARK -- temporary tablespace ;

REMARK -- GRANT CREATE SESSION to ;

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @connect.sql

13. For Unicode database, if you don't want to raise the following error on the application datamover load : ''Character Length Semantics (CLS) is not enabled'' , you may want to add the following line in your parameters file : NLS_LENGTH_SEMANTICS=CHAR, or modify the spfile :
SQL> alter system set NLS_LENGTH_SEMANTICS=CHAR scope=both;

System altered.

14. Lastly, create spfile and bounce your database :

SQL> create spfile from pfile='/apps/oracle/admin/DMOHRMS9/pfile/initDMOHRMS9.ora';

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
show parameter ORACLE instance started.

Total System Global Area 767557632 bytes
Fixed Size 1264136 bytes
Variable Size 205522424 bytes
Database Buffers 557842432 bytes
Redo Buffers 2928640 bytes
Database mounted.
Database opened.

From step 15, you have to be on your client machine.

15. Set up your environement on your client machine, started by the connector password (people user), run the Configuration of your client environment Peopletools :

Set the connect Id and connect password as defined at the step 12.

16. Start the DataMover tool from of your client environment Peopletools :

Give the Database Name (you need previously to modify your tnsnames.ora of your Oracle client install), the admin user name and password create at the step 11 (commonly SYSADM) :

17. Run the the Database Setup within the DataMover.

18. Choose the type of Database, Unicode or non-Unicode and the chareacter set.

19. Choose the type of database you want (DEMO, SYSTEM) or if you want to add product or language to an existing database :

20. Add the languages you want to see in your application :

21. Give the database name (will be included in the PSDBOWNER table), symbolic id shouldn't be change, leave SYSADM1, Access ID is the admin user created at the step 11 (commonly SYSADM), Connect ID is PEOPLE (better to not change it). Well, on this screen just change the access password if you changed it at the step 11.

22. The base language should be English, unless for some specific needs.

23. At the end, a script has been created, checkit and run it (take care of the time to apply, since it require Mb od dataload in your dataase through the network, it can take hours on slow network) :

It's finish for the basics tasks.
If you're sure your application database version (the Peopletools version which your application has been built on) is same as your current database, go directly at the Peoplesoft Database creation part III, else go to the Peoplesoft Database creation part II.

On The Peoplesoft Road : Peoplesoft HRMS 9.0 ML Windows client

In order to create the database, and load the Application data, we have to install the Application in the Peoplesoft directory path on the Windows client machine.
Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - Human Resources Management System and Campus Solutions 9.0 Translations Media Pack", then disk named as
"PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 Multi-Language"
"PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 (CD)"

You'll need the license code from http://licensecodes.oracle.com/ent_keys_by_prod.html#HCM and for the tranlsation from http://licensecodes.oracle.com/ent_keys_by_prod.html#Translations
I'll install English and French, but if you're just in English, ignore the last step as well.
The first is the non ML install :

Choose Unicode or Non-Unicode respecting what you choosed for the Peopletools installation where you'll install that Application :

For the Windows Server, on which you can run Process Scheduler, even if the database is on a Unix/Linux machine, for example n/Vision reports, that can help, check what you need to configure :

Give the path directory of the Peopletools you previously installed :

Then uncheck the module you don't want to install :

Now, same for the ML, take care, the license code is the one for Tranlsation, regardless of the Application and Tools you install :

[...]
The screenshots are almost the same, eventhough, two difference :
1. You have not to choose which module you want to install
2. You have to choose your language :

Next step, now we are ready for, database creation.

Have fun,

Monday, January 07, 2008

On The Peoplesoft Road : Peoplesoft Database creation

The Database creation will be the main step on the Peopelsoft road installation.

First of all and before to go on an unknown road, some basics have to be known : difference between PeopleTools and PeopleSoft Application, the PeopleTools based version of the PeopleSoft Application, what are DEMO/SYS/PeopleTools System databases, what are DataMover and Application Designer, what is the bootstrap mode, what does the PS and people users.
I'll try to explain as simple as I can, and don't hesitate to add comments if you see bugs.

1. Difference between PeopleTools and PeopleSoft Application
The PeopleTools are a set of tools (external of the database) like DataMover and Application Designer. But they are also a Application Server and Process Scheduler.
The PeopleTools are a set of database objects (embedded onto the database). These objects hosts all the environement to allow the Application to run as well, like all the page definition, all the processes, a metamodel (tables definition, views definition, index definition, tablespace definition...). This list is not limited but at least (I hope) give an idea. The external tools and internal (embedded on the database) are linked and work together.

PeopleSoft Application host only the database objects link to the business module for which it was created.

I hope you see the difference, one is behind (PeopleTools), one is the real business (Application).

2. The PeopleTools based version of the PeopleSoft Application
When Peoplesoft dev team develop a new Application, the developers work generally on the last PeopleTools release. When the Application is ready to be sold to the customer, they "export" all the objects (including PeopleTools and Application objects) with the DataMover (a specific SQL language definition) to have a dat file. Once this export has been done, they didn't recreate it each time a new PeopleTools release is out later. This is the Application database version.
When you install a PeopleSoft Application, you may want to work on the last available PeopleTools release which can or can be not be the same as the developers when they created the Application itself.
That's why, we have often to upgrade the PeopleSoft Application to the latest PeopleTools release. That means you have to install the latest PeopleTools release, then the PeopleSoft Application then upgrade the Application Database as well regarding the Database version of your Application and your exected PeopleTools version.
Basically the Application Database version is the PeopleTools version when the Application has been created.

3. What are DEMO/SYS/PeopleTools System databases ?
Basically, there are three type of databases we can create.
DEMO : if you load an Application in DEMO mode, that means a set of data sample will be load, for training
SYS : if you load an Application in DEMO mode, that means no data (or only what required), for production
PeopleTools System : if you choose this mode, you'll load only the PeopleTools objects, take care, if you want to load an Application, the Application Database version must be the same as the current PeopleTools. It's very rare to use it, unless you want a Performance database or for some other reason.

4. What are DataMover and Application Designer ?
DataMover is a query tool (update/delete/insert) which allow to manipulate the data, import, and export from/to file.
Application Designer is a development tool, to create/delete/update objects (record, Peoplecode, page definition...) in the Peoplesoft metamodel. Application Designer doesn't work directly against the Oracle object, there is a translator which check the meatamodel before querying the database.
You create a projet, a set of objects/definitions (...), and build it to create a SQL script file which you can run immediateley or later within your lovely query tool (SQL*Plus of course).

5. What is the bootstrap mode ?
You can connect in bootstrap mode only within DataMover.
Bootstrap mode means you use the owner of the objects, and you connect directly to the database in 2tier mode (and not in 3tier mode through the Application Server). This is used for administration task, and shouldn't be used for the development. This user doesn't know the Peoplesoft metamodel, it's not an Application user.

6. What does the PS and people users
On the Peoplesoft database, there are three specials users : the owner of database (see above) used for the administration task in bootstrap mode, PS and people.
PS : an Oracle user and an Application user.
The PS Oracle user host three tables with all the Application users and authorizations. Once the tables are created at the beginning of the install process, this user is not allowed to create a session against the database.
The PS Application user is the super admin user, basically PS has all the rights.
Note that PS is the main user available for HRMS, it's VP1 for FSCM, PSCR for CRM application.
PEOPLE is an Oracle user account, no objects at all, and only SELECT rights on the PS'tables.
When you connect (except in bootstrap mode) to DataMover or Application Designer, Peoplesoft will create a connection to the database with the PEOPLE user, read if the user has the right has well to connect and to use DMS and/or AppDesigner. Once the check are ok, Peoplesoft reconnect you to the database with the owner of objects.

Then, and only when you have understood those concepts, you can go in the Peoplesoft database creation which can be split in three mains steps (I'll insert the links when the articles will be ready) :
1. Database creation (db creation and Application loading)
2. Upgrade your application to your PeopleTools version (only if required)
3. Post creation tasks

Have fun,

Sunday, January 06, 2008

On The Peoplesoft Road : Peoplesoft HRMS 9.0 ML

Here below, I'll show the installation of Peoplesoft HRMS9.0 ML (multilinguages) in console mode.
A GUI mode is available, but it's so far simpler to use the console mode, no need a XClient.
Of course, if you don't need multilinguages application, you'll have to skip the last step of the current installation.

Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - Human Resources Management System and Campus Solutions 9.0 Translations Media Pack", then disk named as
"PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 Multi-Language"
"PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 (CD)"

1. Create a new folder, temporary for the installation task, as root
[root@orion:/]$ mkdir tmphrms9
[root@orion:/]$ chown hrms9:psoft tmphrms9

2. Start the installation in console mode as hrms9 user :
At this step you'll need the license code from (depending of the database vendor) http://licensecodes.oracle.com/ent_keys_by_prod.html#HCM
The license code are same for production usage.
The temporary parameter (tempdir) might be skip if you have enough space in your default /tmp directory.

[hrms9@orion:/hrms9]$ ls
B34591-01.zip media.inf setup setup.aix setup.exe setup.hp setup.hp-ia64 setup.jar setup.linux setup.solaris setup.tru64 setup.unix setup.zlinux
[hrms9@orion:/hrms9]$ ./setup.linux -is:tempdir /tmphrms9 -is:javaconsole -console
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
................InstallShield Wizard

Initializing InstallShield Wizard...

Searching for Java(tm) Virtual Machine...
...................................
....................................
............
Preparing Java(tm) Virtual Machine...
......................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
..........
Running InstallShield Wizard...

-------------------------------------------------------------------------------
Welcome to the InstallShield Wizard for PeopleSoft Enterprise HRMS and Campus
Solutions 9.0

The InstallShield Wizard will install PeopleSoft Enterprise HRMS and Campus
Solutions 9.0 on your computer.
To continue, choose Next.

PeopleSoft Enterprise HRMS and Campus Solutions 9.0

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

-------------------------------------------------------------------------------

Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: 117fef

License Code (characters 7 to 12) []: ffff8f

License Code (characters 13 to 19) []: ffffebf

License Code (characters 20 to 25) []: 119783

License Code (characters 26 to 31) []: 2qimmg

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

-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database
[ ] 2 - Unicode Database

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

[ ] 1 - Non-Unicode Database
[X] 2 - Unicode Database

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 4 to Redisplay [1]

-------------------------------------------------------------------------------

For Oracle on Linux the following can be installed:

[X] 1 - PeopleSoft Application Server
[X] 2 - PeopleSoft Batch Server
[X] 3 - PeopleSoft Database Server
[X] 4 - PeopleSoft File Server
[X] 5 - PeopleSoft Web 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 4 to Redisplay [1]

-------------------------------------------------------------------------------
PeopleSoft Enterprise HRMS and Campus Solutions 9.0 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/PT9.0] /apps/psoft/hrms9 ***comment*** this directory must be the same as the one where you previsouly installed the Peopletools***

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

-------------------------------------------------------------------------------

Please select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps/bea/tuxedo/9.1

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

-------------------------------------------------------------------------------
Select the features for "PeopleSoft Enterprise HRMS and Campus Solutions 9.0"
you would like to install:

PeopleSoft Enterprise HRMS and Campus Solutions 9.0

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleSoft HRCS Database
2. [x] PeopleSoft HRCS Demo Database
3. [x] PeopleSoft Absence Management
4. [x] PeopleSoft Benefits Administration
5. [x] PeopleSoft Campus Self Service
6. [x] PeopleSoft Candidate Gateway
7. [x] PeopleSoft Contributor Relations
8. [x] PeopleSoft Currency Conversion
9. [x] PeopleSoft Directory Interface
10. [x] PeopleSoft Enterprise Components
11. [x] PeopleSoft Global Payroll Australia
12. [x] PeopleSoft Global Payroll Brazil
13. [x] PeopleSoft Global Payroll Core
14. [x] PeopleSoft Global Payroll France
15. [x] PeopleSoft Global Payroll Germany
16. [x] PeopleSoft Global Payroll Hong Kong
17. [x] PeopleSoft Global Payroll India
18. [x] PeopleSoft Global Payroll Italy
19. [x] PeopleSoft Global Payroll Japan
20. [x] PeopleSoft Global Payroll Malaysia
21. [x] PeopleSoft Global Payroll Mexico
22. [x] PeopleSoft Global Payroll Netherlands
23. [x] PeopleSoft Global Payroll New Zealand
24. [x] PeopleSoft Global Payroll Singapore
25. [x] PeopleSoft Global Payroll Spain
26. [x] PeopleSoft Global Payroll Switzerland
27. [x] PeopleSoft Global Payroll UK
28. [x] PeopleSoft Global Payroll United States
29. [x] PeopleSoft Gradebook
30. [x] PeopleSoft HRMS Portal Pack
31. [x] PeopleSoft Human Resources
32. [x] PeopleSoft Pay/Bill Management
33. [x] PeopleSoft Payroll Interface
34. [x] PeopleSoft Payroll Interface for ADP
35. [x] PeopleSoft Payroll for North America
36. [x] PeopleSoft Pension Administration
37. [x] PeopleSoft Recruit Workforce/Ltd TAM
38. [x] PeopleSoft Shared Components
39. [x] PeopleSoft Stock Administration
40. [x] PeopleSoft Student Administration
41. [x] PeopleSoft Talent Acquisition Mgr
42. [x] PeopleSoft Time and Labor
43. [x] PeopleSoft eBenefits
44. [x] PeopleSoft eCompensation
45. [x] PeopleSoft eCompensation Mgr Desktop
46. [x] PeopleSoft eDevelopment
47. [x] PeopleSoft ePay
48. [x] PeopleSoft ePerformance
49. [x] PeopleSoft eProfile
50. [x] PeopleSoft eProfile Manager Desktop

Other options:

0. Continue installing

Enter command [0] 11
[...]uncheck the unexpected application[...]

PeopleSoft Enterprise HRMS and Campus Solutions 9.0 will be installed in the following location:
/apps/psoft/hrms9
with the following features:
PeopleSoft HRCS Database
PeopleSoft HRCS Demo Database
PeopleSoft Absence Management
PeopleSoft Benefits Administration
PeopleSoft Campus Self Service
PeopleSoft Candidate Gateway
PeopleSoft Contributor Relations
PeopleSoft Currency Conversion
PeopleSoft Directory Interface
PeopleSoft Enterprise Components
PeopleSoft Gradebook
PeopleSoft HRMS Portal Pack
PeopleSoft Human Resources
PeopleSoft Pay/Bill Management
PeopleSoft Payroll Interface
PeopleSoft Payroll Interface for ADP
PeopleSoft Payroll for North America
PeopleSoft Pension Administration
PeopleSoft Recruit Workforce/Ltd TAM
PeopleSoft Shared Components
PeopleSoft Stock Administration
PeopleSoft Student Administration
PeopleSoft Talent Acquisition Mgr
PeopleSoft Time and Labor
PeopleSoft eBenefits
PeopleSoft eCompensation
PeopleSoft eCompensation Mgr Desktop
PeopleSoft eDevelopment
PeopleSoft ePay
PeopleSoft ePerformance
PeopleSoft eProfile
PeopleSoft eProfile Manager Desktop

The following PeopleSoft Servers were selected by you:
PeopleSoft Application Server
PeopleSoft Batch Server
PeopleSoft Database Server
PeopleSoft File Server
PeopleSoft Web Server

Database Type:
Oracle

-------------------------------------------------------------------------------

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

Installing PeopleSoft Enterprise HRMS and Campus Solutions 9.0. Please wait...

|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||

Setting Files Permission... Please wait

-------------------------------------------------------------------------------
The InstallShield Wizard has successfully installed PeopleSoft Enterprise HRMS
and Campus Solutions 9.0. Choose Finish to exit the wizard.

Press 3 to Finish or 4 to Redisplay [3]
[hrms9@orion:/hrms9]$

3. Start the installation of ML in console mode as hrms9 user :
At this step you'll need the license code from http://licensecodes.oracle.com/ent_keys_by_prod.html#Translations

[hrms9@orion:/hrms9]$ ls
B42124-01.zip media.inf setup setup.aix setup.exe setup.hp setup.hp-ia64 setup.jar setup.linux setup.solaris setup.tru64 setup.unix setup.zlinux
[hrms9@orion:/hrms9]$ ./setup.linux -is:tempdir /tmphrms9 -is:javaconsole -console
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
................InstallShield Wizard

Initializing InstallShield Wizard...

Searching for Java(tm) Virtual Machine...
...................................
....................................
............
Preparing Java(tm) Virtual Machine...
......................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
.....................
Running InstallShield Wizard...

-------------------------------------------------------------------------------
Welcome to the InstallShield Wizard for PeopleSoft Enterprise HRMS and Campus
Solutions 9.0 ML

The InstallShield Wizard will install PeopleSoft Enterprise HRMS and Campus
Solutions 9.0 ML on your computer.
To continue, choose Next.

PeopleSoft Enterprise HRMS and Campus Solutions 9.0 ML

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

-------------------------------------------------------------------------------

Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: 103fff

License Code (characters 7 to 12) []: c84000

License Code (characters 13 to 19) []: 0000000

License Code (characters 20 to 25) []: 000001

License Code (characters 26 to 31) []: 2k7goq

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

-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database
[ ] 2 - Unicode Database

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

[ ] 1 - Non-Unicode Database
[X] 2 - Unicode Database

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 4 to Redisplay [1]

-------------------------------------------------------------------------------

For Oracle on Linux the following can be installed:

[X] 1 - PeopleSoft Application Server
[X] 2 - PeopleSoft Batch Server
[X] 3 - PeopleSoft Database Server
[X] 4 - PeopleSoft File Server
[X] 5 - PeopleSoft Web 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 4 to Redisplay [1]

-------------------------------------------------------------------------------
PeopleSoft Enterprise HRMS and Campus Solutions 9.0 ML Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/PT9.0] /apps/psoft/hrms9 ***comment*** this directory must be the same as the one where you previsouly installed the Peopletools***

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

-------------------------------------------------------------------------------

Please select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps/bea/tuxedo/9.1

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

-------------------------------------------------------------------------------
Select the features for "PeopleSoft Enterprise HRMS and Campus Solutions 9.0
ML" you would like to install:

PeopleSoft Enterprise HRMS and Campus Solutions 9.0 ML

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleSoft Arabic Objects
2. [x] PeopleSoft French Canadian Objects
3. [x] PeopleSoft Traditional Chinese Objects
4. [x] PeopleSoft Common Objects
5. [x] PeopleSoft Danish Objects
6. [x] PeopleSoft German Objects
7. [x] PeopleSoft Spanish Objects
8. [x] PeopleSoft Finnish Objects
9. [x] PeopleSoft French Objects
10. [x] PeopleSoft Italian Objects
11. [x] PeopleSoft Japanese Objects
12. [x] PeopleSoft Korean Objects
13. [x] PeopleSoft Dutch Objects
14. [x] PeopleSoft Polish Objects
15. [x] PeopleSoft Brazilian Portuguese Objects
16. [x] PeopleSoft Simplified Chinese Objects
17. [x] PeopleSoft Swedish Objects

Other options:

0. Continue installing

Enter command [0] 1

[...]uncheck the unexpected languages, keep the common[...]

Select the features for "PeopleSoft Enterprise HRMS and Campus Solutions 9.0
ML" you would like to install:

PeopleSoft Enterprise HRMS and Campus Solutions 9.0 ML

To select/deselect a feature or to view its children, type its number:

1. [ ] PeopleSoft Arabic Objects
2. [ ] PeopleSoft French Canadian Objects
3. [ ] PeopleSoft Traditional Chinese Objects
4. [x] PeopleSoft Common Objects
5. [ ] PeopleSoft Danish Objects
6. [ ] PeopleSoft German Objects
7. [ ] PeopleSoft Spanish Objects
8. [ ] PeopleSoft Finnish Objects
9. [x] PeopleSoft French Objects
10. [ ] PeopleSoft Italian Objects
11. [ ] PeopleSoft Japanese Objects
12. [ ] PeopleSoft Korean Objects
13. [ ] PeopleSoft Dutch Objects
14. [ ] PeopleSoft Polish Objects
15. [ ] PeopleSoft Brazilian Portuguese Objects
16. [ ] PeopleSoft Simplified Chinese Objects
17. [ ] PeopleSoft Swedish Objects

Other options:

0. Continue installing

Enter command [0]

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

PeopleSoft Enterprise HRMS and Campus Solutions 9.0 ML will be installed in the following location:
/apps/psoft/hrms9
with the following features:
PeopleSoft Common Objects
PeopleSoft French Objects

The following PeopleSoft Servers were selected by you:
PeopleSoft Application Server
PeopleSoft Batch Server
PeopleSoft Database Server
PeopleSoft File Server
PeopleSoft Web Server

Database Type:
Oracle

-------------------------------------------------------------------------------

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

Installing PeopleSoft Enterprise HRMS and Campus Solutions 9.0 ML. Please
wait...

|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
|||||||||||||||||||||||||||||||||||||||||||||||||

Setting Files Permission... Please wait

-------------------------------------------------------------------------------
The InstallShield Wizard has successfully installed PeopleSoft Enterprise HRMS
and Campus Solutions 9.0 ML. Choose Finish to exit the wizard.

Press 3 to Finish or 4 to Redisplay [3]
[hrms9@orion:/hrms9]$

On The Peoplesoft Road : Peopletools 8.49.08 Windows client

For further installation and usage, you have to install Peopletools and Application on a client Windows machine.
Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.49 Media Pack", then disk named as
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 1 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 2 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 3 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 4 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 5 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 6 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 7 of 7"

At this step you'll need the license code from (depending of the database vendor) http://licensecodes.oracle.com/ent_keys_by_prod.html#PeopleTools
The license code are same for production usage.

Just run the setup.exe located into the installation directory, and follow the instruction.
You have to indicate the ORACLE_HOME/bin directory (which is not the case on Unix/Linux).
Note, the Disk 5 will be skipped (not required).

Choose Unicode database if you want to load global application with different languages, choose Non-Unicode if not. Take care , a Unicode database requires much more space (between 2 and 3 times more than a Non-Unicode database).

Choose the module you want to install, in most of case, check all the checkboxes :

If you want later install some ML translation application,keep the Language pack :

Change the folder for each installation CD :

Then, you have to install the patch 8.49.08, the screenshots are almost same as here above.

Lastly, some programs have been added in your programs list, run the Application Designer to check the Peopletools version as well :

Have fun,

Saturday, January 05, 2008

On The Peoplesoft Road : Peopletools 8.49.08 console mode

Because you can want to work in console mode instead of GUI, console mode doesn't required any XClient...

The main thing at this installation is the setting of DISPLAY variable, doesn't forget it, you can encoutered some strange behaviour of the Installer.

I'll install with this method the Peopletools for CRM9 usage, under specific folder. I don't share the Peopletools directory between differents applications.

Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.49 Media Pack", then disk named as
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 1 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 2 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 3 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 4 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 5 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 6 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 7 of 7"

1. As root
[root@orion:/apps/psoft/hrms9]$ useradd -g psoft crm9

2. Start the installation in console mode as crm9 user :
At this step you'll need the license code from (depending of the database vendor) http://licensecodes.oracle.com/ent_keys_by_prod.html#PeopleTools
The license code are same for production usage.
[crm9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49/Disk1]$ export DISPLAY=0.0
[crm9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49/Disk1]$ ./setup.linux -is:javaconsole -console

Initializing Wizard........

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

-------------------------------------------------------------------------------
Welcome to the InstallShield Wizard for PeopleTools 8.49

The InstallShield Wizard will install PeopleTools 8.49 on your computer.
To continue, choose Next.

PeopleTools 8.49

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

-------------------------------------------------------------------------------

Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: zm7ky3

License Code (characters 7 to 12) []: w41m04

License Code (characters 13 to 19) []: 4u863q6

License Code (characters 20 to 25) []: 7oke1m

License Code (characters 26 to 31) []: s7t1f2

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

-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database
[ ] 2 - Unicode Database

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

[ ] 1 - Non-Unicode Database
[X] 2 - Unicode Database

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]

-------------------------------------------------------------------------------

For Oracle on Linux the following can be installed:

[X] 1 - PeopleSoft Application Server
[X] 2 - PeopleSoft Batch Server
[X] 3 - PeopleSoft Database Server
[X] 4 - PeopleSoft Web 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]

-------------------------------------------------------------------------------
PeopleTools 8.49 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/PT8.49] /apps/psoft/crm9

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

-------------------------------------------------------------------------------

Would you like to install Enterprise Resource Planning (ERP) Connectors?

[X] 1 - No
[ ] 2 - Yes

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 select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps/bea/tuxedo/9.1

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

-------------------------------------------------------------------------------
Please enter the configuration for Environment Management:

Environment Hub machine name: [PSEMHUB]

Environment Hub port number: [80]

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

-------------------------------------------------------------------------------
Select the features for "PeopleTools 8.49" you would like to install:

PeopleTools 8.49

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleTools
2. [x] PeopleTools System Database

Other options:

0. Continue installing

Enter command [0]

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

PeopleTools 8.49 will be installed in the following location:
/apps/psoft/crm9
with the following features:
PeopleTools
PeopleTools System Database

The following PeopleSoft Servers were selected by you:
PeopleSoft Application Server
PeopleSoft Batch Server
PeopleSoft Database Server
PeopleSoft Web Server

Database Type:
Oracle

ERP Connectors Installation:
Not Selected

Environment Hub Configuration:
Hub machine name: PSEMHUB
Hub port number: 80

-------------------------------------------------------------------------------

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

Installing PeopleTools 8.49. Please wait...

|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||

Please insert disk 2.
[/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49/Disk1]/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49/Disk2

1. OK
2. Cancel

[1]
[...]
Insert or change the directory of CD on demand (all the 7 cd will be required)
[...]
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
|||||||||||||||||||||||||||||||||||||||||||||||||

Unpacking JRE ...

Setting Files Permission... Please wait

-------------------------------------------------------------------------------
The InstallShield Wizard has successfully installed PeopleTools 8.49. Choose
Finish to exit the wizard.

Press 3 to Finish or 5 to Redisplay [3]

[crm9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49/Disk1]$

3. Start the upgrade to the latest patch of Peopletools (8.48.08) in console mode as crm9 user.
Downloaded from ftp://ftp.peoplesoft.com/outgoing/ptools/84908
Password for unzipping the compress file from http://www.peoplesoft.com (a valid customer ID required)
Tab Update+Fixes, then Apply to Release
Choose Product Line => Peopletools
Product => Peopletools
Release => 8.49
Check the Bunldes checkbox, then search
Click on Update ID #738550
Open the user doc html files to get the password.
Lastly, at this step you'll need the license code (depending of the database vendor) from http://licensecodes.oracle.com/ent_keys_by_prod.html#PeopleTools

[crm9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49.08/cd84908/disk1]$ export DISPLAY=0.0
[crm9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49.08/cd84908/disk1]$ ./setup.linux -is:javaconsole -console

Initializing Wizard........

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

-------------------------------------------------------------------------------
Welcome to the InstallShield Wizard for PeopleTools 8.49.08

The InstallShield Wizard will install PeopleTools 8.49.08 on your computer.
To continue, choose Next.

PeopleTools 8.49.08

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

-------------------------------------------------------------------------------

Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: zm7ky3

License Code (characters 7 to 12) []: w41m04

License Code (characters 13 to 19) []: 4u863q6

License Code (characters 20 to 25) []: 7oke1m

License Code (characters 26 to 31) []: s7t1f2

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

-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database
[ ] 2 - Unicode Database

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

[ ] 1 - Non-Unicode Database
[X] 2 - Unicode Database

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]

-------------------------------------------------------------------------------

For Oracle on Linux the following can be installed:

[X] 1 - PeopleSoft Application Server
[X] 2 - PeopleSoft Batch Server
[X] 3 - PeopleSoft Database Server
[X] 4 - PeopleSoft Web 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]

-------------------------------------------------------------------------------
PeopleTools 8.49.08 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/PT8.49.08] /apps/psoft/crm9

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

-------------------------------------------------------------------------------

Please select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps/bea/tuxedo/9.1

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

-------------------------------------------------------------------------------
Select the features for "PeopleTools 8.49.08" you would like to install:

PeopleTools 8.49.08

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleTools
2. [x] PeopleTools System Database

Other options:

0. Continue installing

Enter command [0]

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

PeopleTools 8.49.08 will be installed in the following location:
/apps/psoft/crm9
with the following features:
PeopleTools
PeopleTools System Database

The following PeopleSoft Servers were selected by you:
PeopleSoft Application Server
PeopleSoft Batch Server
PeopleSoft Database Server
PeopleSoft Web Server

Database Type:
Oracle

-------------------------------------------------------------------------------

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

Installing PeopleTools 8.49.08. Please wait...

|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||

Setting Files Permission... Please wait

-------------------------------------------------------------------------------
The InstallShield Wizard has successfully installed PeopleTools 8.49.08. Choose
Finish to exit the wizard.

Press 3 to Finish or 5 to Redisplay [3]

[crm9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49.08/cd84908/disk1]$

4. Modify the .bash_profile of the Peoplesoft directory owner :
[crm9@orion:/home/crm9]$ 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
unset USERNAME
export ORACLE_HOME=/apps/oracle/ora102
export PS_HOME=/apps/psoft/crm9
. $PS_HOME/psconfig.sh

Then disconnect, reconnect and :
[crm9@orion:/home/crm9]$ cd $PS_HOME/appserv
[crm9@orion:/apps/psoft/crm9/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):

We get the 8.49.08 flag, nice.
Next step, Peoplesoft HRMS application installation.

Have fun,

Addendum (13-APR-2009) : in case that was not clear enough, I added the step 4, customization of .bash_profile to invoke psconfig.sh on every connection of the Peoplesoft OS user.

On The Peoplesoft Road : Peopletools 8.49.08 GUI mode

Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.49 Media Pack", then disk named as
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 1 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 2 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 3 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 4 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 5 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 6 of 7"
"PeopleSoft Enterprise PeopleTools 8.49 PeopleTools 8.49 Mobile Agent (use requires specific license) Disk 7 of 7"

Here below, I'll show the Peopletools installation for the HRMS application. It's better to install one Peopletools software by application directory.
1. As root, the group psoft has already been created previously.
[root@orion:/apps/bea/weblogic/9.2]$ useradd -g psoft hrms9 [root@orion:/apps/bea/weblogic/9.2]$
[root@orion:/apps/bea/weblogic/9.2]$ passwd hrms9
Changing password for user hrms9.
New UNIX password:
BAD PASSWORD: it is too short Retype new UNIX
password: passwd: all authentication tokens updated successfully. [root@orion:/apps/bea/weblogic/9.2]$

2. Start the installation in GUI mode with user hrms9 created at step 1.
At this step you'll need the license code from (depending of the database vendor) http://licensecodes.oracle.com/ent_keys_by_prod.html#PeopleTools
The license code are same for production usage.
In XClient window :
[hrms9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49/Disk1]$ ./setup.linux

Insert or change the directory of CD on demand (all the 7 cd will be required) :

4. Install the patch 8.49.08
Downloaded from ftp://ftp.peoplesoft.com/outgoing/ptools/84908
Password for unzipping the compress file from http://www.peoplesoft.com (a valid customer ID required)
Tab Update+Fixes, then Apply to Release
Choose Product Line => Peopletools
Product => Peopletools
Release => 8.49
Check the Bunldes checkbox, then search
Click on Update ID #738550
Open the user doc html files to get the password.
Lastly, at this step you'll need the license code (depending of the database vendor) from http://licensecodes.oracle.com/ent_keys_by_prod.html#PeopleTools
In XClient window :
[hrms9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49.08/cd84908/disk1]$ ls
media.inf pt_responsefile.txt readme.txt setup setup.aix setup.exe setup.hp setup.hp-ia64 setup.jar setup.linux setup.solaris [hrms9@orion:/nfs/software/peoplesoft/PeopleTools/PeopleTools8.49.08/cd84908/disk1]$ ./setup.linux

5. Modify the .bash_profile
[hrms9@orion:/home/hrms9]$ 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
unset USERNAME
export ORACLE_HOME=/apps/oracle/ora102
export PS_HOME=/apps/psoft/hrms9
. $PS_HOME/psconfig.sh

6. Run the psadmin to check your install :

We get the 8.49.08 flag, nice.
Next step, Peoplesoft HRMS application installation.

Have fun,

On The Peoplesoft Road : Weblogic 9.2

Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.49 Media Pack", choose the disk :
"BEA WebLogic Server 9.2 for Linux"

For the Maintenance Pack 1 (MP1), download from ftp://ftp.peoplesoft.com/outgoing/ptools/weblogic/9.20/mp1 the file
server921_upgrade_linux32.bin
And patches from ftp://ftp.peoplesoft.com/outgoing/ptools/weblogic/9.20/mp1/patches
installwlspatch.sh
wls92mp1-p1.zip
wls92mp1-p2.zip

1. As root user, create group, user and folder Weblogic :
[root@orion:/root]$ groupadd weblogic
[root@orion:/root]$ useradd -g weblogic -G psoft -G bea weblogic
[root@orion:/root]$ cd /apps/bea
[root@orion:/apps/bea]$ ls
tuxedo
[root@orion:/apps/bea]$ mkdir -p weblogic/9.2
[root@orion:/apps/bea]$ chown -R weblogic:weblogic weblogic
[root@orion:/apps/bea]$ passwd weblogic
Changing password for user weblogic.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@orion:/apps/bea]$

2. Install software as weblogic user.
The weblogic's installation folder might be inside the PS_HOME directory, but since we can share the Weblogic software by multiple Peopletools and Peoplesoft applications, better to externalize the Weblogic software and do not duplicate the installation.
[weblogic@orion:/home/weblogic]$ 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
unset USERNAME
export BEA_HOME=/apps/bea/weblogic/9.2
[weblogic@orion:/home/weblogic]$

[weblogic@orion:/nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2]$ ls
B42606-01.zip install.cmd installer.xml install.sh installwlspatch.cmd installwlspatch.sh license patches readme.txt server920-linux32.bin utils
[weblogic@orion:/nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2]$ sh ./install.sh
Installing BEA WebLogic Server 9.2.0

BEA WebLogic Server 9.2.0 installation.

Installation log written to /home/weblogic/wls92_install.log

OS Platform detected to be Linux i686

Where would you like to install WebLogic Server 9.2.0 to [press ENTER to quit]?
/apps/bea/weblogic/9.2

Confirm installation of BEA WebLogic Server 9.2.0 to
/apps/bea/weblogic/9.2 [Y]?
Y
Launching installer server920-linux32.bin. Install logs will be written to /apps/bea/weblogic/9.2/logs/
Extracting 0%....................................................................................................100%
Base product and service pack installation complete.

Installing PeopleSoft provided WebLogic license.

BEA WebLogic Server license install process brought to you by PeopleSoft.

This process will update license for WebLogic 9.2 install in /apps/bea/weblogic/9.2
Existing WebLogic license will be backed up to license.bak

Installing PeopleSoft license for WebLogic Server 9.2 (Step 1 of 2)
Please wait and do not interrupt ....

Done!

Updating license registry. (Step 2 of 2)
WebLogic Server 9.2 license install complete.

Installation complete. Performing post install cleanup.

Installation of WebLogic 9.2.0 to /apps/bea/weblogic/9.2 is complete.
Refer to PeopleTools install guide to apply any required patches.
[weblogic@orion:/nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2]$

3. Upgrade the weblogic home directory to the latest maintenance pack (mode console) :
[weblogic@orion:/nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2_MP1]$ ls -lrt
total 193710
-rwxrwxrwx 1 1001 513 5440 Jan 2 22:26 WebLogic92_MP1_upgrade_instructions.txt
drwxrwxrwx 2 1001 513 0 Jan 2 22:31 patches
-rwxrwxrwx 1 1001 513 396708441 Jan 2 22:46 server921_upgrade_linux32.bin
[weblogic@orion:/nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2_MP1]$ ./server921_upgrade_linux32.bin -mode=console
Extracting 0%....................................................................................................100%

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Welcome:
--------

This installer will guide you through the installation of BEA Products. Type "Next" or enter to proceed to the next prompt. If you want to change data entered previously, type "Previous". You may quit the installer at any time by typing "Exit".

Enter [Exit][Next]>

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Choose BEA Home Directory:
--------------------------

->1|* Type in existing BEA Home
2|/apps/bea/weblogic/9.2

Enter index number to select OR [Exit][Previous][Next]> 2

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Confirm Product Installation Directories:
-----------------------------------------

BEA Home Directory: [/apps/bea/weblogic/9.2]

Product Installation Directories:

Default Product Home: [/apps/bea/weblogic/9.2/weblogic92]
Workshop for WebLogic Platform: [/apps/bea/weblogic/9.2/workshop92]

Files in /apps/bea/weblogic/9.2/weblogic92 will now be upgraded to the 9.2.1.0 maintenance level.

Enter [Exit][Previous][Next]>

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Backing up current installation...

0% 25% 50% 75% 100%
[------------|------------|------------|------------]
[***************************************************]

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Installing files..

0% 25% 50% 75% 100%
[------------|------------|------------|------------]
[***************************************************]

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Installing JDK....

0% 25% 50% 75% 100%
[------------|------------|------------|------------]
[***************************************************]

Performing String Substitutions...

Creating Domains...

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Installation Complete

Congratulations! BEA Products has been successfully installed to /apps/bea/weblogic/9.2/weblogic92.

Press [Enter] to continue or type [Exit]>

<------------------------------------------------------------------------ BEA Installer - BEA Products ------------------------------------------------------------------------>

Clean up process in progress ...
[weblogic@orion:/nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2_MP1]$

4. Install the patches of weblogic (copy the patches' files in the BEA_HOME directory first)
[weblogic@orion:/home/weblogic]$ cd $BEA_HOME
[weblogic@orion:/apps/bea/weblogic/9.2]$ cp /nfs/software/peoplesoft/BEA/BEA_WebLogic_Server_9.2_MP1/patches/* .
[weblogic@orion:/apps/bea/weblogic/9.2]$ ./installwlspatch.sh wls92mp1-p1.zip
WebLogic Server patch installation process brought to you by PeopleSoft.

created: weblogic92/
created: weblogic92/server/
created: weblogic92/server/lib/
inflated: weblogic92/server/lib/weblogic_sp.jar
created: weblogic92/server/plugin/
created: weblogic92/server/plugin/win/
created: weblogic92/server/plugin/win/32/
inflated: weblogic92/server/plugin/win/32/iisforward.dll
inflated: weblogic92/server/plugin/win/32/iisproxy.dll
inflated: wls92mp1-p1.txt

Patch install complete.
[weblogic@orion:/apps/bea/weblogic/9.2]$ ./installwlspatch.sh wls92mp1-p2.zip
WebLogic Server patch installation process brought to you by PeopleSoft.

created: weblogic92/
created: weblogic92/server/
created: weblogic92/server/lib/
inflated: weblogic92/server/lib/EccpressoAsn1.jar
inflated: weblogic92/server/lib/EccpressoCore.jar
inflated: weblogic92/server/lib/EccpressoJcae.jar
inflated: weblogic92/server/lib/jsafe.jar
inflated: weblogic92/server/lib/weblogic_sp.jar
inflated: weblogic92/server/lib/wlcipher.jar
created: weblogic92/server/plugin/
created: weblogic92/server/plugin/win/
created: weblogic92/server/plugin/win/32/
inflated: weblogic92/server/plugin/win/32/iisforward.dll
inflated: weblogic92/server/plugin/win/32/iisproxy.dll
inflated: wls92mp1-p2.txt

Patch install complete.
[weblogic@orion:/apps/bea/weblogic/9.2]$

5. Comment out the last line of $BEA_HOME/weblogic92/common/bin/commEnv.sh
#resetFd

Next step Peopletools installation.

Have fun,

On The Peoplesoft Road : Tuxedo 9.1

Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.49 Media Pack", choose the disk :
"BEA Tuxedo 9.1 for AIX, Solaris, and Linux"

1. As root user, create group, user and folder Tuxedo :
[root@orion:/root]$ groupadd psoft
[root@orion:/root]$ groupadd tuxedo
[root@orion:/root]$ groupadd bea
[root@orion:/root]$ useradd -g tuxedo -G psoft -G bea tuxedo
[root@orion:/root]$ passwd tuxedo
Changing password for user tuxedo.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@orion:/root]$ cd /apps
[root@orion:/apps]$ mkdir -p bea/tuxedo/9.1
[root@orion:/apps]$ ls -lrt
total 16
drwxrwxrwx 8 oracle dba 4096 Dec 28 22:52 oracle
drwxr-xr-x 3 root root 4096 Jan 5 14:27 psoft
[root@orion:/apps]$ chgrp psoft psoft
[root@orion:/apps]$ ls -lrt
total 24
drwxrwxrwx 8 oracle dba 4096 Dec 28 22:52 oracle
drwxr-xr-x 2 root psoft 4096 Jan 5 14:57 psoft
drwxr-xr-x 3 root root 4096 Jan 5 14:58 bea
[root@orion:/apps]$ chgrp bea bea
[root@orion:/apps]$ cd bea
[root@orion:/apps/bea]$ chown -R tuxedo:tuxedo tuxedo
[root@orion:/apps/bea]$ ls -lrt
total 8
drwxr-xr-x 3 tuxedo tuxedo 4096 Jan 5 14:58 tuxedo
[root@orion:/apps/psoft/bea]$
[root@orion:/apps/psoft/bea]$

2. Install software as tuxedo user.
The tuxedo's installation folder might be inside the PS_HOME directory, but since we can share the Tuxedo software by multiple Peopletools and Peoplesoft applications, better to externalize the Tuxedo software and do not duplicate the installation.
[tuxedo@orion:/nfs/software/peoplesoft/BEA/BEA_Tuxedo_9.1]$ sh ./install.sh

01) ibm/aix53 02) linux/sles9 03) sun/sol9

Please select a platform? [1-3, q to quit, l for list]: 2

Installing for linux/sles9

Is this correct? [y,n,q]: y

If you wish to quit the installation at any point
press the interrupt key or .
BEA Home being defaulted to /bea (y/n)
n
Please supply alternative BEA Home:
/apps/bea
Tuxedo 9.1 will be installed to /apps/bea/tuxedo91 (y/n):
n
Please supply alternative Tuxedo location:
/apps/bea/tuxedo/9.1
Accept default TListen password 'password' (y/n):
y
Continue with installation of Tuxedo 9.1 (y/n):
y
Installing...

Tuxedo 9.1 base installation complete
Installing patch at /apps/bea/tuxedo/9.1
using /bin/gunzip to uncompress archive
Installing server and client files...
Enter owner for patch files:
tuxedo
Enter group for patch files:
tuxedo

The patch installation finished successfully.
[tuxedo@orion:/nfs/software/peoplesoft/BEA/BEA_Tuxedo_9.1]$

3. Add the two last line (in bold) in tuxedo's .bash_profile
[tuxedo@orion:/home/tuxedo]$ 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
unset USERNAME

export BEAHOME=/apps/bea
export TUXDIR=/apps/bea/tuxedo/9.1
[tuxedo@orion:/home/tuxedo]$

4. After reconnection, check the installation by existence of two files :
[tuxedo@orion:/home/tuxedo]$ cd $TUXDIR
[tuxedo@orion:/apps/bea/tuxedo/9.1]$ ls
bin cobinclude help include lib locale samples tux.env udataobj uninstaller
[tuxedo@orion:/apps/bea/tuxedo/9.1]$ find . -name lic.txt
./udataobj/lic.txt
[tuxedo@orion:/apps/bea/tuxedo/9.1]$ find . -name tlisten.pw
./udataobj/tlisten.pw
[tuxedo@orion:/apps/bea/tuxedo/9.1]$
[tuxedo@orion:/apps/bea/tuxedo/9.1]$ ln -s $TUXDIR/locale/C $TUXDIR/locale/Ja_JP
[tuxedo@orion:/apps/bea/tuxedo/9.1]$ ls -lrt locale
total 60
-rw-rw-r-- 1 tuxedo tuxedo 24 Jan 5 15:00 CATNAMES
lrwxrwxrwx 1 tuxedo tuxedo 1 Jan 5 15:01 en_US.UTF-8 -> C
lrwxrwxrwx 1 tuxedo tuxedo 11 Jan 5 15:01 japanese.euc -> ja_JP.eucJP
lrwxrwxrwx 1 tuxedo tuxedo 11 Jan 5 15:01 japanese -> ja_JP.eucJP
lrwxrwxrwx 1 tuxedo tuxedo 11 Jan 5 15:01 ja_JP.ujis -> ja_JP.eucJP
lrwxrwxrwx 1 tuxedo tuxedo 11 Jan 5 15:01 ja_JP -> ja_JP.eucJP
lrwxrwxrwx 1 tuxedo tuxedo 13 Jan 5 15:05 ja_JP.eucjp -> ./ja_JP.eucJP
drwxrwxr-x 2 tuxedo tuxedo 4096 Jan 5 15:05 ja_JP.SJIS
drwxrwxr-x 2 tuxedo tuxedo 4096 Jan 5 15:05 ja_JP.eucJP
drwxrwxr-x 2 tuxedo tuxedo 4096 Jan 5 15:05 C
lrwxrwxrwx 1 tuxedo tuxedo 29 Jan 5 15:09 Ja_JP -> /apps/bea/tuxedo/9.1/locale/C
[tuxedo@orion:/apps/bea/tuxedo/9.1]$

Next step, Weblogic installation.

Have fun,

Thursday, January 03, 2008

On The Peoplesoft Road : Oracle 10.2.0.3 install

Last step before going on the Peoplesoft installation itself, the Oracle installation.
The last Oracle database version certified for Peoplesoft is the 10gR2 patchset 2 (10.2.0.3). Don't forget the required patches for Peoplesoft.

As root, create the groups and the Oracle user :
[root@orion ~]# groupadd dba
[root@orion ~]# groupadd oinstall
[root@orion:/root] ()$ useradd -g oinstall -G dba ora102
[root@orion:/root] ()$ passwd ora102
Changing password for user ora102.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Update the .bash_profile for the new user :
[ora102@orion:/home/ora102] ()$ more .bash_profile
ORACLE_BASE=/apps/oracle
ORACLE_HOME=$ORACLE_BASE/10.2.0
ORACLE_SID=DEMO102
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
LD_ASSUME_KERNEL=2.4.1
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_ASSUME_KERNEL PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

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

As root update the file /etc/sysctl.conf
[root@orion:/root] ()$ more /etc/sysctl.conf
# Kernel sysctl configuration file for Enterprise Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

kernel.sem = 250 32000 100 128
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 65536
kernel.msgmni = 2878
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

[root@orion:/root] ()$

If you don't want to reboot your server, run sysctl -p command.

Update the followings files as well :
[root@orion:/root] ()$ more /etc/pam.d/login
#%PAM-1.0
auth required pam_securetty.so
auth required pam_stack.so service=system-auth
auth required pam_nologin.so
account required pam_stack.so service=system-auth
password required pam_stack.so service=system-auth
# pam_selinux.so close should be the first session rule
session required pam_selinux.so close
session required pam_stack.so service=system-auth
session required pam_loginuid.so
session optional pam_console.so
# pam_selinux.so open should be the last session rule
session required pam_selinux.so open

session required /lib/security/pam_limits.so
[root@orion:/root] ()$
[root@orion:/root] ()$ more /etc/security/limits.conf
# /etc/security/limits.conf
#
#Each line describes a limit for a user in the form:
#
#
#
#Where:
# can be:
# - an user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
# can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
# can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open files
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
#
#
#

#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
* - nproc 16384
* - nofile 16384
oracle soft nproc 2047
ora102 soft nproc 2047
oracle hard nproc 16384
ora102 hard nproc 16384
oracle soft nofile 1024
ora102 soft nofile 1024
oracle hard nofile 65536
ora102 hard nofile 65536
# End of file
[root@orion:/root] ()$

Insert the CD3 of the OEL4.6 disks install, and install additional packages :
[root@orion /]# cd /media/cdrom/
[root@orion cdrom]# ls
Enterprise EULA GPL RPM-GPG-KEY TRANS.TBL
[root@orion cdrom]# cd Enterprise/RPMS/
[root@orion RPMS]# rpm -Uvh compat-gcc-32-3.2.3-47.3.i386.rpm
warning: compat-gcc-32-3.2.3-47.3.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-gcc-32 ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-gcc-32-c++-3.2.3-47.3.i386.rpm
warning: compat-gcc-32-c++-3.2.3-47.3.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-gcc-32-c++ ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libcom_err-1.0-5.i386.rpm
warning: compat-libcom_err-1.0-5.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-libcom_err ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libgcc-296-2.96-132.7.2.i386.rpm
warning: compat-libgcc-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-libgcc-296 ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libstdc++-296-2.96-132.7.2.i386.rpm
warning: compat-libstdc++-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-libstdc++-296 ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libgcc-296-2.96-132.7.2.i386.rpm
warning: compat-libgcc-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
package compat-libgcc-296-2.96-132.7.2 is already installed
[root@orion RPMS]# rpm -Uvh compat-glibc-headers-2.3.2-95.30.i386.rpm
warning: compat-glibc-headers-2.3.2-95.30.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-glibc-headers ########################################### [100%]
[root@orion:/media/cdrom/Enterprise/RPMS] ()$ rpm -Uvh libaio-0.3.105-2.i386.rpm
warning: libaio-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:libaio ########################################### [100%]
[root@orion:/media/cdrom/Enterprise/RPMS] ()$

[root@orion:/root] ()$

Then in a XClient, as Oracle user, my ora102, run the Installer.
[ora102@orion:/home/ora102] (DEMO102)$ cd /nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0] (DEMO102)$ cd database/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0/database] (DEMO102)$ ./runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-12-28_09-48-06PM. Please wait ...
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0/database] (DEMO102)$
Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.

During the installation, run the root.sh as root user.

Then upgrade to the 10.2.0.3 patchset level :
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2] (DEMO102)$ ls
Oracle_10_2_0_1_0 Oracle_10_2_0_3_0_upgrade Required_patches_PS
c[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2] (DEMO102)$ cd Oracle_10_2_0_3_0_upgrade/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade] (DEMO102)$ ls
Disk1 p5337014_10203_LINUX.zip README.html
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade] (DEMO102)$ cd Disk1/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade/Disk1] (DEMO102)$ ls
10203_buglist.htm install patch_note.htm response runInstaller stage
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade/Disk1] (DEMO102)$ ./RunInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-12-28_10-10-43PM. Please wait ...

During the patchset installation, run the root.sh as root user.

Install the OPatch utility (4898608).
Go in the $ORACLE_HOME and unzip the downloaded patch
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$ unzip /nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/p4898608_10201_GENERIC_Opatch.zip
Archive: /nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/p4898608_10201_GENERIC_Opatch.zip
replace OPatch/docs/FAQ? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
inflating: OPatch/opatch.pl
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/README.txt
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$

Then you have to install the three required patches recommanded by Peoplesoft.
p5128368_10203_LINUX.zip
p5574966_10203_LINUX.zip
p5683652_10203_LINUX.zip

[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5574966] (DEMO102)$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..

Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-36-03PM.log

ApplySession applying interim patch '5574966' to OH '/apps/oracle/10.2.0'
Invoking fuser to check for active processes.
Invoking fuser on "/apps/oracle/10.2.0/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/10.2.0')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5574966' for restore. This might take a while...
Backing up files affected by the patch '5574966' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libserver10.a" with "lib/libserver10.a/kkqjpd.o"
Updating archive file "/apps/oracle/10.2.0/lib/libserver10.a" with "lib/libserver10.a/vop.o"
Running make for target ioracle
ApplySession adding interim patch '5574966' to inventory

Verifying the update...
Inventory check OK: Patch ID 5574966 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5574966 are present in Oracle Home.

The local system has been patched and can be restarted.

OPatch succeeded.
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5574966] (DEMO102)$ cd ../5128368
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5128368] (DEMO102)$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..

Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-37-14PM.log

ApplySession applying interim patch '5128368' to OH '/apps/oracle/10.2.0'
Invoking fuser to check for active processes.
Invoking fuser on "/apps/oracle/10.2.0/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/10.2.0')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5128368' for restore. This might take a while...
Backing up files affected by the patch '5128368' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libserver10.a" with "lib/libserver10.a/kko.o"
Running make for target ioracle
ApplySession adding interim patch '5128368' to inventory

Verifying the update...
Inventory check OK: Patch ID 5128368 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5128368 are present in Oracle Home.

The local system has been patched and can be restarted.

OPatch succeeded.
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5128368] (DEMO102)$ cd ../5683652
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5683652] (DEMO102)$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..

Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-38-14PM.log

ApplySession applying interim patch '5683652' to OH '/apps/oracle/10.2.0'
Invoking fuser to check for active processes.
Invoking fuser on "/apps/oracle/10.2.0/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/10.2.0')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5683652' for restore. This might take a while...
Backing up files affected by the patch '5683652' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libclient10.a" with "lib/libclient10.a/kpugem.o"

Patching component oracle.rdbms.rsf, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libclient10.a" with "lib/libclient10.a/kpugem.o"
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '5683652' to inventory

Verifying the update...
Inventory check OK: Patch ID 5683652 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5683652 are present in Oracle Home.

The local system has been patched and can be restarted.

OPatch succeeded.
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5683652] (DEMO102)$ cd $ORACLE_HOME
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..

Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-39-11PM.log

Lsinventory Output file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2007-12-28_22-39-11PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.

Interim patches (5) :

Patch 5683652 : applied on Fri Dec 28 22:38:58 CET 2007
Created on 5 Jul 2007, 01:27:01 hrs PST8PDT
Bugs fixed:
5683652

Patch 5128368 : applied on Fri Dec 28 22:38:04 CET 2007
Created on 23 Mar 2007, 00:53:55 hrs PST8PDT
Bugs fixed:
5128368

Patch 5574966 : applied on Fri Dec 28 22:36:53 CET 2007
Created on 4 Apr 2007, 05:58:26 hrs PST8PDT
Bugs fixed:
5574966

Patch 5556081 : applied on Fri Dec 28 22:23:43 CET 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Fri Dec 28 22:23:31 CET 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974

--------------------------------------------------------------------------------

OPatch succeeded.
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$

Then, if you want to create a "seed" database to play as well, the simplest way is still DBCA, in XClient session :

Change the datafiles location as you want :

[...]

Don't forget to update your tnsnames.ora file (on the server as on the client), and starting the listener.
Because I experienced the error tns-12546 permission denied, I did the workaround :
[root@orion:/var/tmp] ()$ ls -alrt
total 24
drwxr-xr-x 23 root root 4096 Dec 16 22:14 ..
drwxrwxrwt 3 root root 4096 Dec 27 21:28 .
drwxrwxrwt 2 root oinstall 4096 Dec 27 21:29 .oracle
[root@orion:/var/tmp] ()$ chown ora102:dba .oracle
Then the listener has been started as well.

Have fun,

On The Peoplesoft Road