Set Cluster Interconnects in Oracle RAC - Revision history

Ittichai at 20:26, 9 March 2011

2011-03-09T20:26:52Z

Ittichai at 20:26, 9 March 2011

2011-03-09T20:26:22Z

Ittichai at 20:25, 9 March 2011

2011-03-09T20:25:03Z

Ittichai: Created page with "== 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 * fr..."

2011-03-09T20:21:07Z

Created page with "== To set the cluster interconnects in the RAC == * The cluster_interconnects must be manually set to override the default value from the OCR. ''Before'' <pre> SQL> select * fr..."

New page

== To set the cluster interconnects in the RAC ==

* The cluster_interconnects must be manually set to override the default value from the OCR.

''Before''
<pre>
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
</pre>

* Update the initialization parameters in both ASM and RAC database.
<pre>
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' ;
</pre>
''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
</pre>

* 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$

@@ Line 10: / Line 10: @@
 </pre>
-* Delete cluster interconnects using oifcfg.
+''Delete cluster interconnects using oifcfg.''
 <pre>
 host1$ oifcfg delif -global ce0
@@ Line 32: / Line 32: @@
 </pre>
-* Update the initialization parameters in both ASM and RAC database.
+''Update the initialization parameters in both ASM and RAC database.''
 <pre>
 alter system set cluster_interconnects =  '192.168.1.50' scope=spfile sid='RAC1' ;

@@ Line 1: / Line 1: @@
 == To set the cluster interconnects in the RAC ==
-* Delete any reference of cluster_interconnect on the interface.
+* Delete any references of the cluster_interconnect on the interfaces.
 ''Before''
@@ Line 20: / Line 20: @@
 </pre>
-* The cluster_interconnects must be manually set to override the default value from the OCR.
+* The '''cluster_interconnects''' initialization parameter must be manually overrode its the default value from the OCR.
 ''Before''

@@ Line 1: / Line 1: @@
 == To set the cluster interconnects in the RAC ==
 * The cluster_interconnects must be manually set to override the default value from the OCR.
@@ Line 19: / Line 38: @@
 </pre>
 ''After''
 SQL> select * from gv$cluster_interconnects;
@@ Line 26: / Line 46: @@
 ce0             192.168.1.51     NO  cluster_interconnects parameter     <== Source is changed
 </pre>