Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: database link doesn't work!!!
Hi, Sybrand, thanks for your reply.
Still I am not sure how to solve the problem. I have two database in different servers, saying a and b. Now I create a database link in a:
create database link mylink
connect to user1 identified by user1 using 'b';
After that, I try to do 'select ... from tab1_at_mylink',
Then ora-12154 error prompted.
So should I add service name b in the tnsnames.ora of a?
Please help!!
celia
In article <931321446.4172.0.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Hi celia,
>
> The service name should exist in the tnsnames.ora on the SERVER
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <celia9268_at_my-deja.com> wrote in message
news:7lucuu$vla$1_at_nnrp1.deja.com...
> > Hi, all.
> >
> > I guess this is a simple question, but I don't know, please help me.
> >
> > I create a database link, then I try to query using this db link,
but i
> > get ora-12154 error: TNS could not resolve service name.
> > I look through some documentation, but still i am not sure what i
> > should do. Should i modify tnsnames.ora to add the service name?
> > should i modify any files in client side?
> >
> > Any help will be greatly appreciated.
> >
> > celia
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Jul 07 1999 - 08:20:42 CDT