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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dblink problem on two verion of ORACLE DB

Re: dblink problem on two verion of ORACLE DB

From: Allan Nelson <anelson77388_at_gmail.com>
Date: Mon, 13 Aug 2007 11:06:44 -0500
Message-ID: <ffb96860708130906t4e1c869fxb39e6a3d5ee470d5@mail.gmail.com>


Do you have the tnsnames.ora file in the 9i Oracle Home?

Allan

On 8/13/07, dba1 mcc <mccdba1_at_yahoo.com> wrote:
>
> we have ORACLE 9ir2 and 10Gr2 on same server. based
> on ORACLE document we ONLY turn on 10Gr2 listener.
>
> The problem I have is I tried to create DBLINK on 9ir2
> database and connect to another 9ir2 datbase. I got
> "TNS:could not resolve service name" error. I can use
> following command under 10Gr2 environment:
>
> sqlplus system/manager_at_db01
>
> but when I login to 9ir2 database and tried to use
> DBLINK, I have error:
>
> SQL> select * from table1_at_db01_link;
>
> ERROR at line 1:
> ORA-12154: TNS:could not resolve service name
>
> any ideal?
>
> Thanks.
>
>
>
>
> ____________________________________________________________________________________
> Got a little couch potato?
> Check out fun summer activities for kids.
>
> http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 13 2007 - 11:06:44 CDT

Original text of this message

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