ORA-02019: Connection description for remote database not found
Home > IT Answers > Oracle > ORA-02019: Connection description for remote ...
ITKE
10345 pts.
0
Q:
ORA-02019: Connection description for remote database not found
Oracle Database, Oracle error messages, Oracle database administration
I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of the operations "ORA-02019: Connection description for remote database not found". Since I did not clone the rest of the sites I deleted the links to those sites. Can you suggest what can be the reason for this error?
ASKED: Oct 9 2009  3:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29830 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Your application is most likely trying to access objects that reside in one of the databases you didn't clone (through a inexistent dblink).

You will probably need to review your app's code, looking for objects suffixed with "@<dblink_name>".

It is also possible that those objects have synonyms, so you might need to query the all_synonyms table looking for rows containing the name of one of the dblinks you deleted in the field "db_link".

----------------
Last Answered: Oct 9 2009  3:48 PM GMT by Carlosdl   29830 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0