Ask the Expert

Performing a patchset application in a RAC environment

I currently have several applications on their own databases. Is it possible to consolidate all these databases and thus applications on a single database with a RAC environment? I don't see any advantages if I shut down my databases; all my applications are then not available. Does performing a patchset involve shutting down the database in a RAC environment?

    Requires Free Membership to View

Real Application Clusters, for the most part, does not care if you have one application or two stored in a database. Just store the application data in separate schemas. One working theory is to have one application's users connect to NodeA, another application's users connect to NodeB, and so on. In case of a failure of a node, the application users fail over to another node in the grid.

With Oracle 10g, you can perform the patchset application in a rolling upgrade fashion. Check the patchset documention for more information.

This was first published in December 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: