Xref: alice comp.databases.oracle.misc:35523
Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: celia9268@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: database link doesn't work!!!
Date: Wed, 07 Jul 1999 13:20:42 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 53
Message-ID: <7lvk6v$ccm$1@nnrp1.deja.com>
References: <7lucuu$vla$1@nnrp1.deja.com> <931321446.4172.0.pluto.d4ee154e@news.demon.nl>
X-Article-Creation-Date: Wed Jul 07 13:20:42 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT)
X-Http-Proxy: 1.1 x21.deja.com:80 (Squid/1.1.22) for client 205.150.160.214

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@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@news.demon.nl>,
  "Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote:
> Hi celia,
>
> The service name should exist in the tnsnames.ora on the SERVER
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <celia9268@my-deja.com> wrote in message
news:7lucuu$vla$1@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.