Tuesday, May 22, 2012

in 11g UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4

in 11g UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4

SELECT  UTL_INADDR.GET_HOST_ADDRESS  FROM DUAL;


disable ipv6 on OS level

c:\Windows\System32\drivers\etc\hosts

---------------

ORA_CLIENT_IP_ADDRESS Returns the IP address of the client in a LOGON event, when the underlying protocol is TCP/IP

select sys_context('userenv','ip_address') from dual;





No comments:

Post a Comment

Followers