Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the connect descriptor programmatically?
Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<blb8f017kmv158kvsfgbku104sv7654pu5_at_4ax.com>...
> pelekhl_at_msn.com (lev) wrote:
>
> >Hello,
> >
> >Is it possible to programmatically determine the connect descriptor
> >for an Oracle database without having to parse the tsnnames.ora file?
> >Any info is highly appreciated. Thank you.
What are you really trying to accomplish?
> >
> >Lev
>
> I expect not...Where would it look?
Listener log, if there happens to be one? grep for Listening for port, hostname and service_updates for SID. On each possible host?
>
> There are other methods ( Oracle Names, LDAP etc) for obtaining the info, but , AFAIK, there is no 'unconfigured' discovery
> of Oracle instances..
>
> hth,
jg
-- @home.com is bogus. http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=273579.1Received on Tue Jul 13 2004 - 19:21:39 CDT