Re: dblink problem on two verion of ORACLE DB
Do you have the tnsnames.ora file in the 9i Oracle Home?
On 8/13/07, dba1 mcc <email@example.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:
but when I login to 9ir2 database and tried to use
DBLINK, I have error:
SQL> select * from table1@db01_link;
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
Got a little couch potato?
Check out fun summer activities for kids.