STEP - 0 : Privilege Admin Rights
1. D:/ ⟶ Security ⟶ Full Control
2. Copy the Peoplesoft folder to Local Disk D
STEP - 1 : Deploying Peoplesoft Application
1. Open Cmd Prompt ⟶ Run as Administrator
cd F:/Package856/858.12/package/Setup
F:
2. Press Tab
psft-dpk-setup.bat --help
psft-dpk-setup.bat --env_type midtier --deploy_only
Starting the PeopleSoft Environment Setup Process:
Validating User Arguments: [ OK ]
Validating PeopleSoft Supported Platform: [ OK ]
Verifying if Puppet Software is Installed:
Puppet Software is not installed on the Windows Host. If PeopleSoft environment needs to be setup on this
Host, Puppet software should be Installed..
Do you want to proceed with the Puppet Installation? [Y|n]: y
Installing Puppet Software on the Windows Host: [ OK ]
Verifying if eYAML Hiera Backend is Installed: [ OK ]
Enter the PeopleSoft Base Folder: D:/PT858
Are you happy with your answer? [Y|n|q]: Y
Checking if the Base Folder has Enough Free Space: [ OK ]
Validating the PeopleSoft DPKs in the Windows VM: [...]
Extracting the Peoplesoft DPK Archives in Windows VM: [...]
Setting up Puppet on the Windows VM:
Generating eYAML Hiera Backend Encryption Keys: [ OK ]
Updating the Puppet Hiera YAML Files in the Windows VM: [ OK ]
Updating the Role in Puppet Site File for the Windows VM: [ OK ]
Enter the PeopleSoft database platform [ORACLE]: ORACLE
Is the PeopleSoft database unicode? [Y|n]: y
Do you want Multi Language support in PeopleSoft database? [y|N]: Y
Are you happy with your answers? [y|n]: y
Encrypting the Passwords in the User Data: [ OK ]
Updating the Puppet Hiera YAML Files with User Data: [ OK ]
The bootstrap script is ready to deploy and configure the PeopleSoft environment using the default
configuration defined in the Puppet Hiera YAML files. You can proceed by answering 'y' at the following
prompt. And, if you want to customize the environment by overriding the default configuration, you can
answer 'n'. If you answer 'n', you should follow the instructions in the PeopleSoft Installation Guide for
creating the customization Hiera YAML file and running the Puppet 'apply' command directly to continue
with the setup of the PeopleSoft environment
Do you want to continue with the default initialization process? [y|n]: Y
Starting the Deployment of PeopleSoft Components:
Deploying Application Components: [ OK ]
Deploying PeopleTools Components: [ OK ]
The PeopleSoft Environment Setup Process Ended.
STEP - 2 : Setting Up Oracle 19C Database
1. Download Oracle 19c from the browser
2. WINDOWS.X64_193000_db_home ⟶ setup.exe
3. Set up the database
Configure Option ⟶ Set up software only
Database Installation Option ⟶ Single Instance Database Installation
Database Edition ⟶ Enterprise Edition
Oracle Home User ⟶ Create New windows User
Username : SYSADM
password : SYSADM
Confirm Password : SYSADM
Installation Location ⟶ D:/ [Note : C Drive dosn’t have much space , better to store in D drive]
Finish
4. Creating New Database
WINDOWS.X64_193000_db_home ⟶ bin ⟶ dbca
Run as Administrator
Database Operation ⟶ Create Database
Creation Mode ⟶ Advanced Configuration ⟶ Database Type: Oracle Single Instance Database
Database Identification ⟶ Untick [ Create as Container Database ]
Global Database Name : CSDEV
SID : CSDEV
Storage Option ⟶ Next
Fast Recovery Option ⟶ Untick [ Both Container ]
Network Configuration ⟶ Create New Listener
Listener Name : LISTENER
Configuration Options ⟶ Use Automatic Shared Memory Management
User Credentials ⟶ Select ⟶ Use the same administrative password for all accounts
Password : SYSADM
Confirm Password : SYSADM
Oracle Home User Password : SYSADM
Creation Option ⟶ Next
Finish
STEP - 3 : Working With Scripts
1. Open D:
2. PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ Scripts ⟶ NT
3. Copy the following Scripts
utlspace.sql
dbowner.sql
psroles.sql
psadmin.sql
connect.sql
4. ps_home8.58.12 ⟶ Create New folder ⟶ Modifiied Scripts ⟶ Paste
5. Open F: ⟶ Copy ⟶ cs_app_home858 folder
6. Paste on D: ⟶ PT858 ⟶ PT
7. Open cs_app_home858 ⟶ Scripts ⟶ NT ⟶ Copy csddl.sql
8. Paste ⟶ ps_home8.58.12 ⟶ Modifiied Scripts
9. Modified Scripts Content
utlspace.sql
dbowner.sql
psroles.sql
psadmin.sql
connect.sql
csddl.sql NEW
STEP - 4 : Modifying Scripts
1. Open utlspace.sql
TEMPFILE '<drive>:\oradata\<SID>\pstemp01.dbf' SIZE 900M [Change the path of the database]
path : D:\app\SYSADM\oradata\CSDEV
TEMPFILE 'D:\app\SYSADM\oradata\CSDEV\pstemp01.dbf' SIZE 900M NEW
DATAFILE '<drive>:\oradata\<SID>\psdefault.dbf' SIZE 100M [Change the path of the database]
path : D:\app\SYSADM\oradata\CSDEV
DATAFILE 'D:\app\SYSADM\oradata\CSDEV\psdefault.dbf' SIZE 100M NEW
2. Open csddl.sql
CREATE TABLESPACE AAAPP DATAFILE '<drive>:\oradata\<SID>\aaapp.dbf' SIZE 18M
[Change the path of the database] path : D:\app\SYSADM\oradata\CSDEV
CREATE TABLESPACE AAAPP DATAFILE ''D:\app\SYSADM\oradata\CSDEV\aaapp.dbf' SIZE 18M NEW
[ Replace the path to all the lines ⟶ Use Ctrl + H to replace the path at once for all lines ]
REMOVE REMARK from all the lines ----- except [ 1st & Last line ]
REMARK Users can choose to use the autoextending tablespace feature [ 1st line ]
ALTER DATABASE DATAFILE '<drive>:\oradata\<SID>\aaapp.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
.
.
.
.
.
.
REMARK ALTER DATABASE TEMPFILE '<drive>:\oradata\<SID>\psgtt01.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE
UNLIMITED; [ last line ]
3. Open dbowner.sql
CONNECT system/&SYSTEMPWD; [ Change the SYSTEMPWD as SYSADM (DB password) ]
CONNECT system/SYSADM; NEW
4. Open psroles.sql
[ NO CHANGE ]
5. Open psadmin.sql
CONNECT system/&SYSTEMPWD; [ Change the SYSTEMPWD as SYSADM (DB password) ]
CONNECT system/SYSADM; NEW
6. Open connect.sql
[ NO CHANGE ]
STEP - 5 : Running Scripts
1. Open CMD prompt ⟶ Run as Administrator
2. Run the following Command
C:\WINDOWS\system32> SET ORACLE_SID =CSDEV
C:\WINDOWS\system32> cd D:\PT858\pt\ps_home8.58.12\modified_script
C:\WINDOWS\system32> d:
D:\PT858\pt\ps_home8.58.12\modified_script > SQLPLUS SYS/SYSADM AS SYSDBA
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 22 17:57:57 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[NOTE : Run the following script in the following order]
SQL> @utlspace.sql [SUCCESSFULLY COMPLETED – spool off]
SQL> @csddl.sql [SUCCESSFULLY COMPLETED – spool off]
SQL> @dbowner.sql
PROMPT Enter PeopleSoft PSDBOWNER Owner ID password: SYSADM
PROMPT Enter System user password: SYSADM
[SUCCESSFULLY COMPLETED – spool off]
SQL> @psroles.sql [SUCCESSFULLY COMPLETED – spool off]
SQL> @psadmin.sql
PROMPT 'Enter name of PeopleSoft Owner ID(max. 8 characters): SYSADM
PROMPT 'Enter PeopleSoft Owner ID password: SYSADM
ACCEPT TSPACE CHAR PROMPT 'Enter desired default tablespace: PSDEFAULT [Default Name]
PROMPT 'Enter System user password: PSDEFAULT [Default Password]
SQL> EXIT; [Before Running Connect.sql script exit the current sql ]
[ Again Run the SQL cmd ]
D:\PT858\pt\ps_home8.58.12\modified_script > SQLPLUS SYS/SYSADM AS SYSDBA
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 22 17:57:57 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> @connect.sql
PROMPT 'Enter name of PeopleSoft Connect ID(max. 8 characters): people
PROMPT 'Enter PeopleSoft Connect ID password: peop1e [ NOTE; p-e-o-p-1-e ]
[SUCCESSFULLY COMPLETED – spool off]
STEP - 6 : pscfg Configuration
1. Open PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ bin ⟶ pscfg.exe
2. Run as Administrator
3. Enter the required field
4. Edit Startup
5. Edit Profile Section
[ NOTE : If Edit option is not shown allow full control in security for the folder and restart the system ]
6. Click on Edit
Database stored ⟶ set ⟶ Apply
7. Edit Process Scheduler
Enter the following paths to the required field
***[ Note : If some paths not available create an empty folder with the name mentioned on the paths]***
8. Edit Client Setup section
Click Install workstation and click Apply & Ok
STEP - 7 : psdmt Configuration [datamover]
1. Open PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ bin ⟶ psdmt.exe
2. Run as Administrator
3. Enter the Required filed
USER ID : PS
PASSWORD : ps
Click ⟶ File
Open Database Setup
Select ⟶ Oracle ⟶ Unicode ⟶ AL32UTF8 ⟶ Next
Search for English Language
4. If English Language doesn’t exist, Follow these steps
Open CMD propmt ⟶ Run as Administrator
C:\WINDOWS\system32> SET ORACLE_SID =CSDEV
C:\WINDOWS\system32> SQLPLUS SYS/SYSADM AS SYSDBA
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 23 11:29:21 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH; [RUN]
SQL> SHUTDOWN IMMEDIATE; [RUN]
SQL> STARTUP; [RUN]
[ Now the English Language is available in the datamover ]
Select English ⟶ Add ⟶ Next
5. Enter the required parameter
6. Execute the script & complete the Datamover part
Click ⟶ Run Script
Successful Completion will shown once the process is done.
[ NOTE : if the script is unsuccessful ⟶ Type SET IGNORE_DUPS; after the lines which ends with .log ]
[ NOTE : Don’t close the Datamover if its says not responding while running the scripts ]
STEP - 8 : Application Server Configuration
1. Open ⟶ PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ appserv ⟶ psadmin.exe
2. Run as Administrator
3. Follow These Steps
Choose Application Server
Create a New Domain
Enter the name of the domain to create [DATABASE NAME]
Complete the required Field
JOLT : Yes [ Other parameter should be ‘No’]
DBNAME : CSDEV
USERID : PS
USERPWD : ps
ADD TO PATH : Oracle installtion folder ‘Bin’ path
CONNECT ID : people
CONNECT PSWD : peop1e
JSL port : 9008 [ Default port no : 9000 ⟶ Change it to 9008 ]
Select Load configuration to execute [14]
4. Once Completed choose ⟶ Boot Domain [1] ⟶ Boot [1] ⟶ Exit
5. Finish
STEP - 9 : Web Server Configuration
1. Open ⟶ PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ appserv ⟶ psadmin.exe
2. Run as Administrator
3. Follow These Steps
Choose Web (PIA) Server
Create a New Domain
Enter the name of the domain to create [DATABASE NAME]
Complete the required Field ⟶ Choose ‘C’ to execute
DOMAIN NAME : CSDEV
WEB SERVER ROOT DIRECTORY : D:\PT858\PT\bea [bea path]
WEB SERVER LOGIN ID : system
WEB SERVER PASSWORD : Passw0rd
WEBSITE NAME : ps
JSL PORT : 9008
HTTP PORT : 81 [ Default port no : 80 ⟶ Change it to 81 ]
WEB PROFILE USER ID : PTWEBSERVER
WEB PROFILE PASSWORD : PTWEBSERVER
INTEGRATION GATEWAY ID : administrator
INTEGRATION GATEWAY PASSWORD : password
4. Once Completed choose ⟶ Boot Domain [1] ⟶ Boot [1] ⟶ Exit
5. Finish
STEP - 10 : Process Scheduler Configuration
1. Open ⟶ PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ appserv ⟶ psadmin.exe
2. Run as Administrator
3. Follow These Steps
Choose Process Scheduler
Create a New Domain ⟶ Enter the name of the domain to create [DATABASE NAME]
4. Enter the required user id and password to complete execution
5. Once Completed choose ⟶ Boot Domain [1] ⟶ Boot [1] ⟶ Exit
6. Finish
STEP - 11 : PeopleSoft Application
0. Open ⟶ PT858 ⟶ pt ⟶ ps_home8.58.12 ⟶ appserv ⟶ psadmin.exe ⟶ Boot ⟶ Web Server
1. Open Browser
2. Enter ⟶ localhost:http_port [ localhost:81 ]
3. Enter the Required Field
4. Start Working With PeopleSoft Applications
