Converting Standalone database to RAC Using rconfig utility

Oracle RAC


> Oracle has introduced rconfig utility in version 10g of oracle.

> The pre-requisite for rconfig is database area location should either
Cluster filesystem or ASM.


#su – oracle
rac1>$crsctl check crs
$ps -ef|grep smon
$srvctl stop database -d hrms
(no need to shutdown the database it should be up and running while creating
a database)

>>>Creating a standalone database

#xhost +
.oracle single instance db
.create database
.General purpose
global database name:prod
.use same password
confirm password
.select asm
.select one disk group
.use common location for all data files
.click on browse
.select ASM_DG_FRA
.click on ok
.enable archiving
.edit archive mode parameters
Remove the entries
.click on ok

Note: To find a file location when the instance is not running

$find /u01 -name “alert_*.log”

rac1># su – oracle
$ ps-ef|grep smon
$ sqlplus / as sysdba

SQL> select name,open_mode,log_mode from v$database;
SQL> show parameter cluster
SQL> select name,open_mode,log_mode from v$database;
SQL> select name from v$controlfile;
SQL> select name from v$datafile;
SQL> select member from v$logfile;

# su – oracle
$cd $ORACLE_HOME/dbs
$cd assistants
$cd rconfig
$cd SampleXMLs/
$cp ConvertTORAC.xml ~
$vi ConvertTORAC.xml

specify current Oraclehome of non-rac database for source DBHome


specify OracleHome where the rac database should be configured


specify SID for non RAC database and credential

<n:Source DBInfo SID=”prod”>

Note: asminfo element is required only if the current non-rac


specify prefix for RAC instances Specify the list on non rac

<n:InstancePrefix>prod <n:Node name=”rac1″>

<n:InstancePrefix>prod <n:Node name=”rac2″>

The non-Rac database should have some storage

<n:shared storage type=”ASM”

Specify database area location to be configured


Specify flash Recovery area


$ rconfig ConvertTORAC.xml