Re: Dot World

From: Doug Cowles <dcowles_at_nospambigfoot.com>
Date: Fri, 19 Nov 1999 20:26:57 -0500
Message-ID: <3835F8E1.83017E34@nospambigfoot.com>

global_names is false in both cases. What is names.default_domain/region/zone?
The link is called G4XX.WORLD
With this tnsnames entry :
G4XX =

       etc, etc.,
     (CONNECT_DATA =
               (SERVICE_NAME = G4XX)
     )

)
I get the following:
select * from dual_at_G4XX
> descriptor for remote database not found
and
select * from dual_at_G4XX.world
D
X - the ususal.
With this entry -
G4XX.WORLD =

       etc, etc.,
     (CONNECT_DATA =
               (SERVICE_NAME = G4XX.WORLD)
     )

)
I get
select * from dual_at_G4XX.WORLD
ORA-12154: TNS: could not resolve service name

Now...on a different database altogether. Oracle 8.0.5. There is a link for a user sysadm, with a link very similar, called FSDEV.WORLD
I get the following
select * from dual_at_FSDEV
D
X
without the world.
Works either way.
The tnsnames entry is similar,but no world... What gives?

Sybrand Bakker wrote:

> .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 - 19:26:57 CST