View the Public and Private ip addresses of each node in the oraclerac

View the Public and Private ip addresses of each node in the oraclerac
----- 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


----- Public network and private network connection information of cluster nodes:
Select * from x $ ksxpia;
Addr indx INST_ID PUB_KSXPIA PICKED_KSXPIA NAME_KSXPIA IP_KSXPIA
-------------------------------------------------------------------------------------------------------------------------
20172ac96f949fb8 0 1 n ocr eth1 192.168.94.11
20172ac96f949fb8 1 1 y ocr eth0 10.80.18.252



---- Node instances and 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