Okay,
In order to test RAC One Node, on my Oracle VM Laptop, I just:
- installed Oracle VM 2.2
- Created two OEL 5.3 images
The two images are fully prepared for Oracle 11gr2 Grid Infrastructure and 11gr2 RAC including four shared disks for ASM and private nics.
After installation of the Oracle 11gr2 Grid Infrastructure and a "software only installation" of 11gr2 RAC, I installed patch 9004119 as you can see with the opatch lsinv output:
This patch has the scripts required to administer RAC One Node, you will see them later.
At the moment we have them available for Linux and Solaris.
After installation of the patch, I created a RAC database with an instance on one node.
Please note that the "Global Database Name" has to be the same as the SID prefix and should be less then or equal to 8 characters:
When the database creation is done, first I create a service. This is because RAC One Node needs to be "initialized" each time you add a service:
The service configuration details are:
After creating the service, a script called raconeinit needs to run from $RDBMS_HOME/bin. This is a script supplied by the patch. I can imagine the next major patch set of 11gr2 has this scripts available by default. The script will configure the database to run on other nodes:
After initialization, when you would run raconeinit again, you would see:
So, now the configuration is ready and we are ready to run 'Omotion' and move the service around from one node to the other (yes, vm competitor: this is service is available during the migration, nice right ?) .
Omotion is started by running Omotion. With Omotion -v you get verbose output:
So, during the migration you will see the two instance active:
And, after the migration, there is only one instance left on the new node:
