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...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== To set the cluster interconnects in the RAC == | == To set the cluster interconnects in the RAC == | ||
| − | * The cluster_interconnects must be manually | + | * Delete any references of the cluster_interconnect on the interfaces. |
| + | |||
| + | ''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''' initialization parameter must be manually overrode its the default value from the OCR. | ||
''Before'' | ''Before'' | ||
| Line 13: | 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' ; | ||
| 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> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
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
