Mi estimado, al ejecutar la sentencia que me diste, obtengo el siguiente error:
ORA-29257: host 192.168.1.2 unknown
ORA-06512: at "SYS.UTL_INADDR", line 4
ORA-06512: at "SYS.UTL_INADDR", line 35
ORA-06512: at line 1
29257. 00000 - "host %s unknown"
*Cause: The specified host was unknown.
*Action: Check the spelling of the host name or the IP address. Make sure
that the host name or the IP address is valid.
Sabes a q se debe???
Cita:
Iniciado por huesos52 
Código SQL:
Ver originalSELECT UTL_INADDR.get_host_name('192.168.1.2') FROM dual;
Recibe como parametro la IP y retorna el hostname del servidor.
Saludos