获取oracle服务器端的IP

Examples

Retrieve the local host name and IP address.

SET serveroutput on
BEGIN
  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME);  -- get local host name
  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS);  -- get local IP addr
END;
/

GET_HOST_ADDRESS Function

This function retrieves the IP address of the specified host.

Syntax

UTL_INADDR.GET_HOST_ADDRESS (
   host  IN VARCHAR2 DEFAULT NULL) 
RETURN host_address VARCHAR2; 

Parameters

Table 171-3 GET_HOST_ADDRESS Function Parameters

Parameter	Description
host	The name of the host to retrieve the IP address.

Return Values

Table 171-4 GET_HOST_ADDRESS Function Return Values

Parameter	Description
host_address	The IP address of the specified host, or that of the local host if host is NULL.

Exceptions

UNKNOWN_HOST: The specified IP address is unknown.

获取oracle服务器端的IP

select utl_inaddr.get_host_address('host') from dual;

可能服务器端有多个IP，只能获取一个优先的IP，因为utl_inaddr.get_host_address返回结果只有一条，具体为什么，还要研究一下。

获取客户端IP

select utl_inaddr.get_host_address('terminal') from dual;
select terminal from v$session;