Re: dblink no listener - normal connection works
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 15 Jul 2010 06:14:51 -0700 (PDT)
Message-ID: <0c7584b4-36d1-4ce2-9476-bd5981370c3c_at_e5g2000yqn.googlegroups.com>
On Jul 14, 2:21 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Wed, 14 Jul 2010 05:57:02 -0700, Mark D Powell wrote:
> > One of the default rules for a database link is that the link name must
> > match the remote database name: what is the name of the remote database?
>
> That is true only in the situations when the global_names=true, which is
> a recommended setting, though not the default one.
>
> --http://mgogala.byethost5.com
Date: Thu, 15 Jul 2010 06:14:51 -0700 (PDT)
Message-ID: <0c7584b4-36d1-4ce2-9476-bd5981370c3c_at_e5g2000yqn.googlegroups.com>
On Jul 14, 2:21 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Wed, 14 Jul 2010 05:57:02 -0700, Mark D Powell wrote:
> > One of the default rules for a database link is that the link name must
> > match the remote database name: what is the name of the remote database?
>
> That is true only in the situations when the global_names=true, which is
> a recommended setting, though not the default one.
>
> --http://mgogala.byethost5.com
As an interesting side fact, I remember the default being true so I checked the manuals: Sure enough using 10.2 documentation it does default to true but on 8.1.7 (which has 8.1.6 Reference) the default was true. So I grabbed the 9.2 documentation and it was true there.
Krzysztof, what is the setting of global_names on the target database? I believe this parameter controls incoming requests and not outgoing link names.
HTH -- Mark D Powell -- Received on Thu Jul 15 2010 - 08:14:51 CDT