Re: Using remote database link

<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0409290648.73c69b58_at_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.
>
>

thanks for the reply but at the bottom of the copied part are the following lines:

(CONNECT_DATA = (SERVICE_NAME = LSRNO4.LSRNO0011S.x.Y.Z)

Doe you mean that teh service name should be lsrno?

Also is it a problem that more databases have the same SID?

Thanx Received on Thu Sep 30 2004 - 03:21:40 CDT