|Identifying Host Names and IP Addresses - This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.|
Mat said...I think that it's a good article
SomeOneElse said...i think the same
Mofizbd@gmail.com said...Many many things for this. Its very much help full for me
Asad said...dear all
I am using this command... to get the name of machine
select UTL_INADDR.Get_Host_Name('IP Address...') from dual;
it is accurately replying me machine name.
but my server is configured on SAN along with LAN.
so my server has two IP addresses. and when i try to get the IP address through name of server .....
select UTL_INADDR.Get_Host_Address('Machine Name ...') from dual;
it simply returns me SAN ip address but i need LAN ip address
how can I get????
The short answer is I don't know. You need to contact Oracle support.
PS. Questions in the forum, not in the comments.
Manish Mohan said...You can use SYS_CONTEXT('USERENV', 'SERVER_HOST_IP')
SERVER_HOST_IP is not a valid parameter. See the docs.
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!