Re: Server IP Address and Listener Port
- From: "sol beach" <sol.beach@xxxxxxxxx>
- To: oratips@xxxxxxxxx
- Date: Tue, 9 Sep 2008 18:27:57 -0700
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
>
Other related posts:
