11. Upgrade the second Database to Oracle RAC
Upgrading from Oracle RAC One Node to Oracle RAC is as simple as
executing the racone2rac script and using DBCA to add additional instances.
11.1 Execute racone2rac script
We will run racone2rac to convert racdb to Oracle RAC. During the
conversion operation, the racdb_1 database instance is shutdown and brought
back up with a new name called racdb1. In 18.104.22.168, the conversion operation
will not offline the database.
Candidate Databases on this cluster:
# Database RACOne Node Fix Required
=== ======== ============= ============
 appsdb YES N
 racdb YES N
Enter the database to convert to one node RAC database : 2
You are converting racdb to single instance Oracle RAC database running on gurnard2 .
Do you want to Continue? [Y]es or [N]o? Y
Please wait, this may take a few minutes to finish.........
Database configuration modified.
Run dbca to add as many instances as you want to this database.
11.2 Execute DBCA to add an additional instance (racdb2)
As the oracle user on gurnard2, execute
Welcome: Select Oracle Real
Application Clusters database.
Operations: Select Instance
Instance Management: Select Add
List of cluster database: Select racdb.
List of cluster database instances:
Click on Next.
Instance naming and node
selection: Accept the default instance name, racdb2.
Instance Storage: Click on Finish.
Summary: Click on OK.
oracle@gurnard1-> srvctl status database -d appsdb
Instance appsdb_1 is running on node gurnard1
oracle@gurnard1-> srvctl status database -d racdb
Instance racdb2 is running on node gurnard1
Instance racdb1 is running on node gurnard2
Oracle RAC One Node is easy to install, administer and manage. IT
organizations eager to embrace the benefits of Oracle RAC One Node can easily
implement the solution at a cost advantage over the Oracle RAC option. When the
database is ready to scale out to more than one node, Oracle RAC One Node can
be upgraded to a full Oracle RAC database within minutes.
For more information about Oracle RAC One Node, please refer to Oracle
RAC One Node: Better Virtualization for Databases.
Vincent Chan (firstname.lastname@example.org)
is a Senior Computer Systems Architect at Lockheed Martin Corporation. He is an
Oracle Certified Master DBA with more than 14 years of experience architecting
and implementing Oracle solutions for various clients.