DB Link ... weird

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
Mushfique KhanDirector OperationsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
clockwatcherCommented:
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
clockwatcherCommented:
Sorry... didn't see johnsons' post before I hit submit.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.