Re: TNSNAMES.ora setting problem

Because there are differences in your sqlnet.ora. There is a line names.default_domain =
and a line names.default_zone =
If you don't specify a domain, names.default_domain will be appended to the connect string.

Hth,

--
Sybrand Bakker, Oracle DBA
Allen <allen500_at_ms15.hinet.net> wrote in message news:81i77v$bju_at_netnews.hinet.net...
> Hi,
> Can anyone give me some idea about how to set TNSNAMES.ora &
LISTENER.ora?
>
> I created 2 DB Instance. Funny things occursed, I found 2 difference
> setting when I wanted to create database link using Connect String,
> one can create dblink by "Using 'xxxx'", but the other one must set to be
> "Using 'xxxx.world'", both DB configuration (init.ora,
> tnsnames.ora,listener.ora) I have checked is the same, but why I can not
> create dblinks using the same format connect string,
>
> P.S.
> Machine: SUN
> global_names = False (initXXX.ora)
>
>
>
Received on Thu Nov 25 1999 - 12:51:14 CST