|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.
Murali said...How to ping the ip address in oracle using query or procedure or anymethod ?.
You could shell out to the OS to do this I guess, or use an executable job.
Remember, these days most servers are configured to drop pings, so pinging them will fail...