RAC conversion

 

Make sure same ORACLE_HOME is copied on both the nodes.

1. Relink library binaries to enable RAC on a particular Oracle Home

$ cd $ORACLE_HOME

$ cd rdbms/lib/

$ make -f ins_rdbms.mk rac_on

$ make -f ins_rdbms.mk ipc_rds ioracle

2. Adding system parameters

a. If adding to spfile

SQL> ALTER SYSTEM SET instance_name=DBNAME2 SCOPE=SPFILE SID='DBNAME2';

SQL> ALTER SYSTEM SET instance_number=2 SCOPE=SPFILE SID='DBNAME2';

SQL> ALTER SYSTEM SET thread=2 SCOPE=SPFILE SID='DBNAME2';

b. If adding to pfile

DBNAME2.instance_number=2

DBNAME1.instance_number=1

DBNAME1.local_listener=’node1 hostname:port’

DBNAME2.local_listener=’node2 hostname:port’

DBNAME2.thread=2

DBNAME1.thread=1

DBNAME2.undo_tablespace='UNDOTBS2'

DBNAME1.undo_tablespace='UNDOTBS1'

3. Adding Online logfiles and UNDO Tablespace for Node2 --- Create only if not present

alter database add logfile thread 2 group 1 size <>;

alter database add logfile thread 2 group 2 size <>;

create undo tablespace UNDOTBS2 datafile '+DATAC1' size <>;

4. Adding services to the Cluster

srvctl add database -d DBNAME -o <ORACLE_HOME>

srvctl add instance -d DBNAME -i DBNAME1 -n node1 hostname

srvctl add instance -d DBNAME -i DBNAME2 -n node2 hostname

srvctl setenv database -d DBNAME -T TNS_ADMIN=<ORACLE_HOME>/network/admin/DBNAME

srvctl getenv database -d DBNAME

5.Create spfile in DISKGROUP point and add its entry in initDBNAME1.ora file at dbs. Copy the init file from Node1 to Node2 -

E.g. spfile='+DATAC1/spfieleDBNAME.ora'

6. Copy tnsnames.ora ,sqlnet.ora ,password file ,wallet files to NODE2 and make necessary changes.

7. Start database from srvctl

srvctl start database -d DBNAME