The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Deploying SQL to Oracle RAC databases

Highlighted
Scott A. Wood
Super Collector

Deploying SQL to Oracle RAC databases

We use PPM to deploy code/SQL. We now have to need to deploy to some Oracle RAC databases with multiple servers. Has anyone else done this? How should the environment be setup in PPM to reflect the multiple servers?

Thanks,

Scott
1 REPLY
frank chiang
Super Collector

Re: Deploying SQL to Oracle RAC databases

Scott,

One PPM environment per node, destinate one of the environment as primary. In workflow, have logic to only deploy to the primary environment if the object type is SQL or any object types that need to deploy to the database only once.

Hope this helps,

Frank

//Add this to "OnDomLoad" event