Peoplesoft Installation 8.53 Major Steps

Peoplesoft Installation 8.53 Steps:
First we need to check the certification details for the peoplesoft peopletools, application, jdk, tuxedo and weblogic version with the hardware and operating system version. This details can be obtained from support.oracle.com
We are going to Install with the certification for peoplesoft 8.53 on Windows 7 and database as Oracle 11g Release 2.

1. Install the softwares one by one in the order mentioned for peoplesoft 8.53:
2. Install the Oracle Database 11g R2 (64-bit)
3. Install JDK for Windows 7 64-bit
4. Install Tuxedo 11g V2010 Windows 64-bit
5. Install WebLogic Server 10.3.6.0 in 64-bit mode
6. Install PeopleTools 8.53 (Disk1, Disk2 and Disk3)
7. Install PeopleSoft HCM 9.2 (Disk1)

Creating PeopleSoft Oracle Database:

1. Create the Oracle Database using Database Configuration Assistant (DBCA). Once created the Oracle database it is blank we need to run six SQL Scripts to create peoplesoft objects like records, temporary records, users, etc
2. Run UTLSPACE.SQL – This will create Catalog Views and Utility tablespaces like PSDEFAULT and PSTEMP
3. Run HCDDL.SQL – This will create Application related tablespaces. Make sure you have disk space on the oradata or where the data files will be created.
4. Run DBOWNER.SQL – This will create PS.PSDBOWNER table where it holds two columns Database Name, OwnerId. This table exists in Oracle only not when you create a database in SQL Server.
5. Run PSROLES.SQL – This will create PeopleSoft related database roles.
6. Run PSADMIN.SQL – This will create PeopleSoft database Owner ID (By default we give SYSADM)
7. Run CONNECT.SQL – This will create Connect ID (people) which is used in the initial connection to connect to the peoplesoft database.
8. Configure the PeopleSoft Configuration Manager. Set the Database Name, Type, Connect ID, Password, etc.
9. Now we can run the Database Setup using Data Mover to run the Import database Script which uses the (.db files) to create the peoplesoft database which can be a Demo, System or Peopletools database based on the selection.
10. Now, the Import Script will take some time to create peopesoft records, temporary records, views, etc.

Once the peoplesoft database is created with the import script, we need to check the PSSTATUS table for the version specified in the toolsversion column. If the version is the same as 8.53 it means we had the updated peopletools objects and system data. So, we can proceed to run the final scripts and complete the process.

Run VERSION AE program - It udates the PSVERSION table for the version.
Run DDDAUDIT.SQR - This will show the inconsistencies if any in the newly created database.
Run SYSAUDIT.SQR - This will show the orpahed objects if any there in the database.
Run SETSPACE.SQR – This SQR will synchronize the tablespace details with the system catalog.
Run ALTERAUDIT – This will synchronize the peopletools tables with the underlying SQL data tables.

Peoplesoft Create Domains

• We had few videos on how to create Application Server and Web Server Domains at this blog. Please refer to that.
• Boot the Domains Web Server, Application Server, Process Scheduler (After configure Report Nodes).
• Login to PIA (URL - http://servername:http_port/sitename/signon.html
  

Done.