Re: Create Database Link

Yes, I believe this is the case. I could not find any remote database dfinitions in tnsnames.ora on *database server*. Maybe dba removed them on purpose. I used to can do this.

Another way to prove this is if I use sql*plus from my laptop, I can use connect command to connect other databases. My client tnsnames.ora has all database definitions. I cannot do this if use sql*plus from server.

Andrew.

sybrandb wrote:
> andyho99_at_yahoo.com wrote:
> > Hi,
> >
> > I'm trying to create a database link at test database. In another word,
> > I'd like to access DEVL database tables from TEST database.
> >
> > I used TOAD to create db link (devl) from TEST database. However, I got
> > the following error messages:
> >
> > Link : "devl"
> > Error : ORA-12154: TNS:could not resolve service name
> >
> > I created db link long time ago without problem. I was wondering
> > whether this error message means some definitions missing in
> > tnsnames.ora. Thanks for your help.
> >
> > Andrew.
>
> Your tnsnames.ora on *your database server* is incorrect.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Sun Oct 29 2006 - 13:25:13 CST