Difference between revisions of "Set Cluster Interconnects in Oracle RAC"
Jump to navigation
Jump to search
(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...") |
|||
Line 1: | Line 1: | ||
== To set the cluster interconnects in the RAC == | == To set the cluster interconnects in the RAC == | ||
+ | |||
+ | * Delete any reference of cluster_interconnect on the interface. | ||
+ | |||
+ | ''Before'' | ||
+ | <pre> | ||
+ | host1$ oifcfg getif | ||
+ | ce0 192.168.1.0 global cluster_interconnect | ||
+ | ce4 10.0.102.0 global public | ||
+ | </pre> | ||
+ | |||
+ | * Delete cluster interconnects using oifcfg. | ||
+ | <pre> | ||
+ | host1$ oifcfg delif -global ce0 | ||
+ | </pre> | ||
+ | ''After'' | ||
+ | <pre> | ||
+ | host1$ oifcfg getif | ||
+ | ce4 10.0.102.0 global public | ||
+ | </pre> | ||
* The cluster_interconnects must be manually set to override the default value from the OCR. | * The cluster_interconnects must be manually set to override the default value from the OCR. | ||
Line 19: | Line 38: | ||
</pre> | </pre> | ||
''After'' | ''After'' | ||
+ | <pre> | ||
SQL> select * from gv$cluster_interconnects; | SQL> select * from gv$cluster_interconnects; | ||
Line 26: | Line 46: | ||
2 ce0 192.168.1.51 NO cluster_interconnects parameter <== Source is changed | 2 ce0 192.168.1.51 NO cluster_interconnects parameter <== Source is changed | ||
</pre> | </pre> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 15:25, 9 March 2011
To set the cluster interconnects in the RAC
- Delete any reference of cluster_interconnect on the interface.
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 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