Thursday, November 8, 2012

Oracle :View Cluster Interconnects through SQLPLUS

To verify the interconnect settings, query the (G)V$CLUSTER_INTERCONNECTS and
the (G)V$CONFIGURED_INTERCONNECTS

SQL> SELECT * FROM V$CLUSTER_INTERCONNECTS;

NAME            IP_ADDRESS       IS_ SOURCE
--------------- ---------------- --- -------------------------------
en1             10.62.144.137    NO  Oracle Cluster Repository
en2             10.62.115.218    NO  Oracle Cluster Repository

SQL> SELECT * FROM V$CONFIGURED_INTERCONNECTS;

NAME            IP_ADDRESS       IS_ SOURCE
--------------- ---------------- --- -------------------------------
en1             10.62.144.137    NO  Oracle Cluster Repository
en2             10.62.115.218    NO  Oracle Cluster Repository
en0             162.50.100.162   YES Oracle Cluster Repository

SQL> DESC V$CONFIGURED_INTERCONNECTS

Name
 --------------------------------------------------------------------
 NAME
 IP_ADDRESS
 IS_PUBLIC
 SOURCE

No comments:

Post a Comment