Re: How to get the SID name ?
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