Re: Using remote database link

From: <sybrandb_at_yahoo.com>
Date: 29 Sep 2004 07:48:33 -0700
Message-ID: <a1d154f4.0409290648.73c69b58@posting.google.com>

"Joe" <iets_at_iets.nl> wrote in message news:<415a6d46$0$78772$e4fe514c_at_news.xs4all.nl>...
> > The tns service_name needs to be defined in tnsnames.ora *on the
> > database server* hosting the source database.
>
> Hi I collected my data below (changes a domain into x for privacy) can
> anyone understand why it doesn't work?
>

There is no service_name lnsro defined in the tnsnames.ora on the server.
Also global_names = true forces the service_name to be equal to the global_name of the database.

Sybrand Bakker
Senior Oracle DBA Received on Wed Sep 29 2004 - 09:48:33 CDT