ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
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
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;