Difference between revisions of "Set Cluster Interconnects in Oracle RAC"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
== To set the cluster interconnects in the RAC == | == To set the cluster interconnects in the RAC == | ||
| − | * Delete any | + | * Delete any references of the cluster_interconnect on the interfaces. |
''Before'' | ''Before'' | ||
| Line 20: | Line 20: | ||
</pre> | </pre> | ||
| − | * The cluster_interconnects must be manually | + | * The '''cluster_interconnects''' initialization parameter must be manually overrode its the default value from the OCR. |
''Before'' | ''Before'' | ||
Revision as of 15:26, 9 March 2011
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
