RE: Re: Server IP Address and Listener Port

Hi another method would be to query table V_$CONFIGURED_INTERCONNECTS. This is in ORACLE 10g.

Regards,
Harshan

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Teijo Lallukka Sent: Tuesday, September 09, 2008 9:47 PM To: oratips_at_gmail.com; sol.beach_at_gmail.com Cc: oracle-l_at_freelists.org
Subject: Vs: Re: Server IP Address and Listener Port

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/IdentifyingHostNamesAndAddresse s.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_at_gmail.com> 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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l