Re: How to get the oracle SID name ?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 3 Jan 1999 21:35:11 GMT
Message-ID: <368fdb33.937134@netnews.worldnet.att.net>

The name returned by v$database may or may not be the service name that you see in the TNSNAMES.ORA file. Also, I'm not entirely certain that the name in v$database, and the SID are entirely the same thing. I believe that they can be different.

Jonathan

On 3 Jan 99 18:30:43 GMT, suisum_at_ecn.ab.ca () wrote:

>select name from V$database;
>
>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 ?
Received on Sun Jan 03 1999 - 15:35:11 CST