Difference between revisions of "Set Cluster Interconnects in Oracle RAC"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
</pre> | </pre> | ||
| − | + | ''Delete cluster interconnects using oifcfg.'' | |
<pre> | <pre> | ||
host1$ oifcfg delif -global ce0 | host1$ oifcfg delif -global ce0 | ||
| Line 32: | Line 32: | ||
</pre> | </pre> | ||
| − | + | ''Update the initialization parameters in both ASM and RAC database.'' | |
<pre> | <pre> | ||
alter system set cluster_interconnects = '192.168.1.50' scope=spfile sid='RAC1' ; | alter system set cluster_interconnects = '192.168.1.50' scope=spfile sid='RAC1' ; | ||
Latest 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
