| How to get ip address of host [message #396211] |
Sun, 05 April 2009 01:24  |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
