Re: CREATE DATABASE LINK

I just resolved this exact problem for one of our users. You really have 3 machines involved: Your NT workstation and the 2 database servers. Entries in tnsnames have to be made on at least 2 of them. Your NT workstation so it can get to database A and the tnsnames on A so it can resolve the link to server B.

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Christian Bielzer <christian.bielzer_at_sawis.de> wrote in message
news:3975B06E.3E0A4090_at_sawis.de...


> Maybe I have to be more precisely. Each of the two Databases is running on

> SUN

> and I am accessing  them using SQL-PLUS running on a Windows NT4.0 client

> PC.

>

> Christian Bielzer schrieb:

>

> > I am having two 8.0.5 databases running on separate hardware. In each

> > database I have created a user with dba previleges. I than create a

> > databaselink:

> >

> > CREATE DATABASE LINK toRemoteDb CONNECT TO chris IDENTIFIED BY tiger

> > USING 'wds';

> >

> > This stament was processed successful. I than wanted to access a table

> > on the remote database, so I launched the following statement:

> >

> > select * from standortliste_at_toRemoteDb ;

> > ORA-12154: TNS:could not resolve service name

> >

> > Since the error implies that the service is not specified in the

> > tnsname.ora, I added the service and still get the error-message.

> >

> > What am I doing wrong?

> >

> > Thanks in advance

> >

> > Christian Bielzer

>