O'Reilly logo

Oracle 11g R1/R2 Real Application Clusters Essentials by Syed Jaffer Hussain, Ben Prusinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle cluster interconnects

To verify the interconnect settings, query the (G)V$CLUSTER_INTERCONNECTS and the (G)V$CONFIGURED_INTERCONNECTS. For example, in order to verify interconnect settings with V$CLUSTER_INTERCONNECTS, issue the following SQL statement:

SQL> SELECT * FROM V$CLUSTER_INTERCONNECTS;
NAME IP_ADDRESS IS_ _ SOURCE
--------------- ---------------- --- -------------------------------
Eth0 10.10.10.34 NO Oracle Cluster Repository

To verify the interconnect settings with V$CONFIGURED_INTERCONNECTS, issue the SQL statement, as specified in the following example:

SQL> SELECT * FROM V$CONFIGURED_INTERCONNECTS; NAME IP_ADDRESS IS_ SOURCE --------------- ---------------- --- ------------------------------- eth1 10.10.10.34 NO Oracle Cluster ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required