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@(protected);
ERROR at line 1:ORA-12154
: TNS:could not resolve service name
Got a little couch potato?
Check out fun summer activities for kids.