Re: dblink problem on two verion of ORACLE DB
you are using server side name resolution (likely tns names) so you'll need the name to be resolvable from the 9i home on the server.
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.