Database - RAC/Scalability (MOSC)

MOSC Banner

Different values from gv$configured_interconnects

edited Jun 4, 2016 5:03AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered

I've a 2 node cluster on 12.1.0.2.0 and I ran the SQL from both nodes from id grid connected as sysdba. The results are different. Why? Should I get the same values on both nodes?

SELECT * FROM gv$configured_interconnects

Node 1

=====

   INST_ID NAME            IP_ADDRESS       IS_ SOURCE                              CON_ID
---------- --------------- ---------------- --- ------------------------------- ----------
         1 eth1:1          169.254.90.139   NO                                           0
         1 eth0            10.140.43.10     YES                                          0
         2 eth1:1          169.254.180.151  NO                                           0
         2 eth0            10.140.43.11     YES                                          0

4 rows selected.

Node 2

=====

  1* SELECT * FROM gv$configured_interconnects

   INST_ID NAME            IP_ADDRESS       IS_ SOURCE                              CON_ID
---------- --------------- ---------------- --- ------------------------------- ----------
         2 eth1:1          169.254.180.151  NO                                           0
         2 eth0            10.140.43.11     YES                                          0
         2 eth0:5          10.140.43.20     YES                                          0
         1 eth1:1          169.254.90.139   NO                                           0
         1 eth0            10.140.43.10     YES                                          0
         1 eth0:1          10.140.43.19     YES                                          0
         1 eth0:2          10.140.43.23     YES                                          0
         1 eth0:3          10.140.43.21     YES                                          0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center