Re: dblink no listener - normal connection works

From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Wed, 14 Jul 2010 23:22:31 -0700 (PDT)
Message-ID: <b353a3e9-7ca2-49e8-b09f-ade362b4222e_at_p22g2000pre.googlegroups.com>

On 14 Jul., 14:57, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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 --

name of the remote database is
TEST.xxxx.xxxx.xxx (with domain name)

chris Received on Thu Jul 15 2010 - 01:22:31 CDT