PeopleSoft Environment Refresh process Oracle Database

Refresh process for a PeopleSoft environment running on Oracle Database

1. Clone the database from Source Database to Target Database(e.g. refresh Test environments from Production database if you are refreshing Test from Prod using RMAN or Cold backup/refresh procedures) 
   
   
2. In target complete following :

          Update database name in PSDBOWNER as that of target environment.

1.  Login to  Data Mover in bootstrap mode. Execute following scripts
   1. Reset SYSADM PWD

update PSACCESSPRFL set ACCESSID = 'SYSADM' , ACCESSPSWD = 'SYSADMPWD' , ENCRYPTED = 0 where SYMBOLICID = 'SYSADM1';

ENCRYPT_PASSWORD *;

If required, also reset sysadm password at database level and than run above scripts.

ii) Reset pwd for PS/VP1 and PTWEBSERVER

update PSOPRDEFN set OPERPSWD = 'PTWEBSERVER' , ENCRYPTED = 0 where OPRID = 'PTWEBSERVER';

Update PSOPRDEFN set OPERPSWD = 'vp1pwd' , ENCRYPTED = 0 where OPRID = 'VP1';

ENCRYPT_PASSWORD *;

1. You should be able to connect using Datamover and App designer with Application user(PS/VP1)
   
   
2. Edit, and run the CONNECT.SQL and GRANT.SQL scripts (Not required normally)
3. Clear GUID in the PSOPTIONS table, This will get regenerated when the new Application  Server Domain is started.
4.  Create new Application Server Domain (delete old one) (Not mandatory in normal refresh)
5. Create new PIA (delete old one) (Not mandatory in normal refresh)
6.  Update the Report Node definitions as per target environment.
7.  Clear Process tables with PRCSCLR.DMS from datamover
8.  Clear content tables with RPTCLR.DMS from datamover
9.  Create new Process Scheduler domain (delete old one)
10. Check the web profiles values if you have customized the web profiles.
11. Setup/Reconfigure  Integration broker , Default Gateway by updating correct URLs in Listening connectors and App server details as per target environment.
12. Setup Domains from PIA to reflect new app server details.(use Domain Status link)
13. Setup/Reconfigure any  IB nodes or Gateways to point to correct locations.
14. Run test processes to validate process scheduler and do a sanity check for Environment.
    
    

If you are refreshing an existing environment, please take an export of important tables before database refresh and import those tables back after database refresh.

 

Also take an export of any custom tables or information like user emails etc based on your setup and import it back after refresh.

 

For IB,Report nodes, process schedulers, take an export before refresh to preserve existing tables and config.

 

Copy files from batch server e.g. cobols,sqrs,crystal reports etc to new Ps_Home