Re: help: create database link

Your problem is that your databases are set up to only accept a database link with the same name as the database name. Error is

02085, 00000, "database link %s connects to %s"

// *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.
//

To get round this limitation comment out the global_names = TRUE
line from your initSID.ora file and restart the database.

In article <7be9qk$ht2$1_at_nnrp1.dejanews.com>,   guanjian_at_my-dejanews.com wrote:
> hi,
>
> i have a problem on create a database link.
>
> i have two server sun1, sun2, on themi installed oracle database.
> at sun1 net8 i config the service svr as local, sun2_svr point the database
> server on sun2.
> at sun2 net8, svr as local,sun1_svr as the database server on sun1.
>
> now at sun2, i create a database link:
> create database link sun1_svr
> connect to system identified by manager
> using 'sun1_svr';
>
> but when i use the database link, error reported:
>
> SQL: select * from test_table_at_sun1_svr;
> ERROR: ORA-02085: database link SUN1_SVR.WORLD connects to 805.WORLD
>
> and i change the database link name, still get this error.
>
> who can tell me, how to use the database link?
>
> thanks a lot
>
> yours
> probing
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Cheers

Bob Beattie
Oracle/Informix DBA
UNIX/NT Systems Admin

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 09:55:59 CST