Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

DB Link ... weird

Posted on 2013-05-30
3
Medium Priority
?
368 Views
Last Modified: 2013-06-19
Have a weird situation; 2 db links pointing to same user/pwd & same db, one is working and one is not, only the db link name is changed, getting this error ... any clue, how to identify, what's the problem?

ORA-02085: database link orcl2.WORLD connects to orcl.WORLD

Thanks
0
Comment
Question by:Mushfique Khan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 1500 total points
ID: 39208655
The error text gives you the solution:

ORA-02085: database link string connects to string
Cause: a database link connected to a database with a different name. The connection is rejected.
Action: create a database link with the same name as the database it connects to, or set global_names=false.

Changing the setting of GLOBAL_NAMES should get it working.  Here is the documentation for that parameter:

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams096.htm#CHDGEHBB
0
 
LVL 25

Expert Comment

by:clockwatcher
ID: 39208663
If your global_names parameter is set to TRUE, then  your database link name must be the same as the global_name of your remote database.

SQL> show parameter global_name
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE

Open in new window

0
 
LVL 25

Expert Comment

by:clockwatcher
ID: 39208667
Sorry... didn't see johnsons' post before I hit submit.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question