oracle版linux查看rac ip,oracle10g RAC中查看Private IP的方法

1> 查看oracle数据字典gv$cluster_interconnects (10gR2)

SQL> select * from gv$cluster_interconnects;

INST_ID NAME IP_ADDRESS IS_PUBLIC SOURCE

---------- --------------- ---------------- --------- -------------------------------

1 interface 10.10.10.11 NO Oracle Cluster Repository

2 interface 10.10.10.12 NO Oracle Cluster Repository

2> 查看oracle内部的表x$ksxpia

SQL> conn sys/sys@grid1 as sysdba

已连接。

SQL> select * from x$ksxpia;

ADDR INDX INST_ID PUB_KSXPIA PICKED_KSXPIA NAME_KSXPIA IP_KSXPIA

-------- ---------- ---------- ---------- ----------------------- --------------- ------------

0C6A79EC 0 1 N OCR private 10.10.10.11

0C6A79EC 1 1 Y OCR public 192.168.0.231

3> 通过crs的工具获得： (10gR1对该命令支持有问题)

$ oifcfg getif

ce0 172.16.9.0 global public

ce1 192.168.9.0 global cluster_interconnect

4> 使用oradebug ,在SQLPLUS中执行

SQL>conn / as sysdba

SQL> oradebug setmypid

Statement processed.

SQL> oradebug ipc

Information written to trace file.

此时的跟踪文件中，获得：

SSKGXPT 0x613ef90 flags SSKGXPT_READPENDING socket no 7 IP 192.168.9.19 UDP 38645

-- END--