Re: How to get the SID name ?

From: <Uge_at_VaxMan.prestel.co.uk>
Date: Mon, 04 Jan 1999 18:26:44 GMT
Message-ID: <3690e3b0.24507974_at_news.prestel.co.uk>


This can't be possible. Once SQL*Net has used the service name to expand to a connect string it is lost before the Oracle App is connected to. You do you care what string was used ? Could be different on all clients.
Your only hope would be st write something outside Oracle to read tnsnames.ora line by line - but even then you would need to know the node/sid at least, and there may be > 1 alias.

Eugene (Oracle Certified dba looking for work on NT or VMS).



"Adrian" <adrian.moor_at_swol.de> wrote:

> Hi everybody,
>
> does enybody know, how to get the oracle SID-ALIAS name (alias for the
> instance from the tnsnames.ora file)
> from a PLSQL programm or from sqlplus ?
>
> Im working with Oracle Rel. 7.3.
>
> many thanks for your tip.
>
>
Received on Mon Jan 04 1999 - 19:26:44 CET

Original text of this message