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
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 or

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: 63915
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.

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

Current Time: Mon Oct 24 07:54:19 CDT 2016

Total time taken to generate the page: 0.12211 seconds