RE: Re: Server IP Address and Listener Port
- From: "Harshan Vasudevan Eppurath" <harshan.eppurath@xxxxxxxxxxxxx>
- To: <teijo.lallukka@xxxxxxxx>, <oratips@xxxxxxxxx>, <sol.beach@xxxxxxxxx>
- Date: Wed, 10 Sep 2008 12:49:04 +0530
Hi another method would be to query table V_$CONFIGURED_INTERCONNECTS.
This is in ORACLE 10g.
Regards,
Harshan
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Teijo Lallukka
Sent: Tuesday, September 09, 2008 9:47 PM
To: oratips@xxxxxxxxx; sol.beach@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: Re: Server IP Address and Listener Port
