Comments
| 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 allI 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???? Regards. |
Tim... said... Hi.The short answer is I don't know. You need to contact Oracle support. Cheers Tim... PS. Questions in the forum, not in the comments. |
Manish Mohan said... You can use SYS_CONTEXT('USERENV', 'SERVER_HOST_IP') |
Tim... said... Hi.SERVER_HOST_IP is not a valid parameter. See the docs. http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm#SQLRF06117 Cheers Tim... |
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!