Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Database-Link
The server you are attempting to connect to, or your server, has a parameter in the init<sid>.ora files called GLOBAL_NAMES and it is set to TRUE... When this is set that way, the database link MUST be named the same as the remote database...so rename your link or set GLOBAL_NAMES=FALSE
The error you got should have told you the actual name of the database you wanted , so use that as the link name..
"Oliver Schubert" <OSchubert_at_timocom.de> wrote:
>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 Mon May 14 2001 - 09:30:01 CDT