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: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 8 Nov 2005 22:18:35 +0100
Message-ID: <4371162e$0$5721$ba620e4c@news.skynet.be>

"Walt" <walt_askier_at_SHOESyahoo.com> wrote in message news:TM5cf.1334$yb2.624_at_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

Could be caused by differences in the sqlnet.ora file ...

Domain name etc Received on Tue Nov 08 2005 - 15:18:35 CST

Original text of this message

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