From: Krzysztof Cierpisz on
>
> but now even when I change it back (the service name) to TEST and try
> to create dblink using 'TEST' it's not working.
>

correction to the above,

replacing OXO with TEST in tnsnames.ora and in dblink creation works.

I don't understand now why OXO as tnsname is not working returning no
listener.

thanks,
chris
From: Carlos on
On Jul 14, 10:29 am, Krzysztof Cierpisz <ciape...(a)gmail.com> wrote:
> > but now even when I change it back (the service name) to TEST and try
> > to create dblink using 'TEST' it's not working.
>
> correction to the above,
>
> replacing OXO with TEST in tnsnames.ora and in dblink creation works.
>
> I don't understand now why OXO as tnsname is not working returning no
> listener.
>
> thanks,
> chris

global dbname / GLOBAL_NAMES issue?

Cheers.

Carlos.
From: Krzysztof Cierpisz on
On 14 Jul., 11:35, Carlos <miotromailcar...(a)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
From: Mark D Powell on
On Jul 14, 5:52 am, Krzysztof Cierpisz <ciape...(a)gmail.com> wrote:
> On 14 Jul., 11:35, Carlos <miotromailcar...(a)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 --
From: Mladen Gogala on
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