Set Cluster Interconnects in Oracle RAC

来源：互联网发布：大数据用到的java 编辑：程序博客网时间：2024/05/16 08:56

To set the cluster interconnects in the RAC

Delete any references of the cluster_interconnect on the interfaces.

Before

host1$ oifcfg getifce0  192.168.1.0  global  cluster_interconnectce4  10.0.102.0   global  public

Delete cluster interconnects using oifcfg.

host1$ oifcfg delif -global ce0

After

host1$ oifcfg getifce4  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

原文地址： http://ittichaicham.com/wiki/Set_Cluster_Interconnects_in_Oracle_RAC