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
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