Project and Portfolio Management Practitioners Forum
cancel

Deploying SQL to Oracle RAC databases

Highlighted
Scott A. Wood
Trusted Contributor.

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
Valued Contributor.

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