Set Cluster Interconnects in Oracle RAC

To set the cluster interconnects in the RAC

• Delete any references of the cluster_interconnect on the interfaces.

Before

host1$ oifcfg getif
ce0  192.168.1.0  global  cluster_interconnect
ce4  10.0.102.0   global  public

Delete cluster interconnects using oifcfg.

host1$ oifcfg delif -global ce0

After

host1$ oifcfg getif
ce4  10.0.102.0   global  public

• The cluster_interconnects initialization parameter must be manually overrode its the default value from the OCR.

Before

SQL> select * from gv$cluster_interconnects;

   INST_ID NAME            IP_ADDRESS       IS_ SOURCE
---------- --------------- ---------------- --- -------------------------------
         1 ce0             192.168.1.50     NO  Oracle Cluster Repository
         2 ce0             192.168.1.51     NO  Oracle Cluster Repository

Update the initialization parameters in both ASM and RAC database.

alter system set cluster_interconnects =  '192.168.1.50' scope=spfile sid='RAC1' ; 
alter system set cluster_interconnects =  '192.168.1.51' scope=spfile sid='RAC2' ;  

After

SQL> select * from gv$cluster_interconnects;

   INST_ID NAME            IP_ADDRESS       IS_ SOURCE
---------- --------------- ---------------- --- -------------------------------
         1 ce0             192.168.1.50     NO  cluster_interconnects parameter     <== Source is changed
         2 ce0             192.168.1.51     NO  cluster_interconnects parameter     <== Source is changed