DBA命令速查3：获取Oracle服务器IP的方法

--Single DB
select  
sys_context('USERENV','SERVER_HOST') as HOST,  
utl_inaddr.get_host_address(sys_context('USERENV','SERVER_HOST')) as IP  
from dual;
复制

--RAC
 select   
        indx            as "Interface Index",  
        inst_id         as "RAC Instance",  
        pub_ksxpia      as "Public?",  
        picked_ksxpia   as "RAC Device",  
        name_ksxpia     as "NIC Device",  
        ip_ksxpia       as "IP Address"  
from    x$ksxpia;  
复制

SYS_CONTEXT
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SYS_CONTEXT.html#GUID-B9934A5D-D97B-4E51-B01B-80C76A5BD086
复制