In oracle, how does one obtain the local IP address and the domain name based on the IP address?
----- Resolve the ip address
SQL> select utl_inaddr.get_host_address ('Google. com') from dual;
UTL_INADDR.GET_HOST_ADDRESS ('Google. com ')
--------------------------------------------------------------------------------
122.229.30.202
----- Obtain the local IP Address
SQL> select utl_inaddr.get_host_address from dual;
GET_HOST_ADDRESS
--------------------------------------------------------------------------------
10.80.18.241
----- Reverse resolution of the host name based on the IP address
SQL> select utl_inaddr.get_host_name ('10. 80.18.241 ') from dual;
UTL_INADDR.GET_HOST_NAME ('10. 80.18.241 ')
--------------------------------------------------------------------------------
Lixora
SQL> select utl_inaddr.get_host_name ('10. 80.18.243 ') from dual;
UTL_INADDR.GET_HOST_NAME ('10. 80.18.243 ')
--------------------------------------------------------------------------------
Oracle11g-dagi
SQL> select utl_inaddr.get_host_name ('8. 8.8.8 ') from dual;
UTL_INADDR.GET_HOST_NAME ('8. 8.8.8 ')
--------------------------------------------------------------------------------
Google-public-dns-a.google.com
SQL> select utl_inaddr.get_host_name ('10. 80.18.210 ') from dual;
Select utl_inaddr.get_host_name ('10. 80.18.210 ') from dual
*
ERROR at line 1:
ORA-29257: host 10.80.18.210 unknown
ORA-06512: at "SYS. UTL_INADDR", line 4
ORA-06512: at "SYS. UTL_INADDR", line 35
ORA-06512: at line 1
SQL> select utl_inaddr.get_host_name ('10. 80.19.210 ') from dual;
Select utl_inaddr.get_host_name ('10. 80.19.210 ') from dual
*
ERROR at line 1:
ORA-29257: host 10.80.19.210 unknown
ORA-06512: at "SYS. UTL_INADDR", line 4
ORA-06512: at "SYS. UTL_INADDR", line 35
ORA-06512: at line 1