-----Cluster private Network connection information:
SELECT * from Gv$cluster_interconnects;
inst_id NAME ip_address is_public SOURCE
---------- ----- -------------------- --------- ------------------------------
1 eth1 192.168.94.11 NO Oracle Cluster Repository
2 eth1 192.168.94.12 NO Oracle Cluster Repository
-----cluster node Public network, private network connection information:
SELECT * from X$ksxpia;
ADDR INDX inst_id pub_ksxpia picked_ksxpia name_ksxpia Ip_ksxpia
---------------- ---------- ---------- --------------- -------------------- -------------------- -------------------- ----------
00002ac96f949fb8 0 1 N OCR eth1 192.168.94.11
00002AC96F949FB8 1 1 Y OCR eth0 10.80.18.252
----Each node instance, public network information
Select Inst_id,utl_inaddr.get_host_address (host_name) from Gv$instance;
inst_id utl_inaddr. Get_host_address (HOST_NAME)
---------- --------------------------------------------------
1 10.80.18.252
2 10.80.18.253
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
View Oracle RAC Nodes public network, private network IP information