Instant Peoplesoft Cloning Refresher Kit

Posted by Pon ArunKumar Ramalingam
January 28th, 2008

Here are the instant refresher steps for performing a peoplesoft clone.

  • The target system – the system to which the Peoplesoft Instance to be cloned.
  • The source system – the system from which the Peoplsoft Instance is cloned.
  • Oracle Server 9i with the patch at version 7 is installed in the target system.
  • Application and Web Server is also installed in the target system
  • The Database structure files from PSHOME from the source system is copied to the target system’s separate drive.
  • Update the domain names and coordinates in the TNS Listener files
  • Configure the application and web server domain names

Points to Ponder

  • Before initializing the activity, the very first step would be to shutdown the source database using
    • Set Oracle_SID = Domain Name, and
    • Connect Sys as Sysdba shutdown immediate
  • Shutdown the Application Server in the Source system
  • Shutdown the Web Server in the Source system
  • Access the Oracle\Oradata\Domainname and copy the *.dat files to the target system
  • Make sure all the control files, data files and redo log files are in place in the destination system
  • Execute the ‘alter database backup control file to trace’ in the source system
  • Make sure that the file is created under Udump folder as a result of the above script
  • Make the necessary changes in the file and save it as *.sql
  • Copy the parameter file names initdomainname.ora under oracle\ora92\database and edit the coordinates and parameters in order to reflect the target system’s features
  • Startup Nomount; and execute the script generated from the source system
  • Update PSDBOWNER Set DBNAME =”New Domain Name”
  • Use NET Configuration Assistant wizard to configure the listener with the parameters for TNS, Host Name, IP Address, System Name(Target System) and perform a test
  • Using the configuration assistant, test for the access of Peoplesoft Application Designer , Data Mover with the same user access credentials of the Source system database
  • Configure the Web Server by providing the domain name, Peoplesoft web site name and startPIA.exe; Make sure that the environment variables are also set for JavaHome.

Comments (0)