Re: dblink problem on two verion of ORACLE DB
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Mon, 13 Aug 2007 10:05:27 -0700 (PDT)
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@xxxxxxxxx>
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@xxxxxxxxx> 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@db01
> >
> > 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
> >
> > 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
> > --
> > //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
