获取oracle服务器ip,获取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;