How to find the IP address of the database server?
January 16th, 2006 By smnair
select host_name from v$instance;
pass the host name to this second query to return the IP address:
select UTL_INADDR.get_host_address('host name') from dual ;
One Response to “How to find the IP address of the database server?”
Leave a Reply
You must be logged in to post a comment.
January 17th, 2006 at 5:59 am
or
select UTL_INADDR.get_host_address(host_name) from v$instance;
:)