Database Application Webserver
Server Server
OS OS Web
Logic
Oracle Server s/w Oracle
Client or
Tuxedo Web Sphere
People
Tools People
Tools
People
Tolls Patches People Tools
Patches
HRMS/CRM
Modules Java 1.4
Batch Server Win NT Server
Tuxedo Win
NT OS
People Tool Java
1.4
PS Application MS
office
Cobol Crystal Reports
STEPS INVOLVED IN PEOPLESOFT INSTALLATION
INSTALL ORACLE → TUXEDO → PEOPLE TOOL → PS APPLICATION
(HRMS / Finance) → WebLogic / WebSphere → CREATE SHELL DATABASE →
↓
Open PS ←
Configure PIA ← Configure WebServer ← Configure Process Scheduler ← Configure
Application Server ← Run DATAMOVER SCRIPT
Webserver from browser
↓
Configure Report Node → Install PeopleBook → Configure
PeopleBook.
1. INSTALLATION OF SOFTWARES
·
Installation of Oracle Binaries.
·
Installation of Tuxedo.
·
Installation of People Tools.
·
Installation of Application (HRMS/Finance)
·
Installation of Webserver (WebLogic /
WebSphere)
2. CREATION OF SHELL DATABASE
Go to PS_HOME\scripts\nt and run the following scripts -
·
CREATEDB.SQL
: Creates the Database
·
UTLSPACE.SQL
: Run the scripts Catalog,
Catproc and Creates 2 Tablespace PSTEMP and PSDEFAULT.
·
DBOWNER.SQL
: Creates Operator id, ie.
PS
·
XXDDL.SQL : Creates all the Tablespace for the
Application and Auto Extend them
CRDDL.SQL=CRM,
EPDDL.SQL=Finance,
HCDDL=HRMS,
SADDL=Student Administration
·
PSROLES.SQL :
Creates Role PSUSER and PSADMIN
·
PSADMIN.SQL :
Creates the Access id
·
CONNECT.SQL :
Creates the Connect id
Your Shell Database is ready now.
3. Open the DataMover in Bootstrep mode and select the
Demo database.
-run the
script. ( to import application data)
-run the script <PS_HOME>\SCRIPT\MSGTLSUPG.DMS ( to update messages
of database)
4. Open
APPLICATION DESIGNER with Operator id. PS/PS
·
Copy Project
<PS_HOME>\projects\PPLTLS84CUR.
Updating Peopletools Database Objects
·
Copy Project
<PS_HOME>\projects\PPLTLS84CURDEL
Deleting Obsolete PeopleTools Database Objects.
·
Build a Script from
<PS_HOME>\projects\PPLTLS84CUR and run it
Compares Data Structure of Database Tables with PeopleTools Tables
·
Copy Project
<PS_HOME>\projects\PT84TBLSPC
Moving
Tables to different Tablespaces (PeopleSoft Data Dictionary).
·
Build a script from
<PS_HOME>\projects\PT84TBLSPC and run it
Moving
Tables to different Tablespaces(Oracle Data Dictionary)
5. Open Data mover in BOOTSTREP mode, Run the following
scripts from <PS_HOME>\scripts
PSLANGUAGES.DMS
TLSUPGNONCOMP.DMS
6. Open Data mover as PeopleSoft operator (PS ) Run the
following scripts from <PS_HOME>\scripts
MSGTLENG.DMS
PTSTRENG.DMS
CURRENG.DMS
STOREDDL.DMS
STOREPT.DMS, (This
script is at <PS_HOME>\src\cbl\base directory)
PTDEFNSEC.DMS
CREATEVW.DMS
7. Run the
PeopleTool Conversion app engine program from
<PS_HOME>\bin\client\winx86\
psae -CD HRDEMO01 -CT ORACLE -CO PS -CP PS -R
INSTALL -AI UPG844PORTAL
8. Run the Convert
Query Heading app engine program
<PS_HOME>\bin\client\winx86\
psae -CD
HRDEMO01 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGQRYDUPHED
9. Run the convert
setup manager app engine program
psae -CD
HRDEMO01 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPTSMDAT
10.Run the Convert nevigation collection and pagelet app
engine program
psae -CD
HRDEMO01 -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPT846PP
11. Run the version app engine program
psae -CD HRDEMO01 -CT ORACLE -CO PS -CP PS -R
INSTALL -AI VERSION
Configuring The Application Server on RedHat 9.0
Run
psadmin from <PS_Home > appserv
12. Set following patameter
15) UserId :[PS]
16) UserPswd :[PS]
13) DBNAME :[HRDEMO01]
19)
ConnectID :[people]
20) ConnectPswd :[peop1e]
22) WSL Port :[7000]
23) JSL Port :[9000]
24) JRAD Port :[9100]
13. load the configuration.
14 start webser
startserver
server1 / START PIA
15. start the mpinternet from
<PS_HOME>\setup\mpinternet
Set following patameter for MpInternet
PS_home :c:\pt8.45
webserver
directory :c:\pt8.45\webserv\Appserver
http
port :27000
https
port :29000
jsl port
:9000
16. Configure and start your application on internet :
stop and
uninstall other application running by default.
Run your
application.
17. Now open your application from net
the url
is : http://localhost:<http_port>/<application_name>/signon.html
18. Configure Report Node and PeopleBook
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Running Data Mover scripts
1. Steps to be followed on Installation workstation
(Windows)
2.
Configure the tnsnames using the Net Configuration Assistant
3.
Test the connectivity to the database instance on linux box i.e. HRDEMO01
4. Following details of the linux box are
required to do the configuration
IP Address/FQDN
Listener
port
Service
name
Database
SID
5.
Configure the PeopleSoft Application on windows box using (pscfg.exe) Configuration
Manager.
6.
Start the Data Mover in bootstrap mode. i.e. using the ACCESSID
7.
Invoke the database setup wizard File -> Database Setup
Select the Demo radio and add the
HRMS database to be installed.
Follow the instructions
It will generate and open a script as
hrms<DB_NAME>.dms
Suggestion/Troubleshooting:
Running this script will popup some errors
regarding to PSQRYFLAGS table, “column not
found”. To
prevent this error do the following workaround
Open the pt844tls.dms script from
<PS_HOME>/scripts directory and search for import of
PSQRYFLAGS table, copy the group of Data Mover
commands that import the that table.
Now open the hrms<DB_NAME>.dms file from
the same location (script generated by the
database setup wizard in data mover),
Paste the copied content just before the
statements that create the views .
8. Save and Run the script
9.
Run the scripts found at $PS_HOME/scripts in
following order using sqlplus and connecting to the database with ACCESSID
rel843.sql
rel844.sql
rel845.sql
10. Open App Designer
- Choose
Tools -> Copy Project -> Copy from file from
<PS_HOME>\projects
- Select
PPLTLS84CUR,
- Click
open Click on Copy
11.
Similarly copy the PPLTLS84CURDEL project
12.
Open the PPLTLS84CUR project as File -> Open -> Project
Build the project
Select Create table,
Alter table & Execute and build script
Click on Settings
Scripts Tab:
Write
alter comments to script
Output
to single file
Prompt
for each overwrite
Alter Table:
Drop
column if data present
Truncate data if field too short
Adds, Changes, Rename, Deletes
Alter by table rename
Create Tab:
Skip table
if already present
Recreate index only if modified
Click on OK
13.
Copy PT84TBLSPC project as, Tools - Copy Project - Copy from file
In the Copy From File
dialog box, click on Options,
General Options Tab :
Take DDL from source
Click on Copy
13.
Open the PT84TBLSPC project as File -> Open -> Project
Select build project
Select Alter tables
under build options
Select Execute and
build script
Click settings
Scripts Tab:
Write
alter comments to script
Output to single file
Prompt for each overwrite
Alter Tab:
Drop
column if data present
Truncate data if field too short
Adds, Changes, Rename, Deletes
Alter even if no change
Alter by table rename
Click OK, Copy
14.
Open Data mover in bootstrap mode,
Run the following
scripts from <PS_HOME>\scripts
MSGTLSUPG.DMS
PT843TLS.DMS
PT844TLS.DMS
PT845TLS.DMS
PSLANGUAGES.DMS
15.
Open Data mover as PeopleSoft operator (PS )
Run the following
scripts from <PS_HOME>\scripts
MSGTLENG.DMS
PTSTRENG.DMS
CURRENG.DMS
STOREDDL.DMS
STOREPT.DMS, this
script is at <PS_HOME>\src\cbl\base directory
PTDEFNSEC.DMS
CREATEVW.DMS
16.
Run the PeopleTool Conversion app engine program from
<PS_HOME>\bin\client\winx86\
psae -CD HRDEMO01 -CT
ORACLE -CO PS -CP PS -R INSTALL -AI UPG844PORTAL
17.
Run the Convert Query Heading app engine program
<PS_HOME>\bin\client\winx86\
psae -CD HRDEMO01 -CT
ORACLE -CO PS -CP PS -R INSTALL -AI UPGQRYDUPHED
18.
Run the version app engine program
psae -CD HRDEMO01 -CT
ORACLE -CO PS -CP PS -R INSTALL -AI VERSION
19.
Run DDDAUDIT.SQR and SYSAUDIT.SQR from <PS_HOME>\sqr
directory
20
Run the SETSPACE.SQR DMS Script
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Configuring The Application
Server on RedHat 9.0
Before
starting the configuration of the application server on the RedHat box we need
to set required environment variables to the psoft user’s login profile
1. Login
as psoft user and edit the .bash_profile file in his home diorectory
#su
– psoft
$
vi .bash_profile
2. The
content of the bash profile should be as below:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u02/psoft/HRDEMO01/bin/sqr/ORA/lib:/u03/oracle/lib
PATH=$PATH:$HOME/bin
.
/u02/psoft/HRDEMO01/psconfig.sh
Pls set this path anuj
this is problem why u don’t able to configure the same
export
NLSPATH=/u02/bea/tuxedo81/locale/C
export PATH
LD_LIBRARY_PATH
3. Logout
and login again as psoft user
4. Change
the current directory to $PS_HOME/appserv and execute the psadmin utility
$ cd
$PS_HOME/appserv
$
./psadmin
5.
It will display a console based menu, follow the onscreen instructions
Select option for Application Server
Select option to create a domain
Provide the domain name (same as your
DB_NAME)
Select configuration template (small
for DEMO purpose)
Select option to configure the
domain now.
A quick configure menu will be
displayed, select appropriate values.
---------------------------------------------------------------------
Quick-configure
menu -- domain: HRDEMO01
---------------------------------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 13) DBNAME
:[HRDEMO01]
2) Quick Server :
No 14)
DBTYPE :[ORACLE]
3) Query Servers :
No 15)
UserId :[PS]
4) Jolt :
Yes 16)
UserPswd :[PS]
5) Jolt Relay :
No 17)
DomainID :[HRDEMO01]
6) PC
Debugger : No 18) AddToPATH
:[.]
7) Opt
Engines : No 19) ConnectID
:[people]
8) Event Notification : Yes 20) ConnectPswd :[peop1e]
9) MCF
Servers : No 21) ServerName :[]
10) Perf Collator :
No 22) WSL Port :[7000]
23) JSL Port :[9000]
24) JRAD Port :[9100]
Actions
=========
11) Load config as shown
12) Custom configuration
h) Help for this menu
q) Return to previous menu
HINT:
Enter 13 to edit DBNAME, then 11 to load
6.
After the configuration is done, select option to boot the application server
for this domain
Messages are displayed on screen and this
will start number of processed depending on the options selected
during configuring this domain.
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Configuring
The Process Scheduler on RedHat 9.0
1.Login as
psoft user
# su
– psoft
2. Change
the current directory to $PS_HOME/appserv and execute the psadmin utility
$ cd
$PS_HOME/appserv
$
./psadmin
3.
It will display a console based menu, follow the onscreen instructions
Select option for Process Scheduler
Select option to Create a Process
Scheduler Server Configuration
Enter name of Database (DB_NAME)
Select option to configure the process
scheduler server.
A quick configure menu will be
displayed, select appropriate values.
----------------------------------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: HRDEMO01
----------------------------------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr :
Yes 6) DBNAME :[HRDEMO01]
2) App Eng Server : Yes
7) DBTYPE :[ORACLE]
3) Opt Eng Server : No
8)
PrcsServer :[PSUNX]
9) UserId :[PS]
10)
UserPswd :[PS]
11)
ConnectID :[people]
12) ConnectPswd :[peop1e]
13) ServerName :[]
Actions 14) Log/Output Dir :[%PS_SERVDIR%/log_output]
========= 15)
SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
4) Load config as
shown 16)
AddToPATH :[%PS_HOME%/cblbin]
5) Custom configuration
h) Help for this menu
q) Return to previous menu
HINT: Enter 6 to edit DBNAME, then 4 to load
4.
After the configuration is done, select option to boot the process scheduler
5. Messages
are displayed on screen and this will start number of processed depending on
the options selected
during configuring.
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Installation of PeopleSoft Internet
Architecture on RedHat
9.0
The
install will not proceed with an incorrect version of the WebLogic Server
Service Pack. Make sure the correct service pack version 2 for WebLogic Server
is properly installed prior to running this PeopleSoft Internet Architecture
install.
1. Login
as psoft user and change the current
directory to $PS_HOME/setup/mpinternet
Start the installation wizard as
$ cd $PS_HOME/setup/mpinternet
$./setup.linux
Note: If the
setup gives some errors regarding jvm start the installation on console mode as
$JAVA_HOME/bin/java
–cp setup.jar run –console
2. Follow the instructions displayed by the wizard and provide
appropriate values.
Select the Webserver to
use WebLogic/WebSphere, select WebLogic
Select the web server
root directory (/u02/bea), this is where WebLogic is installed
It will display the
WebLogic version, enter to proceed
Select the
default profile : PTWEBSERVER
Authentication Token Domain: (do not enter any thing here)
AppServer
name: (IP of the server)
JSL Port:
[9000] 9000
HTTP Port:[80] 8080
HTTPS Port:
[443]
Select
the Report Repository location:
/u02/psoft/psreports
3. A summary of selected values will be displayed. Verify that
the data is correct, and press ENTER to continue
the
file copy process.
Suggestion/Troubleshooting.
1.
Psoft user must have write permissions to this psreports directory.
2. If the
wizard displays error message saying that the required weblogic server not
found: this is error due to
invalid registry file in the BEA_HOME
(/u02/bea) directory. Installing tuxedo in the same directory as weblogic
will
rename the registry file installed by weblogic. To overcome this error do the
following step.
Login as psoft user
#
su – psoft
$cd
/u02/bea
$
mv registry.xml-old registry.xml
Starting the PeopleSoft Internet
Architecture
To
start the PIA execute the following commands:
$cd
$PS_HOME/webserv/HRDEMO01
$
./startPIA.sh
Note: the HRDEMO01 here
is the domain name provided during installing the PIA.
To stop
the PIA execute the stopPIA.sh script
To access the PIA
1.
Open your web browser.
2.
Enter the IP/FQDN, HTTP/HTTPS port and site name in the following sequence
http://<systemIP>:<httpport>/<sitename>/signon.html
ex.
http://10.199.131.163:8080/HRDEMO01/signon.html
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
12 Configuring Process Schedular Report NodeDistribution
Step
1
Navigate to PeopleTools ->Process
Scheduler ->Report Nodes
Create a new node HRDEMO01 (DB_NAME)
Configure the
report node for FTP
URL :
http://<systemIP>:<httpport>/psreports/<sitename>
Home directory: (directory of psreports)
Operating
System: UNIX
FTP Address: (IP of Linux Box)
FTP ID/password
: (psoft user or user having write permission on psreports)
Save
the settings
Step
2
Navigate to Process Scheduler -> Servers,
Search for PSUNX Server and open and go to
Distribution tab
In the distribution Node Name select the
node definition created in step 1
Specify other values
Bounce back the process scheduler
