Peoplesoft (server) on Windows XP

Peoplesoft, the server part, has never been supported on Windows XP, and maybe will never supported.

So, why such article ?
On the Peoplesoft forum, there are a lot of questions about that configuration. And I receive a lot of questions. On one part I can understand for training and learning purpose.

On an other hand, I showed by the past through articles on this blog that was not so complicated, and much more interesting, to build a solution based on Linux with in a virtual machine.

Anyway, why not try it. I have to say once again, Peoplesoft (appserver, process scheduler and web server) is not supported on Windows XP.

1. Tuxedo 9.1 (downloaded from http://edelivery.oracle.com, Peopletools 8.49 folder, build B42600-01) Run the pstuxinstall.exe from the unzipped package :


On the following screen give the BEA HOME path directory you previously created. A tuxedo folder will be created inside. This version of Tuxedo include the rolling patch 036, you can check it into the file patchlev under udataobj :
2. BEA Weblogic 9.2 (downloaded from http://edelivery.oracle.com, Peopletools 8.49 folder, build B42602-01)
Run the server920-win32.exe from the unzipped package :

Choose the BEA HOME you previously created (the sane as the one for Tuxedo) :Don't need to choose a complete installation, here we don't need the developper part of BEA product, just the web server, check the custom install :Check only the server, the only one required componenet for our installation (that'll save disk space):Once more, we need only the minimal installation, uncheck the additional tool :
Choose the path directory where you want to install weblogic :


3. BEA Weblogic 9.2 maintenance pack 1 (downloaded from ftp://ftp.peoplesoft.com/outgoing/ptools/weblogic/9.20/mp1)
Run the server921_upgrade_win32.exe :

Choose your BEA HOME path directory :
It should recognize your previous installation :
4. BEA Weblogic 9.2 maintenance pack 1 patches 1 and 2 (downloaded from ftp://ftp.peoplesoft.com/outgoing/ptools/weblogic/9.20/mp1/patches)
Since my try, the patch 4 has been raised, it is bigger, but process is same, you could try it by yourself.
Copy the files installwlspatch.cmd, wls92mp1-p1.zip and wls92mp1-p2.zip into the BEA_HOME directory you defined earlier. Then run the installation command from a DOS window :
installwlspatch.cmd wls92mp1-p1.zip
That'll install at what required itself. Same for the second patch, and in case same for the latest one.


Check the existence of txt files with the same name as the patch.

5. PeopleTools 8.49 (downloaded from http://edelivery.oracle.com, Peopletools 8.49 folder, build B42585-01,B42586-01, B42587-01, B42588-01, B42589-01, B42590-01 and B42591-01) I won't become on that point, it's exactly the same process as the one for Linux, GUI excepted. Here below just few key screenshots :


6. PeopleTools 8.49 patch 11 - only if you are licenced - (downloaded from ftp://ftp.peoplesoft.com/outgoing/ptools/84911) From the extracted package, under disk1, run setup.exe, and follow the exact process as the previous one.

7. Create your Application Server.
Don't forget to add a line with an IP address and your computer name into your Windows/system32/driver/etc/hosts file.
I'll use an existing remote Oracle database :
C:\app\psoft\hrms9\appserv>psadmin

PSADMIN -- Tools Release: 8.49.11
Copyright (c) 1988, 2003, Oracle. All rights reserved.
[...]
----------------------------------------------
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 :[c:\app\oracle\11.1.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
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=c:\app\oracle\11.1.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.
[...]
-------------------------------
PeopleSoft Domain Boot Menu
-------------------------------
Domain Name: DMOHRMS9

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

Command to execute (1-2, q) [q]: 1
Attempting to boot bulletin board...
tmadmin - Copyright (c) 1996-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=560 ... 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 64419 -C psappsrv.cfg -D DMOHRMS9 -S PSWATCHSRV :
process id=2652 ... Started.
exec PSAPPSRV -s@..\psappsrv.lst -s@..\psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PS
APPSRV :
process id=2664 ... Started.
exec PSAPPSRV -s@..\psappsrv.lst -s@..\psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PS
APPSRV :
process id=2136 ... Started.
exec PSAPPSRV -s@..\psappsrv.lst -s@..\psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PS
APPSRV :
process id=2716 ... Started.
exec PSSAMSRV -A -- -C psappsrv.cfg -D DMOHRMS9 -S PSSAMSRV :
process id=2684 ... Started.
exec PSMONITORSRV -A -- -ID 64419 -C psappsrv.cfg -D DMOHRMS9 -S PSMONITORSRV :
process id=2728 ... Started.
exec WSL -A -- -n //INDUS:7000 -z 0 -Z 0 -I 5 -T 60 -m 1 -M 3 -x 40 -c 5000 -p 7001 -P 7003 :
process id=2772 ... Started.
exec JSL -A -- -n //INDUS:9000 -m 5 -M 7 -I 5 -j ANY -x 40 -S 10 -c 1000000 -w JSH :
process id=1728 ... Started.
exec JREPSVR -A -- -W -P C:\app\psoft\hrms9\appserv\DMOHRMS9\jrepository :
process id=512 ... Started.
9 processes started.

8. Create your WebServer.
C:\app\psoft\hrms9\setup\PsMpPIAInstall>setup.exe -console -is:javahome C:\app\bea\jdk150_06
You have to give the java home here jdk150_06, coming from the Weblogic patches. A new DOS window will appear to the screen.
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.11

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.

Cliquez sur 1 pour Suivant, 3 pour annuler ou 5 pour afficher Ó nouveau [1]


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

Indiquez un nom de rÚpertoire ou cliquez sur EntrÚe.
[C:\app\psoft\hrms9]

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]

SÚlectionnez le type d'installation le mieux adaptÚ Ó vos besoins.

[X] 1 - Oracle Application Server

[ ] 2 - BEA WebLogic Server

[ ] 3 - IBM WebSphere Server

Pour sÚlectionner une option, indiquez le numÚro correspondant ou 0, lorsque
vous avez terminÚ : [0]2

Entrez 0 pour poursuivre ou 1 pour faire une autre sÚlection : [0]

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Select the web server root directory:

Indiquez un nom de rÚpertoire ou cliquez sur EntrÚe. [C:\Bea] C:\app\bea

Detected web server version: WebLogic 9.2.1

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Please enter the administrator login and password for WebLogic domain.

Login ID:

[system]
Password:[password]

:

Re-type Password:[password]

:

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Select domain type:


[X] 1 - Create New WebLogic Domain

Pour sÚlectionner une option, indiquez le numÚro correspondant ou 0,
lorsque vous avez terminÚ [0]:

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Enter domain name or click Next to select default:

[peoplesoft]

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]

Please select the configuration to install.

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

Pour sÚlectionner une option, indiquez le numÚro correspondant ou 0, lorsque
vous avez terminÚ : [0]


Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Please specify a name for the PeopleSoft web site:

Website name:

[ps] DMOHRMS9

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Enter port numbers and summaries.

AppServer name:

[indus]

JSL Port:

[9000]

HTTP Port:

[80]

HTTPS Port:

[443]

Authentication Token Domain:(optional)

[]

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [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]

User ID:

[PTWEBSERVER]

Password:[PTWEBSERVER]

:

Re-type Password:[PTWEBSERVER]

:
:
Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [1]


Select the Report Repository location:

Indiquez un nom de rÚpertoire ou cliquez sur EntrÚe. [c:\psreports] e:\psreports

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [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

C:\app\bea

9.2

peoplesoft

PORTAL

PSIGW

PSINTERLINKS

PSOL

PSEMHUB

helloportletapp

pspc

testsuite

wsrptest

DMOHRMS9


indus

9000

80

443

e:\psreports

C:\app\psoft\hrms9\webserv

Cliquez sur 1 pour Suivant, 2 pour PrÚcÚdent, 3 pour annuler ou 5 pour afficher
Ó nouveau [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.

Cliquez sur 3 pour terminer ou 5 pour afficher Ó nouveau [3]

9. Start you WebServer and enjoy with your front end application on XP
C:\app\psoft\hrms9\webserv\peoplesoft\bin>startPIA.cmd
[...]
Attempting to start WebLogic Server 'PIA'

starting weblogic with Java version:
java version "1.5.0_04"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_04-b05)
Java HotSpot(TM) Client VM (build 1.5.0_04-b05, mixed mode)
[...]
11 juin 2008 22 h 03 CEST Notice WebLogicServer BEA-000360 Server started in RUNNING mode
[...]

Lastly, in your favorite browser :

So, no issue on the installation of Application and Web servers. But once more, it is not supported.

Have fun,

Cube

Today, a question on the Oracle forum for a alternate query (here)

Coming from a bad design, find the sum of two columns, grouping by two others columns.
The first thing coming in mind is a subquery with a UNION ALL :
select dt, ccy, sum(amt) amt
from (select dt, ccy1 as ccy, amt1 as amt from a
union all
select dt, ccy2 as ccy, amt2 as amt from a)
group by dt,ccy;

Then, trying to avoid it :
select dt, decode(t,1,ccy1,2,ccy2) ccy, sum(decode(t,1,amt1,2,amt2)) amt
from a , (select 1 t from dual union select 2 from dual)
group by dt, decode(t,1,ccy1,2,ccy2);

As we can see in the thread, the UNION ALL (which implies 2 table scan) is more performant than 1 table scan (implies a cartesian product and DECODE usage).

Well, all was said, until the nice demo of CUBE usage by DimaCit, the query is now the following :
with X as (
select dt, ccy1, sum(amt1) amt1, ccy2, sum(amt2) amt2
from a
group by dt, cube(ccy1, ccy2)
)
select x1.dt, x1.ccy1, x1.amt1 + x2.amt2
from X x1, X x2
where x1.dt = x2.dt
and x1.ccy1 is not null and x1.ccy2 is null
and x2.ccy2 is not null and x2.ccy1 is null
and x1.ccy1 = x2.ccy2;

I have to say I never thought about CUBE() on those cases.
So, very nice query, a little bit tricky, and a very good point for the best performance !
A nice demo of CUBE usage. Thank to DimaCit

Addendum : the solution doesn't work if one of the currency is not in the other column, then the CUBE solution is no more a solution. Thanks to Dominic Brooksfor comment it out this point.

Peoplesoft Peopletools upgrade : 8.49.11

Some days ago, I planned to upgrade to Peopletools 8.49.10, but since that time a new patch has been released, so why not try it.
My current Peopletools version is 8.49.07, and the Peopletools patches are cumulative, don't need to apply every patches until the latest one.

So, let's go for the upgrade.
Four mains steps :
1. Upgrade the Peopletools software of your MS Windows client
2. Upgrade the Peopletools software of your server (below on OEL4.6)
3. Upgrade the database
4. Redeploy your web server

Firstly, you'll need to download the patch (more than 1Gb, and that increase very patch) on ftp://ftp.peoplesoft.com/outgoing/ptools
Then, of course, you'll need a valid customer identifier to get the password of the downloaded zipped file (do I need to say that's illegal to share ?).

1. Anyway, here we go first for the MS Windows client upgrade, easily, clickable and apply. At this step, you'll need the Oracle code licence for Peoplesoft Peopletools here (the code depend of the database you are working on).
Run the setup.exe file into cd84911/disk1 directory, then basically follow the instructions : Here you have to give your current PS_HOME you want upgrade : Run the Application Designer, or DataMover to verify you are good or not : 2. On your Linux server now, nothing special, except the DISPLAY variable setting as to be used : [root@orion:/root]$ cd /nfs/software
[root@orion:/nfs/software]$ cd PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1
[root@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ ls -lrt
total 325804
-rwxr--r-- 1 root root 976 May 12 02:46 readme.txt
-rwxr--r-- 1 root root 13 May 13 08:19 media.inf
-rwxr--r-- 1 root root 7638720 May 13 08:31 setup.jar
-rwxr--r-- 1 root root 31046656 May 13 08:31 setup.linux
-rwxr--r-- 1 root root 81633280 May 13 08:31 setup.hp
-rwxr--r-- 1 root root 47185920 May 13 08:31 setup.solaris
-rwxr--r-- 1 root root 25104596 May 13 08:31 setup.exe
-rwxr--r-- 1 root root 95426560 May 13 08:31 setup.hp-ia64
-rwxr--r-- 1 root root 139264 May 13 08:32 setup.zlinux
-rwxr--r-- 1 root root 139264 May 13 08:32 setup.unix
-rwxr--r-- 1 root root 44913664 May 13 08:32 setup.aix
drwxr-xr-x 3 root root 4096 May 26 20:55 setup
[root@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ chmod a+x setup.linux
[root@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ su - crm9
[crm9@orion:/apps/psoft/crm9]$ cd /nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1
[crm9@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ ls -lrt
total 325804
-rwxr--r-- 1 root root 976 May 12 02:46 readme.txt
-rwxr--r-- 1 root root 13 May 13 08:19 media.inf
-rwxr--r-- 1 root root 7638720 May 13 08:31 setup.jar
-rwxr-xr-x 1 root root 31046656 May 13 08:31 setup.linux
-rwxr--r-- 1 root root 81633280 May 13 08:31 setup.hp
-rwxr--r-- 1 root root 47185920 May 13 08:31 setup.solaris
-rwxr--r-- 1 root root 25104596 May 13 08:31 setup.exe
-rwxr--r-- 1 root root 95426560 May 13 08:31 setup.hp-ia64
-rwxr--r-- 1 root root 139264 May 13 08:32 setup.zlinux
-rwxr--r-- 1 root root 139264 May 13 08:32 setup.unix
-rwxr--r-- 1 root root 44913664 May 13 08:32 setup.aix
drwxr-xr-x 3 root root 4096 May 26 20:55 setup
[crm9@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ export DISPLAY=0.0
[crm9@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ ./setup.linux -is:javaconsole -console




Initializing Wizard........

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


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

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

PeopleTools 8.49.11




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.11 Install Location

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

Directory Name: [/opt/PT8.49.11] /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.11" you would like to install:

PeopleTools 8.49.11

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.11 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.11. Please wait...


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

Setting Files Permission... Please wait

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

Press 3 to Finish or 5 to Redisplay [3]

[crm9@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$

3. The upgrade of database, 3 steps :
3.1 Open the DataMover tool within the Peoplesoft user and run the script PS_HOME/script/PTPATCH.dms


3.2 Open the Application Designer, and copy the projects PATCH849 and PATCH849ML if you are using a multilingual application.




3.3 Open the DataMover tool in bootstrap mode (the owner of Peoplesoft object, SYSADM in most of case), and run the PS_HOME/scripts/MSGTLSUPG.dms and MSGTLFRA.dms (FRA for French, if you have) :



4. Start your Application server and Process scheduler :

[crm9@orion:/nfs/software/PeopleSoftCD/PeopleTools/PT8.49/PeopleTools8.49.11/cd84911/disk1]$ cd $PS_HOME
[crm9@orion:/apps/psoft/crm9]$ cd appserv
[crm9@orion:/apps/psoft/crm9/appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.49.11
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) DMOCRM9

Select domain number to administer: 1



--------------------------------
PeopleSoft Domain Administration
--------------------------------
Domain Name: DMOCRM9

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

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 DMOCRM9/Archive/psappsrv.cfg to DMOCRM9/Archive/psappsrv_051308_2336_04.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=14083 ... 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 43641 -C psappsrv.cfg -D DMOCRM9 -S PSWATCHSRV :
process id=14085 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOCRM9 -S PSAPPSRV :
process id=14086 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOCRM9 -S PSAPPSRV :
process id=14094 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOCRM9 -S PSAPPSRV :
process id=14102 ... Started.
exec PSSAMSRV -A -- -C psappsrv.cfg -D DMOCRM9 -S PSSAMSRV :
process id=14110 ... Started.
exec PSMONITORSRV -A -- -ID 43641 -C psappsrv.cfg -D DMOCRM9 -S PSMONITORSRV :
process id=14117 ... Started.
exec WSL -A -- -n //orion.phoenix-nga:7010 -z 0 -Z 0 -d unused -I 5 -T 60 -m 1 -M 3 -x 40 -c 5000 -p 7011 -P 7013 :
process id=14124 ... Started.
exec JSL -A -- -d unused -n //orion.phoenix-nga:9010 -m 5 -M 7 -I 5 -j ANY -x 40 -S 10 -c 1000000 -w JSH :
process id=14126 ... Started.
exec JREPSVR -A -- -W -P /apps/psoft/crm9/appserv/DMOCRM9/jrepository :
process id=14132 ... Started.
9 processes started.


--------------------------------
PeopleSoft Domain Administration
--------------------------------
Domain Name: DMOCRM9

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


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


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


Database list:

1) DMOCRM9

Select item number to start: 1

psprcs.cfg has changed archiving old one...
Copying Archive/psprcs.cfg to Archive/psprcs_012708_2118_32.cfg

Starting Process Scheduler Server PSUNX for Database DMOCRM9 ...

Booting all admin and server processes in /apps/psoft/crm9/appserv/prcs/DMOCRM9/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=14150 ... Started.

Booting server processes ...

exec PSMSTPRC -A -- -C psprcs.cfg -CD DMOCRM9 -PS PSUNX -A start -S PSMSTPRC :
process id=14151 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOCRM9 -S PSAESRV :
process id=14160 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOCRM9 -S PSAESRV :
process id=14168 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOCRM9 -S PSAESRV :
process id=14176 ... Started.
exec PSDSTSRV -p 1,600:1,1 -sPostReport -- -C psprcs.cfg -CD DMOCRM9 -PS PSUNX -A start -S PSDSTSRV :
process id=14184 ... Started.
exec PSPRCSRV -sInitiateRequest -- -C psprcs.cfg -CD DMOCRM9 -PS PSUNX -A start -S PSPRCSRV :
process id=14206 ... Started.
exec PSMONITORSRV -A -- -ID 197104 -C psprcs.cfg -PS PSUNX -S PSMONITORSRV :
process id=14218 ... Started.
8 processes started.


And lastly, redeploy your web server application :
[crm9@orion:/apps/psoft/crm9/appserv]$ su - weblogic
Password:
[weblogic@orion:/home/weblogic]$ cd /apps/psoft/crm9/
[weblogic@orion:/apps/psoft/crm9]$ ls
appserv cblbin data etc jre log psconfig.sh PSEMViewer sdk secvault setup.log src utility web
bin crw dict fonts jre1.5.0 peopletools.properties PSEMAgent scripts SecurityAddIns setup sqr toolsadmin.sh verity webserv
[weblogic@orion:/apps/psoft/crm9]$ cd setup
[weblogic@orion:/apps/psoft/crm9/setup]$ ls
AdvancedConfigurator endorsed parmfile PsCIA PsMpDbInstall pstuxenv.sh SH UPGCOMPVIEWER
dashboard install_endorsed.sh pkgs psdb.sh PsMpPIAInstall pstuxftp.txt unicode.cfg WINDOWS
dbcodes.cr mpwebappdeploy PsCA psdmtx.cfg PsMpWebAppDeployInstall PsUa uninstall_endorsed.sh
dbcodes.pt NOTESDB pscbl.mak PsMpCrystalInstall psrun.mak pt_responsefile.txt unpack_jre.sh
[weblogic@orion:/apps/psoft/crm9/setup]$ cd PsMpPIAInstall
[weblogic@orion:/apps/psoft/crm9/setup/PsMpPIAInstall]$ export DISPLAY=0.0
[weblogic@orion:/apps/psoft/crm9/setup/PsMpPIAInstall]$ ./setup.linux -is:javaconsole -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.11



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/crm9

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

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
[ ] 2 - Existing WebLogic Domain

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


[ ] 1 - Create New WebLogic Domain
[X] 2 - Existing 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]


Select domain name from list:


[X] 1 - peoplesoft

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

The domain name already exists. Please select an action:


[X] 1 - Install additional PeopleSoft site
[ ] 2 - Redeploy PeopleSoft Internet Architecture
[ ] 3 - Re-create WebLogic domain and redeploy PeopleSoft Internet Archite
[ ] 4 - Deploy additional PeopleSoft application extensions

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


[ ] 1 - Install additional PeopleSoft site
[X] 2 - Redeploy PeopleSoft Internet Architecture
[ ] 3 - Re-create WebLogic domain and redeploy PeopleSoft Internet Archite
[ ] 4 - Deploy additional PeopleSoft application extensions

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]

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] DMOCRM9

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] 9010

Authentication Token Domain:(optional)

[]

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]

User ID:

[PTWEBSERVER]

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

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 :

Report repository directory :

PIA webserver directory :

weblogic

/apps/bea/weblogic/9.2

9.2

peoplesoft

PORTAL

PSIGW

PSINTERLINKS

PSOL

PSEMHUB

helloportletapp

pspc

testsuite

wsrptest

DMOCRM9


orion

9010

/psreports

/apps/psoft/crm9/webserv

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

BUILD SUCCESSFUL
Total time: 0 seconds
100 % complete


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/crm9/setup/PsMpPIAInstall]$

And start the Webserver as well :
[weblogic@orion:/apps/psoft/crm9/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/crm9/webserv/peoplesoft/servers/PIA/logs/PIA_*
PID for WebLogic Server PIA is: 15179
[weblogic@orion:/apps/psoft/crm9/webserv/peoplesoft/bin]$ tail -f /apps/psoft/crm9/webserv/peoplesoft/servers/PIA/logs/PIA_stdout.log

[...]
BUILD SUCCESSFUL
Total time: 0 seconds
100 % complete


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/crm9/setup/PsMpPIAInstall]$

And start your Web server :
[weblogic@orion:/apps/psoft/crm9/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/crm9/webserv/peoplesoft/servers/PIA/logs/PIA_*
PID for WebLogic Server PIA is: 15179
[weblogic@orion:/apps/psoft/crm9/webserv/peoplesoft/bin]$ tail -f /apps/psoft/crm9/webserv/peoplesoft/servers/PIA/logs/PIA_stdout.log

You can run a DDDAUDIT report to validate your upgrade.

Peoplesoft Application : Oracle database 10.2.0.4 upgrade

Upgrade a database of a Peoplesoft Application doesn't change to upgrade a standard database.

For the upgrade to 10.2.0.4 Oracle database, you'll need an additional required patch for Linux #6376928.

After upgraded the binaries, don't forget to patch the database as well and to run the utlrp.sql script.
startup upgrade
@$ORACLE_HOME/rdbms/admin/utlu102i.sql
@$ORACLE_HOME/rdbms/admin/catupgrd.sql
shutdown immediate
startup
@$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ -----------
Oracle Database Catalog Views
10.2.0.4.0 VALID

Oracle Database Packages and Types
10.2.0.4.0 VALID


2 rows selected.

WARNING : don't forget to modify the rights as well on the library file (as oracle user, under $ORACLE_HOME/lib) for the OS user who start the Application server :
[ora102@orion:/apps/oracle/10.2.0/lib]$ ls -lrt libclntsh.so*
lrwxrwxrwx 1 ora102 oinstall 12 Jan 8 21:02 libclntsh.so.9.0 -> libclntsh.so
lrwxrwxrwx 1 ora102 oinstall 17 May 13 21:48 libclntsh.so -> libclntsh.so.10.1
-rwxr-x--- 1 ora102 oinstall 19009171 May 13 21:49 libclntsh.so.10.1
[ora102@orion:/apps/oracle/10.2.0/lib]$ chmod a+rx libclntsh.so.10.1
[ora102@orion:/apps/oracle/10.2.0/lib]$ ls -lrt libclntsh.so*
lrwxrwxrwx 1 ora102 oinstall 12 Jan 8 21:02 libclntsh.so.9.0 -> libclntsh.so
lrwxrwxrwx 1 ora102 oinstall 17 May 13 21:48 libclntsh.so -> libclntsh.so.10.1
-rwxr-xr-x 1 ora102 oinstall 19009171 May 13 21:49 libclntsh.so.10.1
[ora102@orion:/apps/oracle/10.2.0/lib]$
If you forget the step above, you may encoutered issue on the Application server start (Missing or invalid version of SQL library libpsora)

It was quite fast, despite the size and number of objects of the Peoplesoft databases.

Time for upgrades

Since the Peopletools 8.49.10 has been available two weeks ago, I think it's time to manage an upgrade. And fortunately, the Peopletools patches are cumulative, so we can easily jump directly from my current 8.49.08 to 8.49.10.

Moreover, Oracle database 10.2 has seen some weeks ago a new patchset, 10.2.0.4.
It has been certified for the Peoplesoft Peopletools (8.22, 8.46, 8.47, 8.48 and 8.49) with an additional required patch #6376928 for Linux/Unix, and #6981215 for Windows plateform.

Surprising, the Peopletools 8.44 and 8.45 are not supported at all on Oracle 10g (bot release 1 and release 2), and seems even not be planned.

Upgrades to be followed soon.

FSCM9.0 install : UPGPT848IBUG

The installation of FSCM9.0 for DEMO purpose is not different of what I showed earlier with HRMS9.0 and CRM9.0
By following the same steps, I was able to install FSCM9.0 without any problem.
The difference is mainly on the Licence code.

Well, only one exception. By following the installation steps, we have to run several Application Engine programs.

Including the UPGPT848IBUG for Integration Broker Objects.
It fails has below :
E:\apps\psoft\fscm9\bin\client\winx86>psae -CD DMOFSCM9 -CT ORACLE -CO VP1 -CP VP1 -R INSTALL -AI UPGPT848IBUG
PeopleTools 8.49.08 - Application Engine
Copyright (c) 1988-2008 PeopleSoft, Inc.
All Rights Reserved


Error retrieving Application Engine UPGPT848IBUG.MAIN component: Step Step01, PeopleCode (108,502)
Message Set Number: 108
Message Number: 502
Message Reason: Error retrieving Application Engine UPGPT848IBUG.MAIN component: Step Step01, PeopleCode (108,502)

E:\apps\psoft\fscm9\bin\client\winx86>

Addendum : after rereading the Installation Guide (a very small note into), you should NOT run this AE if the Application you are installing has been built on Peopletools 8.48 or later. I'm working on Peopletools 8.49.08.
Consequently, the Peoplesoft application run fine, even without this AE.

Have fun to the Peoplesoft Installation Guide reading !

Peoplesoft FSCM9.0 - space required

On that 1st of May and after the famous Queen's Day (Koninginnedag in Dutch), new task on my lab. FSCM installation.

Every FSCM version insrease the number of Peoplesoft objects. This one is not an exception :
SQL> select object_type, count(*)
2 from dba_objects
3 where owner='SYSADM'
4 group by object_type;
OBJECT_TYPE COUNT(*)
------------------- ----------
LOB 2036
TRIGGER 195
TABLE 71871
INDEX 66194
VIEW 27267
Ouch, more than 70,000 tables, good luck to maintain the database.

Moreover, the DMO database is huge, around 90Gb only for sample (!), here below the biggest tablespaces (extents):
TABLESPACE_NAME EXTSIZEMB
------------------------------ ----------
POWORK 575.875
POLARGE 654
INWORK 664.75
ARLARGE 817
OMWORK 930.75
PCLARGE 990
INLARGE 1134
AMLARGE 1185
EOCULRG 1280
APLARGE 1597
SYSTEM 1720.0625
PSIMAGE 1797
PSINDEX 67495

I have to say it was a nightmare to build it on my lab. The indexes (number and size) are really impressive. I had to increase dramatically the disk space available on my VM, some good advices here
If you decide to go for a FSCM9.0 installation, check the space on your device and be patient, it's very long.

Enjoy with Peoplesoft installation !

Peoplesoft new certification path

Good news, Peoplesoft (PeopleTools 8.48 and 8.49) has been certified on Oracle 11gR1 !
Please, read on Peoplesoft Technology blog the news certification paths.
Furthermore, the PeopleTools 8.48 are already certified on Oracle Entreprise Linux 5, the 8.49 version is still on the road.

Enjoy,

VMWare Server 2 Beta and NAS Server

Well, I know, that's a beta version, but anyway, such behaviour are really disapointed.
I'll explain.

I use VMWare Server 2 beta since December 2007 for a lot of virtual machines on my lab.
Until few days ago, I worked mainly on my local hard drive (500Gb), and all worked fine.
I had the need of more space, then I created virtual machines on USB drive. Well, that was slow, but it is working., except the need to start the USB drive before the host.

Now, need much more space, I bought a NAS Server, QNAP TS-409 Pro, with 4 disks of 1Tb, configured on a RAID 5 array.

I moved (copy) a virtual machine there, after configuring the datastore as well on CIFS mount. It was working fine until I rebooted my host. What was my surprise to see my virtual machine was in state unknown (inaccessible)... Even the datastore is not reachable anymore.

I tried many things, including the reboot of the VM services, Tomcat services and so on, but nothing help.

Well, I'm still able to drop the virtual machine and datastore, recreate them on the existing folder, and retrieve my virtual machine as well. But I don't expect to do that each time I bounce my host !

Any clue ?

Anyway, it's a beta version, but after testing on the previous version 1.0.4, it worked fine on that last one, so, I'll downgrade my config.

That's a pity, I liked a lot this version 2, however, this problem stop here my experience on this one.
Other main problems on that beta (which I could live with) :
1. A lot of full screen issues.
2. Memory occupation size by Tomcat server.


Enjoy on the comeback of VMWare 1.0.4,