Re: How to determine current connect string?

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/09
Message-ID: <334B9844.6191@hk.super.net>#1/1

Angelito Dizon wrote:

> Michael Ho <infoage_at_hk.super.net> wrote:
>
> >> How do I return the current connect string?
> >>
> >> Thanks,
> >
> >SELECT * from GLOBAL_NAME
> >
> >for Global Name.
> >
>
> I tried it but it did not return the connect string. Instead it returned
> ORACLE.WORLD. I tested this on a PO7 server.

So you indeed want connect string, not global name.

Connect string is a identification for the SQL*Net to resolve the global name
of the database. Connect string itself is not used by the database, but is
used by the listener instead.

Connect string had no meaning to the database, and not stored. It is stored
only in the TNSNAMES.ORA, which can be amend at any time.

Sorry, but seems only way to find out connect string is search the TNSNAMES.ORA. Received on Wed Apr 09 1997 - 00:00:00 CDT