Re: How to get the oracle SID name ?

From: <Uge_at_VaxMan.prestel.co.uk>
Date: Mon, 04 Jan 1999 18:26:45 GMT
Message-ID: <3690e4f7.24834942@news.prestel.co.uk>

Naa - neither v$instance, v$database or v$anything can possibly help as the connect string is used by SQL*Net to make a connection and then discarded. If the questioner really means database name or instance name then it's a different story.

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

---

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 ?
>
> : Im working with Oracle Rel. 7.3.
>
> : my email is: adrian.moor_at_swol.de
>
> : many thanks for your tip.
>
>
>
>
> --
> Best regards,
Received on Mon Jan 04 1999 - 12:26:45 CST