I knew that is problem, but based on ORACLE say you
can Only turn on one listener which is highest version
of ORACLE.
- Niall Litchfield <niall.litchfield_at_gmail.com>
wrote:
> 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 <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
> >
> >
> >
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 13 2007 - 12:05:27 CDT
