OraFAQ Forum: Networking and Gateways => how to deal with this error message: ORA-02085 database link string connects to string

Members

Help

Home

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)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

how to deal with this error message: ORA-02085 database link string connects to string [message #311618]

Sat, 05 April 2008 02:40

crazyzhou
Messages: 20
Registered: March 2008
Location: china

Junior 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.

Report message to a moderator

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

Michel Cadot
Messages: 17716
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

GLOBAL_NAMES

Regards
Michel

Report message to a moderator

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

Arju
Messages: 1488
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

Report message to a moderator

Previous Topic:	Listner
Next Topic:	Connecting Through .NET

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 27 04:52:47 CDT 2008

Total time taken to generate the page: 0.02488 seconds

.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.