Re: database link doesn't work!!!

Hi,

Think of it as just another client/server connection. So on the server that you create the database link, add an entry into the tnsnames.ora file.
Then check this by running plus or svrmgr on the server and doing;

connect un/pw_at_alias

Where alias is the entry you have just put in the tnsnames.ora file.

Cheers

--
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

Daniel
Oracle UK

<celia9268_at_my-deja.com> wrote in message news:7lvk6v$ccm$1_at_nnrp1.deja.com...
> 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 - 09:31:20 CDT