?
Solved

DB Link ... weird

Posted on 2013-05-30
3
Medium Priority
?
371 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
  • 2
3 Comments
 
LVL 36

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

584 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