Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Queries across databases

Re: Queries across databases

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Tue, 08 Nov 2005 13:04:36 -0500
Message-ID: <TM5cf.1334$yb2.624@news.itd.umich.edu>


Andy Kent wrote:

> Thanks - a DBLINK it is then.
>
> How come this works:
>
> Connect SYSTEM/pword_at_TC6.XYZ.COM;
> select * from dual;
>
> But this gets "ORA-12154: TNS:could not resolve service name"?
>
> create public database link tc6 using 'TC6.XYZ.COM';
> select * from dual_at_tc6;

The first statement uses the client's tnsnames.ora file to resolve TC6.XYZ.COM, the db link uses the server's tnsnames.ora file to resolve TC6.XYZ.COM. If there's different info in the different tnsnames files you may find that one works and the other doesn't, or that they resolve to different instances.

//Walt Received on Tue Nov 08 2005 - 12:04:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US