Re: help on ORA-02085 - NT

And your tnsnames.ora was a result of manual edit, correct? I have just been struggling today on a site making the same mistake, on a much larger scale.
Your init.ora parameter global_names=true (or you did set it on session level) and the global database name doesn't match the name of the link. This can be resolved in two ways:
1 quick and dirty: change global_names to false and presto 2 change the global name of your database (alter database rename global_name to), change the init.ora db_domain parameter (it is currently world)
bounce the database and presto.

Of course the latter method is preferred.

Hth,

Sybrand Bakker, Oracle DBA

chellaton_at_yahoo.com wrote in message <7j0so1$78n$1_at_nnrp1.deja.com>...
>
>
>I have two oracle databases both with SID ORC0 on
>two machines on a network - say alpha and beta.
>The entries in the TNSNAMES.ORA file are
>as
>
>ORC0.alpha =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = alpha.server.com)(PORT = 1521))
> (CONNECT_DATA = (SID = ORC0))
> )
>
>
>ORC0.beta =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = beta.server.com)(PORT = 1521))
> (CONNECT_DATA = (SID = ORC0))
> )
>
>On attempting to query thru database link I get the below error:
>ERROR at line 1:
>ORA-02085: database link ORC0.ALPHA connects to ORC0.WORLD
>
>The O/S is NT on both.
>
>Any suggestion is appreciated. Thanks!
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 03 1999 - 13:02:46 CDT