RCONFIG UTILITY
—————————
> 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
.next
.create database
.next
.General purpose
global database name:prod
next
next
.use same password
confirm password
next
.select asm
next
password:racdba
.select one disk group
next
.use common location for all data files
next
.click on browse
.select ASM_DG_FRA
.click on ok
.enable archiving
.edit archive mode parameters
Remove the entries
.click on ok
next>next>next>next>finish>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
$ls
$cd assistants
$ls
$cd rconfig
$cd SampleXMLs/
$ls
$prod
$cp ConvertTORAC.xml ~
$cd
$ls
$vi ConvertTORAC.xml
specify current Oraclehome of non-rac database for source DBHome
<n:SourceDBHome>/u01/app/oracle/product/10.2.0/db_home
specify OracleHome where the rac database should be configured
<n:TargetDBHome>/u01/app/oracle/product/10.2.0/db_home
specify SID for non RAC database and credential
<n:Source DBInfo SID=”prod”>
<n:password>racdba</n:password>
<n:Role>sysdba</n:Role>
Note: asminfo element is required only if the current non-rac
<n:password>racdba
<n:Role>sysdba
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
<n:TrgetDatabaseArea=+ASM_DG_DATA>
Specify flash Recovery area
<n:TargetFRA=+ASM_DG_FRA>
$ rconfig ConvertTORAC.xml
—————————————————————————————————
