Q

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? Does performing a patchset involve shutting down the database 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?

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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close