Hi! Server IP you would get with this: SELECT UTL_INADDR.get_host_address from dual; Look at: http://www.oracle-base.com/articles/misc/IdentifyingHostNamesAndAddresses.php I don't know about listener port... I think there could be a way to do that without parsing... -Teijo >>> "sol beach" <sol.beach@xxxxxxxxx> 10.9.2008 4:27 >>> If you are determined to do this from a procedure running inside Oracle,you should be able to use UTL_FILE to read listener.ora & then parse it. This presumes UTL_FILE can access the directory where listener.ora reside. Alternatively, I am sure it can be by a custom Java procedure. On Tue, Sep 9, 2008 at 5:46 PM, Bala <oratips@xxxxxxxxx> wrote: > Is there anyway to find out Server IP Address and Listener Port from within > an Oracle 10gR2 Database ? > Is it Possible at all ? > > Thanks for any all tips. > -- > Bala Rao > -- //www.freelists.org/webpage/oracle-l