Oracle | UTL

Oracle UTL_INADDR Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Provides PL/SQL procedures to support internet addressing. It provides an API to retrieve host names and IP addresses of local and remote hosts.

AUTHID CURRENT_USER

Dependencies

DBMS_GSM_CLOUDADMIN	DBMS_ISCHED	MGMT_DB_LL_METRICS
DBMS_GSM_DBADMIN	DBMS_ISCHED_REMOTE_ACCESS	UTL_INA_LIB

Documented Yes

Exceptions

Error Code	Reason
ORA-24247	network_access_denied: Network privileges issue
ORA-29257	unknown_host: Host not found

First Available 8.1.7

Security Model Owned by SYS with EXECUTE granted to PUBLIC, DVSYS, and ORACLE_OCM

Source {$ORACLE_HOME}/rdbms/admin/utlinad.sql

Subprograms

GET_HOST_ADDRESS

GET_HOST_NAME

GET_HOST_ADDRESS

Retrieves an IP address given the host name utl_inaddr.get_host_address(host IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;

SELECT utl_inaddr.get_host_address('washington.edu')

      FROM dual;

      

      SELECT utl_inaddr.get_host_address('www.oracle.com')

      FROM dual;

Retrieve IP address of Oracle client SELECT sid, machine, utl_inaddr.get_host_address(SUBSTR(machine, INSTR(machine,'\')+1)) ip FROM gv$session WHERE type = 'USER' AND username IS NOT NULL;

GET_HOST_NAME

Retrieves a host name given the IP Address utl_inaddr.get_host_name(ip IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;

SELECT utl_inaddr.get_host_name('140.142.15.233')

      FROM dual;