Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dblink problem on two verion of ORACLE DB
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-lReceived on Mon Aug 13 2007 - 11:06:44 CDT
![]() |
![]() |