Re: strange error when I use db link

In article <MRCv4.1981$Ab1.91895_at_newsread2.prod.itd.earthlink.net>,   "Dong Tang" <tangd_at_ctcdist.com> wrote:
> Hi:
>
> I have three Oracle (LINUX, NT, LOCAL) 8.0.5 databases on three
 machines.
> I create two database links (LINUX, NT) to the two other databases
 in the
> thrid database (LOCAL) .
> I can query tables in NT through LOCAL via db link NT,
> However when I query tables in LINUX through LOCAL via db link LINUX.
> It gives me error:
>
> ORA-02085: database link LINUX.WORLD connects to BALAK.WORLD
>
> I check TNSNAMES.ORA, and LISTENER.ORA on LOCAL, LINUX and NT.
> There is no service call BALAK.
>
> All the dababase names in those machine are ORCL.
>
> Can someone tell me why?
>

You have global names on. global names make you name the database link after the databases GLOBAL_NAME (what is returned by "select * from global_name"). When using global naming, you end up with an assurance that all databases are uniquely named (as you cannot create 2 database links with the same name). It remove ambiguity.

You can either:

• turn it off (alter session, alter system, and init.ora parameters control this)
• issue "alter database rename global_name to linux" on the database that is now globally named balak. make its global name agree with your database link name

> Thanks ahead
>
> my e-maill: tangd_at_ctcdist.com
>
> Don
>
>

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.