Re: dblink no listener - normal connection works

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 14 Jul 2010 05:57:02 -0700 (PDT)
Message-ID: <6bccfcd8-d015-4c05-b891-404fc7f823c9_at_q22g2000yqm.googlegroups.com>

On Jul 14, 5:52 am, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
> On 14 Jul., 11:35, Carlos <miotromailcar..._at_netscape.net> wrote:
>
>
>
> > global dbname / GLOBAL_NAMES issue?
>
> > Cheers.
>
> > Carlos.
>
> not sure:
> SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME='global_names';
>
> VALUE
> ---------------------------------------------------------------------------­-----
> FALSE
>
> SQL> select * from global_name;
>
> GLOBAL_NAME
> ---------------------------------------------------------------------------­-----
> EMEADB11
>
> chris

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?

HTH -- Mark D Powell -- Received on Wed Jul 14 2010 - 07:57:02 CDT