Steps Involved in PeopleSoft Installation | PeopleSoft Tutorial

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 webserver

            startserver server1 / START PIA

 15. start the mpinternet from <PS_HOME>\setup\mpinternet

 Set following parameter 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 :

             the url is : http://localhost:9090/admin/

            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

Prashant
 

>