Home » Infrastructure » Linux » How to get ip address of host (Oracle Database 10G)
How to get ip address of host [message #396211] Sun, 05 April 2009 01:24 Go to next message
jcyp_71
Messages: 15
Registered: March 2009
Junior Member
I'm trying to get ip address of the database home server, i found a way to do it, it worked on Unix and Windows environments but not on Linux machines where i get as ip 127.0.0.1 or 127.0.0.2

The sentence i'm executing is the following:
select utl_inaddr.get_host_address ((select host_name from v$instance)) host_address from dual

Any idea why it does not work on Linux?
Re: How to get ip address of host [message #396213 is a reply to message #396211] Sun, 05 April 2009 01:32 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it is listed with no alias for these addresses in your /etc/hosts.

Regards
Michel
Previous Topic: error in installation due to JRE component
Next Topic: Linux auto start database/listener
Goto Forum:
  


Current Time: Fri Dec 02 18:42:20 CST 2016

Total time taken to generate the page: 0.17826 seconds