{"id":7879,"date":"2019-12-03T13:39:51","date_gmt":"2019-12-03T13:39:51","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/convert-a-standalone-database-to-oracle-rac-by-using-rconfig\/"},"modified":"2026-11-03T19:29:07","modified_gmt":"2026-11-03T19:29:07","slug":"convert-a-standalone-database-to-oracle-rac-by-using-rconfig","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/de\/blogs\/convert-a-standalone-database-to-oracle-rac-by-using-rconfig\/","title":{"rendered":"Convert a standalone database to Oracle RAC by using rconfig"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>Have you ever wondered how to convert a standalone database to an Oracle\u00ae;&nbsp;Real Application Clusters (RAC) database?<\/p>\n<p>You can use <em>rconfig,<\/em>&nbsp;a non-interactive command-line utility, to convert asingle-instance database to a RAC database. The utility reads the values provided under the <strong>ConvertToRAC.xml<\/strong> file.<\/p>\n<p>The <strong>$ORACLE_HOME\/assistants\/rconfig\/sampleXMLs<\/strong>&nbsp;directory has two templates,&nbsp;<strong>ConvertToRAC\\_AdminManaged.xml<\/strong>&nbsp;and <strong>ConvertToRAC\\_PolicyManaged.xml&nbsp;<\/strong>which you can use to convert a single-instance database to RAC admin or&nbsp;policy-managed database, respectively. This blog explores the &nbsp;admin-managed RAC&nbsp;conversion, although the same approach applies to a policy-managed<br \/>\ndatabase.<\/p>\n<p>The following image shows a sample <strong>ConvertToRAC_AdminManaged.xml<\/strong> file::<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26539-body-Picture1_35.png\" alt=\"oracle rac pic 1\" \/><\/p>\n<p><strong>Prerequisites for using rconfig&nbsp;<\/strong><\/p>\n<p>Before you use <em>rconfig<\/em>, consider the following prerequisites::<\/p>\n<ul>\n<li>&nbsp; &nbsp;Use Oracle Database version 10g R2 or later.<\/li>\n<li>&nbsp; &nbsp;Configure Clusterware and have it running on all the nodes.<\/li>\n<li>&nbsp; &nbsp;Install Oracle RAC RDBMS on all the nodes.<\/li>\n<li>&nbsp; &nbsp;Make sure that shared storage, either Oracle Cluster File System or Automatic<\/li>\n<li>&nbsp; Storage Management (ASM), is available and accessible from all the nodes.<\/li>\n<li>&nbsp; &nbsp;Verify that the standalone database and RAC are the same database version.<\/li>\n<li>&nbsp; &nbsp;You need an active ASM instance across the nodes and the database running on&nbsp;one of the local nodes.<\/li>\n<\/ul>\n<p><strong>Steps for conversion to RAC&nbsp;<\/strong><\/p>\n<p>Use the following steps to convert your standalone database to RAC.<\/p>\n<p><strong>Step 1: &nbsp;Set the parameters<\/strong><\/p>\n<p>You need to set the following parameters in <strong>ConvertToRAC_AdminManaged.xml<\/strong>:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26539-body-Picture2_22.png\" alt=\"Oracle rac pic 2\" \/><\/p>\n<p>The `convert verify` option in <strong>ConvertToRAC.xml<\/strong> has three options:<\/p>\n<p>&#8211;&nbsp; &nbsp; <strong>Convert verify=&#8221;YES<\/strong>: <em>rconfig<\/em>&nbsp;performs prerequisite checks followed by&nbsp;RAC conversion.<br \/>\n&#8211;&nbsp; &nbsp; <strong>Convert verify=&#8221;NO<\/strong>: <em>rconfig<\/em>&nbsp;performs RAC conversion without the&nbsp;prerequisite checks.<br \/>\n&#8211;&nbsp; &nbsp; <strong>Convert verify<\/strong>=<strong>O<\/strong><strong>NLY:&nbsp;<\/strong>`<em>rconfig<\/em>` performs only the prerequisite checks and&nbsp;takes no other action<\/p>\n<p><strong>Step 2: Perform the prerequisite checks.<\/strong><\/p>\n<p>Run the following command to run the `convert_verify=&#8221;ONLY\u201d` option to fix any<br \/>\nerrors:<\/p>\n<p><em>&nbsp; &nbsp; $ cd $ORACLE_HOME\/assistants\/rconfig\/sampleXMLs<br \/>\n&nbsp; &nbsp; $ $ORACLE_HOME\/bin\/rconfig ConvertToRAC_racdb.xml<\/em><\/p>\n<p><strong>Example:<\/strong><\/p>\n<p>&nbsp; [oracle@racnode1 sampleXMLs]$ rconfig ConvertToRAC_racdb.xml<br \/>\n&nbsp; &nbsp; &lt;?xml version=&#8221;1.0&#8243; ?&gt;<br \/>\n&nbsp; &nbsp; &lt;RConfig version=&#8221;1.1&#8243; &gt;<br \/>\n&nbsp; &nbsp; &nbsp; &lt;ConvertToRAC&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &lt;Convert&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Response&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result code=&#8221;0&#8243; &gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Operation Succeeded<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Result&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Response&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ReturnValue type=&#8221;object&#8221;&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There is no return value for this step<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/ReturnValue&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Convert&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &lt;\/ConvertToRAC&gt;<br \/>\n&nbsp; &nbsp; &lt;\/RConfig&gt;<br \/>\n<strong>Execute rconfig for RAC conversion<\/strong><\/p>\n<p>When you run the following commands to execute <em>`rconfig`<\/em> to convert the&nbsp;database, make sure you update the parameter to <em>`convert_verify=&#8221;YES&#8221;`<\/em>.<br \/>\n<em>`rconfig`<\/em> performs the conversion and the verification.<\/p>\n<p><em>&nbsp; &nbsp; $ cd $ORACLE_HOME\/assistants\/rconfig\/sampleXMLs<br \/>\n&nbsp; &nbsp; $ $ORACLE_HOME\/bin\/rconfig ConvertToRAC_racdb.xml<\/em><\/p>\n<p>Run the following command to monitor alerts in the <em>`rconfig`<\/em> log on the&nbsp;standalone database and the new RAC database:<\/p>\n<p><em>&nbsp; &nbsp; $ tail -f \/ora\/app\/oracle\/cfgtoollogs\/rconfig\/rconfig*.log<\/em><\/p>\n<p><em>Example:<\/em><\/p>\n<p><em>&nbsp; &nbsp; [oracle@racnode1 sampleXMLs]$ rconfig ConvertToRAC_racdb.xml<br \/>\n&nbsp; &nbsp; Converting Database &#8220;SOATEMP&#8221; to Cluster Database.<br \/>\n&nbsp; &nbsp; Target Oracle Home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1. Database Role: PRIMARY.<br \/>\n&nbsp; &nbsp; Setting Data Files and Control Files<br \/>\n&nbsp; &nbsp; Adding Database Instances<br \/>\n&nbsp; &nbsp; Adding Redo Logs<br \/>\n&nbsp; &nbsp; Enabling threads for all Database Instances<br \/>\n&nbsp; &nbsp; Setting TEMP tablespace<br \/>\n&nbsp; &nbsp; Adding UNDO tablespaces<br \/>\n&nbsp; &nbsp; Adding Trace files<br \/>\n&nbsp; &nbsp; Setting Fast Recovery Area<br \/>\n&nbsp; &nbsp; Updating Oratab<br \/>\n&nbsp; &nbsp; Creating Password file(s)<br \/>\n&nbsp; &nbsp; Configuring Listeners<br \/>\n&nbsp; &nbsp; Configuring related CRS resources<br \/>\n&nbsp; &nbsp; Starting Cluster Database<br \/>\n&nbsp; &nbsp; &lt;?xml version=&#8221;1.0&#8243; ?&gt;<br \/>\n&nbsp; &nbsp; &lt;RConfig version=&#8221;1.1&#8243; &gt;<br \/>\n&nbsp; &nbsp; &nbsp; &lt;ConvertToRAC&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &lt;Convert&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Response&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result code=&#8221;0&#8243; &gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Operation Succeeded<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Result&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Response&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ReturnValue type=&#8221;object&#8221;&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Oracle_Home&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Oracle_Home&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Database type=&#8221;ADMIN_MANAGED&#8221; &nbsp;&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;InstanceList&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Instance SID=&#8221;RACDB1&#8243; Node=&#8221;racnode1&#8243; &nbsp;&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Instance&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Instance SID=&#8221;RACDB2&#8243; Node=&#8221;racnode2&#8243; &nbsp;&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Instance&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/InstanceList&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Database&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;\/ReturnValue&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &lt;\/Convert&gt;<br \/>\n&nbsp; &nbsp; &nbsp; &lt;\/ConvertToRAC&gt;<br \/>\n&nbsp; &nbsp; &lt;\/RConfig&gt;<\/em><br \/>\n&nbsp;<\/p>\n<p><strong>Step 4: Verify the conversion<\/strong><\/p>\n<p>Run the following commands to verify the log, check the RAC database status,&nbsp;and check the datafile status.<\/p>\n<p><strong>Note:<\/strong> If the standalone database was non-ASM, it is now ASM.<\/p>\n<p><em>&nbsp; &nbsp; $ srvctl status database -d racdb<br \/>\n&nbsp; &nbsp; Check by login to sqlplus<br \/>\n&nbsp; &nbsp; SQLPLUS&gt; select * from gv$instance;<br \/>\n&nbsp; &nbsp; SQLPLUS&gt; select file_name from dba_data_files;<\/em><\/p>\n<p><strong>Step 5: Modify tnsentry<\/strong><\/p>\n<p>Modify<em> `tnsentry`<\/em> on the local node with <em>`scan-name<\/em>` and copy it to all other nodes<\/p>\n<p><strong>&nbsp;Conclusion<\/strong><\/p>\n<p>`<em>rconfig<\/em>` performs automated RAC conversions and saves the time and effort of&nbsp;the multiple manual configuration steps. It also takes an <em>RMAN<\/em>&nbsp;backup in case&nbsp;a non-ASM to ASM conversion is required, which might increase the downtime for&nbsp;large databases. You can tune this by allocating multiple I\/O channels for the&nbsp;backup. If the standalone and target RAC database are on ASM, you can use&nbsp;rconfig as a quick solution for the RAC conversion.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Convert a standalone database to Oracle RAC by using rconfig<\/p>\n","protected":false},"author":2,"featured_media":7881,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26539","content_type":"blog","created_by":"10130","authored_on":"2024-01-23T13:39:51+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Vikrant Anand, Oracle Database Administrator, Rackspace Technology","seo_description":"A comprehensive guide to convert standalone databases to Oracle RAC using rconfig, emphasizing its process, usage, and potential outcomes.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26539-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2019-12-03T13:39:51","rxt_solutions":"Data","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Transformation to Oracle RAC via Rconfig: A Detailed Guide | Rackspace Technology","field_topics":"","field_slug":"convert-a-standalone-database-to-oracle-rac-by-using-rconfig","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7879","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/comments?post=7879"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7879\/revisions"}],"predecessor-version":[{"id":9729,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7879\/revisions\/9729"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media\/7881"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media?parent=7879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/categories?post=7879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/tags?post=7879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}