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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.