Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: CREATE DATABASE LINK

Re: CREATE DATABASE LINK

From: Christian Bielzer <christian.bielzer_at_sawis.de>
Date: 2000/07/19
Message-ID: <3975AE2B.132F40AF@sawis.de>#1/1

Jacques,

I just did and it work in both ways!

Jacques Desmazieres schrieb:

> Christian,
>
> Have you tried to connect the remote database using sqlplus chris/tiger_at_wds
> in order to check first that you can access and connect the remote database?
>
> Jacques
>
> "Christian Bielzer" <christian.bielzer_at_sawis.de> wrote in message
> news:39755BA0.5ACA8949_at_sawis.de...
> > 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
> >
Received on Wed Jul 19 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US