Wednesday, March 16, 2011

RAC One Changes in 11.2.0.2 Patchset

Oracle patchsets used to be simple - they were bugfixes only; no additional functionalities were added. Oracle added stuff quietly in 10.2.0.4 patchset (the workload capture); but that was part of a new functionality anyway.


The 11.2.0.2 patchset changed all the rules. Several new functionalities were added to the patchsets. Several functionalities have been added to RACOne. Unfortunately they didn't make it to the manuals. Some of them I discovered only recently. If you have been using RACOne, or considering it, you will be delighted to know these.


(1) Bye Bye Patch - In 11.2.0.1 RACOne was supported; but you had to apply a patch 9004119 . Well, it was confusing at the best. A favorite interview question on RACOne fo rmany way this patch. It's gone; 11.2.0.2 already has the patch.


(2) OMotion - remember the OMotion tool used for relocating the database instance? It was probably modeled after the functionality of VMotion in VMWare; hence the namesake. However, it was completely redundant. The clusterware has the functionality anyway; and RACOne has the clusterware; so I never understood the need for OMotion.


In 11.2.0.2, it's gone. To relocate database instance from one server to another, you simply issue srvctl relocate command.


$ srvctl relocate database -d DBNAME -n


(3) Creation - no need to create the RACOne using raconeinit script. DBCA can create it. Oracle Installer can install RACOne as well.


(4) Status - Earlier you had to use raconestatus command to know the status of the RACOne database. This is no longer needed. You can use srvctl status or crsctl status commands.


(5) Upgrades - upgrading RACOne? DB Ugrade Assistant is aware of RACOne as well.


(6) Conversion - Converting a database to RACOne? SRVCTL comes to rescue:


$ srvctl convert database -d ....


(7) Data Guard will work on RACOne as well.

6 comments:

Anonymous said...

Hi Arup,
thank you for bringing this to the attention of the Oracle Community! Generally, it seems to me that the whole RAC One area is somewhat under-represented in terms of Blog postings :-)

keyur said...

Arup,

That's a very neat, though precious information. Excellent. Thanks.
-Keyur Patel

Gilles said...

Excellent !
And very useful.
Thank you Arup.

Anonymous said...

Hi Arup,
Thanks for providing the clear info about using raconeinit on v11.2.0.2.
-Paul

Ernesto said...

Thanks Arup for the post.
Unfortunately, as usual, Oracle forgot to update the EM Grid. The EM Grid does not manage correctly the RAC One database.

John Cornor said...

That is some inspirational stuff. Never knew that opinions could be this varied. Thanks for all the enthusiasm to offer such helpful information here.

Translate