Solved

DB Link ... weird

Posted on 2013-05-30
3
365 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:mkhandba
[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 500 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ORA-00923: FROM keyword not found where expected 3 95
migration MS SQL database to Oracle 30 71
Oracle DBLINKS From 11g to 8i 3 67
date show only hh:mm 2 40
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
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.  …
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

726 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