Saturday, March 2, 2013

ORACLE - RAC Interconnect

How to check RAC Interconnect ?

Use Grid control
or

1) select * from gv$configured_interconnects;

   INST_ID NAME            IP_ADDRESS       IS_ SOURCE
---------- --------------- ---------------- --- -------------------------------
         1 ce1             172.6.12.155     NO  Oracle Cluster Repository
         1 ce0             10.21.12.155     YES Oracle Cluster Repository
         2 ce1             172.6.12.160     NO  Oracle Cluster Repository
         2 ce0             10.21.12.159     YES Oracle Cluster Repository

2) select * from gV$CLUSTER_INTERCONNECTS;
    INST_ID NAME            IP_ADDRESS       IS_ SOURCE
---------- --------------- ---------------- --- -------------------------------
         2 lan902          172.17.2.163     NO  Oracle Cluster Repository
         1 lan902          172.17.2.161     NO  Oracle Cluster Repository
         3 lan902          172.17.2.165     NO  Oracle Cluster Repository

3) SELECT INST_ID, NAME_KSXPIA, IP_KSXPIA, decode (PUB_KSXPIA, 'Y', 'YES', 'N', 'NO'),
decode  (PICKED_KSXPIA, 'OSD', 'OS dependent software', 'OCR', 'Oracle Cluster Repository', 'CI', 'cluster_interconnects parameter') FROM X$KSXPIA ;
INST_ID NAME_KSXPIA     IP_KSXPIA        DECODE(PUB_KSXPIA,'Y','YES','N   DECODE(PICKED_KSXPIA,'OSD','OS
---------- --------------- ---------------- -------------------------------- --------------------------------
         2 lan902          172.17.2.163     NO                               Oracle Cluster Repository
         2 lan901          10.29.8.44         YES                             Oracle Cluster Repository

No comments:

Post a Comment