Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the connect descriptor programmatically?

Re: How to get the connect descriptor programmatically?

From: Joel Garry <joel-garry_at_home.com>
Date: 13 Jul 2004 17:21:39 -0700
Message-ID: <91884734.0407131621.533d6079@posting.google.com>


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.1
Received on Tue Jul 13 2004 - 19:21:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US