From: Thomas J. Kyte Subject: Re: strange error when I use db link Date: 2000/03/03 Message-ID: <89mvu9$dce$1@nnrp1.deja.com>#1/1 References: To: tangd@ctcdist.com X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.0 x31.deja.com:80 (Squid/1.1.22) for client 205.227.43.13 Organization: Deja.com - Before you buy. X-Article-Creation-Date: Fri Mar 03 00:10:52 2000 GMT X-MyDeja-Info: XMYDJUIDtkyte Newsgroups: comp.databases.oracle.server In article , "Dong Tang" 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@ctcdist.com > > Don > > -- Thomas Kyte tkyte@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.