Project and Portfolio Management Practitioners Forum
cancel

syncronisation PPM Development DB Instance with PPM UAT DB Instance

Highlighted
Saw Teong Soon
New Member.

syncronisation PPM Development DB Instance with PPM UAT DB Instance

Hi Folks,

I am trying to restore Oracle DB from Development machine to UAT machine, Upon completion of restoring the Development DB into UAT DB, I found out that, all the PL/SQL packages contain errors? I try to recompile the entire errors PL/SQL but still failed.

Is there something that need to be recompile in sequence during restoring? Please refer to attachment for the screen shot
1 REPLY
Volker Schoettn
Honored Contributor.

Re: syncronisation PPM Development DB Instance with PPM UAT DB Instance

Hi,

check out the SysAdmin Guide (Chapter 9 - Migrating Instances).
There is a way how to clone databases.
There is a script RecompileInvalid.sql somewhere in the PPM_HOME dir. Try this as ppm database user.
If it didn't work try the way descript in chapter 9 of SysAdmin Guide. I have done a lot of database copies in this way. I has worked every time.

Regards
Volker