AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.
Cloning a PeopleSoft 7.5 Oracle database (making a copy of production DB and renaming to a testing DB) is one of the routine jobs. We are currently upgrading our PeopleSoft 7.52 applications to Peoplesoft 8.8. I've set up the 8.8 demo databases and PIA. I believe that cloning a PeopleSoft 8.8 Oracle database will be more complicated than that of 7.5, which only involving table PSDBOWNER if there is no needs for changes in security.
It will be greatly appreciated that you can kindly provide me with some guideline regarding to the extra steps required in cloning an 8.8 DB.
Best Regards
Wenjia Zhang
Answer Hi Wenjia,
Cloning the 8.8 database still follows the procedure for a 7.5 database. That does not change.
You will have to setup th PIA using the old userid and password. You will have to change the report manager settings and integration broker (if you are using them - if you are not, you can leave them alone until when it is needed; then you need to change it to reflect the cloned database name).
Once you have connected via the PIA, you may wish to change the userid and/or password to prevent someone to accidentally log in to this database.
