Convert 10g Database to RAC using Rconfig

3.8 Convert 10g Database to RAC using Rconfig

1. As the oracle user, navigate to the directory $ORACLE_HOME/assistants/ rconfig/sampleXMLs, and open the ConvertToRAC.xm lfile using a text editor such as vi.
2. Review the ConvertToRAC.xml file, and modify the parameters as required for your system. The XML sample file in Appendix B contains comment lines that explain how to configure the file for your own, site-specific requirements.

   NOTE	Before carrying out the conversion to RAC, it is advisable to test the proposed settings by running Rconfig with the option Convert verify="ONLY". This will validate the parameters, and flag any incorrect settings or other issues that need to be resolved before conversion takes place.

   
   
3. When you have finished making changes, save the file as

NOTE	Specify the 'SourceDBHome' variable in ConvertToRAC.xml as the non-RAC Oracle home (e.g. $OLD_ORACLE_HOME path). If you wish to specify a new ORACLE_HOME, start the database from the new Oracle home using the command: SQL>startup pfile=/dbs/init.ora;

4. Shut down the database instance.
5. Create the spfile from pfile using:
   SQL>create spfile from pfile;
6. Move the $ORACLE_HOME/dbs/spfile.ora for this instance to shared location
7. Take a backup of existing $ORACLE_HOME/dbs/init.ora and create a new $ORACLE_HOME/dbs/init.ora with following parameter :
   spfile='/spfile.ora'
8. Start up the instance
9. Using NetCA, create local and remote listener tns aliases for database instances. Use listener_ as the alias name for the local listener, and listeners_ for the remote listener alias:
   1. Execute netca from $ORACLE_HOME/bin.
   2. Choose "Cluster Configuration " option in the NetCA wizard.
   3. Choose the current nodename from the nodes list.
   4. Choose "Local Net Service Name Configuration " option, and click Next.
   5. Select "Add" and in next screen enter the service name, and click Next.
   6. Enter the current node as the Server Name, and specify the port defined in Step 3.3.
   7. Select "Do not perform Test", and click Next.
   8. Enter the listener TNS alias name (such as LISTENER_) for the local listener.
   9. Repeat the above steps for the remote listener, this time with the server name in step 6 as the secondary node, and the listener name LISTENERS_.

   NOTE	Ensure that local and remote aliases are created on all nodes in the cluster.

10. Navigate to $ORACLE_HOME/bin, and use the following command to run the Rconfig command:
    ./rconfig < path to rconfig xml file created in step2 >. 
11. This Rconfig execution will:
    • If ASM is specified as storage option in the XML configuration file above, migrate the database to ASM storage.
    • Create database instances on all nodes in the cluster.
    • Configure Listener and NetService entries.
    • Configure and register CRS resources.
    • Start the instances on all nodes in the cluster.

---

3.9 Carry Out Post-RAC Migration Steps

1. Back out archivelog mode changes implemented by Rconfig (conditional). Rconfig will put the database into archive log mode. If you do not want the database to be in archive log mode, you can disable it using the following steps:
   
   1. Shut down the instances all on database nodes.
   2. Set cluster_database=false in the $ORACLE_HOME/dbs/init.ora file from any one node.
   3. Start up the instance using "Startup mount" option.
   4. Disable the archive logging using Alter database noarchivelog;
   5. Shut down the database.
   6. Set cluster_database=true in the $ORACLE_HOME/dbs/ini.ora file.
   7. Start up all the instances.
   8. Check the archive log setting using the command "archive log list".
2. Remove the Listener configuration generated by Rconfig using NetCA (Conditional)If the existing single instance Net Listener was not reused during the Rconfig conversion, or is named something other than LISTENER_, remove the Listener configuration generated by Rconfig using NetCA, then verify that the listener was removed from CRS by issuing the crs_stat command from a session set to the CRS_ORACLE_HOME location.
3. Shut down the ListenersUsing the command "srvctl stop listener -n ", shut down the listeners with the name LISTENER_. These were created in Step 3.3 using srvctl login as the owner of the CRS_ORACLE_HOME.

NOTE	Review the Initialization Parameter Document 216205.1 , and update your spfile to include any RAC specific settings .