Re: Cannot create db-link between different platform, help!

" ` s l s" <abc_at_x.y.z> wrote in message news:<aspcd2$eoj_at_netnews.hinet.net>...
> I need your help!
>
> I use Oracle 8.1.6.
>
> I'd like to create a db-link from oracle on windows2000 to the other oracle
> on sun solaris.
>
> But it doesn't work!
>
> And It works if I create a db-link from oracle on linux to the oracle on
> sun solaris.
>
> The following is the script what I write :
>
> CREATE PUBLIC DATABASE LINK TEST_LINK
> CONNECT TO ADM IDENTIFIED BY ADM
> USING 'db_string'
> /
>
> When I Query by this db link,
>
> select * from table_name_at_test_link
>
> the error message:
>
> ORA-02085 database link string connects to string
>
> By the way, I created synonyms for the table_name.
>
oerr ora 2085
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.

Looks like you need to set global_names=false in the target database's init.ora
>
> Thanks for Help!!!!!!
Received on Fri Dec 06 2002 - 17:01:49 CET