Vishal Modi


  Home  |   Contact  |   Syndication    |   Login
  45 Posts | 0 Stories | 95 Comments | 0 Trackbacks


Tag Cloud


Post Categories

Image Galleries




Tuesday, January 24, 2012 #

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.


  • The Copy From File dialog box appears. Select all object types and then click the Copy button. When the progress window disappears, the project has been copied


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:




  • Click OK.The Build dialog box reappears. Click Build. Click Close when the process is completed.

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.





  • This concludes configuration of Application Server


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:

PS Sign On

PS HomePage

This concludes the installation and configuration of PeopleSoft HRMS 9.0 Application.

Step6: Installing People Tools 8.52:

  • After you download and extract the PeopleSoft PeopleTools installation files you can find the installer in PS_INSTALL/disk1. Launch the installer using setup.bat. Click Next when you see the Welcome screen for PeopleTools 8.52.
  • Follow the steps as shown in the screen shots below.













  • This concludes the installation of PeopleTools 8.52.

Step 7: Installation PeopleSoft Application Software (HRMS 9.0):

  • Download and extract the step up files at PS_APP_HOME location on C:\.
  • Launch the installer with Setup.bat.
  • Follow the instructions as shown in the screenshots below.









  • This concludes the installation of PeopleSoft HRMS 9.0

Step8: Installing and configuring PeopleSoft Databases:

  • Go to the location C:\PT853\setup\PsMpDbInstall, double click setup.exe
  • In the welcome screen click Next to continue and follow the instructions as shown in the screenshot below.

















Next steps continued in Part 3.


Vishal Modi

Environment what we are building consists of:

    • Operating System: Windows Server 2008 SP2.
    • Database Server: SQL Server 2008 with SP2.
    • PeopleSoft Application: PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0
    • PeopleTools: PeopleSoft PeopleTools 8.52
    • Web Server: Oracle Web Logic Server 10.3.4

The machine name given for this environment is WIN2K8 and currently only 1 user, the default username is Administrator and it is the local admin.

The below steps are performed with reference to the installation document of PeopleTools 8.52 on Microsoft SQL Serer provided by Oracle which can be found : This documentation is indeed very good and describes everything in very much details. Only drawback is that it is like 700 pages document and very tedious to go through. Hence thought of writing same instruction set but in bit easy format and more screenshots. 

Although, if you really want to understand the installation process and how each software works hand in hand with other then I highly recommend performing the installation with the Oracle PeopleSoft documentation.

If you have any issues during the Installation process, the best place to ask questions would be Oracle PeopleSoft Forums as the folks on that forums are certified PeopleSoft experts.

Step1: Download and install SQL Server 2008 with SP2:

  • Minimum requirement is Service Pack 2. If you have SP2 installed then you should see the SQL Server Native Client version as 2007.100.4000.00 as shown below in the screenshot. As of date, the latest Service Pack out for SQL Server 2008 is SP3 so even if you install SP3 then it works.


I am more of Microsoft Technologies person and not Oracle Technologies so installing and configuring SQL Server was easy. But still there are few important configurations which you need to perform in SQL too which you can find in the Oracle Documentations.

Step2: Download all software required from Oracle

  • Go to Https:// and sign in with your Oracle Account. If you do not have one, you can easily create one and its free registration.


  • On the Media Pack Search Page select Product Pack as PeopleSoft Enterprise and Platform as Microsoft Windows x64.

PS Ent X64

  • On the next page select PeopleSoft Human Resources Management System and Campus Solutions 9.0 Media Pack and select Continue.


  • On the next page download the following Softwares.

o PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0: Feature Pack - March 2011

o PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 Supplemental Installation Information (Revision 3)

o PeopleSoft PeopleTools 8.52 Disc 1 of 3

o PeopleSoft PeopleTools 8.52 Disc 2 of 3

o PeopleSoft PeopleTools 8.52 Disc 3 of 3

o Tuxedo 10gR3 for MS Windows Server 2008 w/MS VS 2008 x86 32-bit

o JRockit JDK R28.1 for Java SE 6 with JRockit Mission Control 4.0.1 for Microsoft Windows (64-bit x86)

o Oracle WebLogic Server 11gR1 (10.3.4) Generic and Coherence

Step3: Installing JRockit for Microsoft Windows:

  • Unzip the downloaded file and double click the setup file. Click Next on the Welcome screen window.


  • Change the installation directory to C:\Program Files\Java\jrockit-jdk1.6.0_20-R28.1.0-4.0.1 and click next


  • Keep the default values on all other pages and as shown in below screen shots.






  • This concludes the installation of JRockit.

Step4: Installing Oracle WebLogic on Windows:

  • Save the installation file wls_generic.jar from Oracle EDelivery in the directory called WLS_Install on C:\
  • Open a command prompt and go to WLS_INSTALL.
  • Set the environment variable JAVA_HOME to be the location where you installed the JRockit and Use the following command to launch the installer.


set JAVA_HOME=”C:\Program Files\Java\jrockit-jdk1.6.0_20-R28.1.0”

%JAVA_HOME%\bin\java -jar wls1034_generic.jar -mode=GUI -log=C:\WLS_Install\Wls1034Install.log


  • Wait for few seconds or also this might take few minutes and the Oracle WebLogic Installer Window will come up. Follow the instructionas as shown in the screenshots for next installation steps.



Remove the check box which says “I wish to receive security updates via My Oracle Support” . And click yes to remain uninformed for next 2 windows.










  • This concludes the Installation of Oracle Web Logic Server

Step5: Installing Oracle Tuxedo:

  • Save the zip file to a temporary directory on your local system, referred to in this documentation as TUX_INSTALL.. Extract the files into TUX_INSTALL.
  • First you need to designate an existing user or create a new user such as TUXADM to be the Application Server Administrator. The Application Server Administrator and not the Windows Administrator. This user will install Oracle Tuxedo. The designated user must be a local Microsoft Windows administrator and must have full system privileges. The PeopleSoft PeopleTools 8.52 program for the Oracle Tuxedo installation creates a new service for Microsoft Windows called “ORACLE ProcMGR V10gR3 with VS2008” for which you need administrator privileges. Administrator rights are required since system registry settings are updated. Once this new service is created, you must reboot to start it.
  • To designate the Application Server Administrator:

1. To add the user, add the user ID by choosing Start, Settings, Control Panel, Administrative Tools, Computer Management, Local Users and Groups.

2. Expand Local Users and Groups.

3. If the user ID does not yet exist, highlight the Users folder, and select Action, New User.

4. On the New User dialog box, specify the information for the new account. Make sure to deselect the User must change password at next logon check box.

5. Expand the Groups folder.

6. Right-click the Administrators group, and select All Tasks, Add to Group, Add.

7. Click Locations to select the local machine or the network domain in which you created the new user.

8. Enter the new user name you created in the object names box.

9. Click OK, and click Apply and OK again to accept the changes.

  • Double-click TUX_INSTALL\tuxedo10gR3_32_win_2k8_x86_VS2008.exe to begin the installation process. Click OK on the initial window.
  • Follow the steps shown in screenshots below.














  • Go to Windows –> Services


  • Instead of Administrator use the User account name which you created in the first few steps of Oracle Tuxedo Installation.


  • This concludes the installation and configuration of Oracle Tuxedo.

Next steps continued in Part 2.


Vishal Modi