Set Cluster Interconnects in Oracle RAC

To set the cluster interconnects in the RAC

• The cluster_interconnects must be manually set to override 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

• Command to delete & add the new cluster interconnect interface on each node:

/opt/oracrs/bin/oifcfg delif -global ce1 # (use -delif -global) /opt/oracrs/bin/oifcfg delif -global ce0

Then RAC & ASM were shutdown and with CRS still running cluster interconnects are deleted from oifcfg on all nodes: /opt/oracrs/bin/oifcfg delif -global ce1 /opt/oracrs/bin/oifcfg delif -global ce0

Before these settings were deleted oifcfg output was as shown below:

ichamma1@il06dwprd1$ oifcfg getif ce0 192.168.1.0 global cluster_interconnect ce4 10.0.102.0 global public

After these settings were made new oifcfg output is as shown below:

On node il27dwprd1 aramasw1@il27dwprd1$ /opt/oracrs/bin/oifcfg getif ce4 10.17.244.0 global public

on node il27dwprd2 aramasw1@il27dwprd2$ /opt/oracrs/bin/oifcfg getif ce4 10.17.244.0 global public aramasw1@il27dwprd2$