Home » RDBMS Server » Networking and Gateways » how to deal with this error message: ORA-02085 database link string connects to string (ORACLE10g 10.2.0 RHEL5)
how to deal with this error message: ORA-02085 database link string connects to string [message #311618] Sat, 05 April 2008 02:40 Go to next message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
I create a database link, but it does not work, I get the error message ora-02085, the following is Oracle's explanation:

ORA-02085 database link string connects to string

Cause: The database link attempted to connect to a database with a different name. The name of the database link must be the same name as the name of the database.

Action: Create a database link with the same name as the database to which it connects.

but sometimes I really create a different database link name from the database it link to, and it works well.

which parameters affect the database link work?

can you tell me why? thank you.


Re: how to deal with this error message: ORA-02085 database link string connects to string [message #311626 is a reply to message #311618] Sat, 05 April 2008 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
GLOBAL_NAMES

Regards
Michel
Re: how to deal with this error message: ORA-02085 database link string connects to string [message #311729 is a reply to message #311618] Sun, 06 April 2008 03:33 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Two solutions,

Either make the database link as of exactly of the global name of the database while connecting (required when global_names is set to true.)or,


show parameter global_names;
alter system set global_names=FALSE;


You can have a look at,
http://arjudba.blogspot.com/2008/04/troubleshooting-ora-2085-database-link.html
Previous Topic: Listner
Next Topic: Connecting Through .NET
Goto Forum:
  


Current Time: Thu Mar 28 09:38:17 CDT 2024