Step 9: Completing the Database Setup:
This step is a very critical step and should performed with very much attention. Below mentioned steps are the ones which I thought were required for the environment I was building but I very highly recommend that you perform this step from the Oracle Installation document which can be found here. Look at Chapter 7 in this document.
Updating PeopleTools System Tables:
-
Here PS_HOME is the directory where you have installed your PeopleTools. In our case its C:\PT852 directory.
-
Got to PT852\scripts and run rel851u.sql and rel852u.sql sql scrips.
-
Edit and run the grant.sql script in the PS_HOME\scripts directory. This will grant permissions to the CONNECTID. Run the script as a user with Microsoft SQL Server system administrator privileges.
-
Invoke Data Mover by running PS_HOME\bin\client\winx86\psdmt.exe. The PeopleSoft Logon window appears.Log on using a valid PeopleSoft Operator ID, such as PS for HRMS.
-
Run the storeddl.dms Data Mover script in the PS_HOME\scripts directory.
-
Invoke Data Mover by running PS_HOME\bin\client\winx86\psdmt.exe. The PeopleSoft Logon window appears. Log on using the ACCESSID you specified when you created your Data Mover scripts with the Database Setup program. This will start Data Mover in bootstrap mode.
-
Run the msgtlsupg.dms Data Mover script in the PS_HOME\scripts directory. This will update the PeopleSoft PeopleTools messages in your database.
Updating PeopleTools Database Objects
-
Launch Appplication Designer and sign on to your databse with a valid PeopleSoft UsedID.
-
Select Tools, Copy Project, From File.
-
In the resulting dialog box, change the import directory to PS_HOME\projects, select PPLTLS84CUR from the list of projects and click the Select button.
Altering PeopleTools Tables:
-
Launch Application Designer with a valid PeopleSoft user ID and sign on to the installed database. Select File, Open. Select Project, enter PPLTLS84CUR in the name dialog box, and click OK.
-
Select Build, Project.
-
Select Create Tables and Alter Tables in the Build Options region.
-
Select Build script file in the Build Execute Options region.
-
Click Setting. The Build setting dialog box appears:
Updating the PeopleTools System Data:
-
Invoke Data Mover by running PT852\bin\client\winx86\psdmt.exe. The peoplesoft logon window appears.
-
Log on with the AccessID and Password.
-
Run the DataMover scripts from the application database version. In our case run Pt851tls.dms and pt852tls.dms
-
Run the pslanguages.dms Data Mover script in the PS_HOME\scripts directory.
-
Run the tlsupgnoncomp.dms Data Mover script in the PS_HOME\scripts directory.
-
Open Data Mover using a valid PeopleSoft Operator ID, such as PS for HRMS
-
Run the msgtleng.dms Data Mover Script in the PS_HOME\scripts directory.
-
Run the ptstreng.dms Data Mover script in the PS_HOME\scripts directory.
-
Run the storept.dms Data Mover script in the PS_HOME\src\cbl\base directory.
-
Run the ptdefnsec.dms Data Mover script in the PS_HOME\scripts directory.
-
Run the createvw.dms Data Mover script in the PS_HOME\scripts directory.
This concludes post database configurations.
Step10: Configuring the Application Server on Windows:
-
Go to command prompt and go the the location C:\PT852\appserv
-
Type PSAdmin and click enter
-
Select 1 for Application Server and press enter.
-
Specit 2 to Create a domain and press enter.
-
Enter the domain name to create: say HR84
-
Specify 4 for small if this is your initial domain installation and press Enter.
-
After the system creates the domain, this prompt appears:
-
Would you like to configure this domain now? (y/n) [y] :
Enter y. The PeopleSoft Application Server Administration menu appears with a Quick-configure menu
similar to this:
---------------------------------------------------------
Quick-configure menu -- domain: HR84
---------------------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 15) DBNAME :[HR84]
2) Quick Server : No 16) DBTYPE :[MICROSFT]
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 :[c:\Program FilesÞ
\Microsoft SQL Server\100\Tools\Binn]
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]
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):
· Press 6 and Enter this is enable WSL
· Press 8 and Press Enter this will disable Event Notifications.
· Press 17 and type PS
· Press 18 and type PS
· Press 21 and Type PSCID ( This will be your connect ID)
· Press 22 and Type P@ssw0rd (This will be your connedID Password)
· Press 13 and this will Load the configuarations which we configured above.
-
In the next menu, select 1 to Boot this Domain
-
In the next menu, select 1 for Serial Boot and 2 for Parallel Boot. This will boot the domain which we created above.
-
Next we will be doing PIA installation so keep the App server up and running.
-
Check the screenshots for your references.
Step11: Setting up the PeopleSoft Pure Internet Architecture(PIA):
-
Go to PS_HOME\setup\PsMpPIAInstall and run setup.bat.
-
Click Next on the Welcome to the Installation Wizard for PeopleSoft Internet Architecture window.
-
Next follow the instruction’s as shown in the screenshots below.
-
This will create a PIA domain. Next step is to start this Domain.
-
GO to Command Prompt and go to C:\PT852\appserv location
-
Type psadmin and Press Enter.
-
Specify 4 for Web PIA Server
-
Select 1 for Administer a domain.
-
Select the domain you want to administer by entering the appropriate number.
-
To start a web server domain, enter 1, Boot this domain.
-
The boot command invokes the startPIA.cmd script, and you see the progress and a status message on the console window.
Starting the domain..................
The domain has started.
Step12: Accessing the PeopleSoft Application:
This concludes the installation and configuration of PeopleSoft HRMS 9.0 Application.