Re: Dot World

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 19 Nov 1999 23:33:36 +0100
Message-ID: <943050885.4338.0.pluto.d4ee154e@news.demon.nl>

.world is the db_domain parameter.
A proper global name consists of a database name and a proper internet domain.
If you remove the domain from tnsnames.ora sqlnet will use the names.default_domain/region/zone? (don't remember, they have been using various) and append that to your database names. What is the value of your global_names init.ora parameter for both databases?

Hth,

--
Sybrand Bakker, Oracle DBA
Doug Cowles <dcowles_at_nospambigfoot.com> wrote in message news:3835C11C.35889C0D_at_nospambigfoot.com...
> Someone created a database link in oracle 7.3.3 similar to the
> following:
> (from user_db_links)
> db_link = G4XX.WORLD
> HOST = G4XX
> and in the tnsnames.ora file, an entry similar to the following
> G4XX.world =
> (DESCRIPTION =
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (Host = xxx.xxx.xxx.xxx
> (Port = 1521)
> )
> (CONNECT_DATA =
> (SID = G4XX)
> (GLOBAL_NAME = G4XX.world)
> )
> )

>

> Now on an Oracle 8.1.5 instance, with the entry either as it is above,
> or modified
> to refer to the SID as a SERVICE_NAME, no go.
> Cannot find descriptor is the message I get.
> Unless I take out the .WORLD in the tnsnames.ora file. Why? and what
> is this
> dot world for anyhow?

>

> - Dc.

> Received on Fri Nov 19 1999 - 16:33:36 CST