Re: Database-Link

From: Oliver Schubert <OSchubert_at_timocom.de>
Date: 11 May 2001 14:39:04 -0500
Message-ID: <3afc3f31$0$37300$45beb828@newscene.com>

Hello,

> You say that you can log in from your client computer, so it sounds as if
> you have a correct tnsnames.ora file there. Perhaps the tnsnames.ora on
the
> db server doesn't have an entry for the other db thus it can't connect.
That
> ouldn't show when you try connecting from the client but it would produce
> the error you described.

I have check out the TNSNAMES.ORA File and there was a litle error in it, you are right at this point, but now Oracle shows me that:

ORA-02085: database link name connects to name

Cause: The database link attempted to connect to a database with a different name. The name of the database link must be the same name as the name of the database.

I have check out the names and they are equal. But Oracle writes that he attempt to connect to SERVICENAME.WORLD, and not to SERVICENAME... is this right?!

I can logon into the old Oracle-DB via the new Oracle-Server, thats all.

Whats wrong?!

best regards
OS Received on Fri May 11 2001 - 14:39:04 CDT