Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem with link ORA-02051 ORA-02063

Re: problem with link ORA-02051 ORA-02063

From: cf <news_at_tolede.com>
Date: Thu, 23 Oct 2003 16:59:52 +0200
Message-ID: <3f97ecea$0$234$4d4eb98e@read.news.fr.uu.net>


I installed the patch 9.2.0.4 on my server 2000, but the problem remains. christophe.

"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de news:1066832078.990050_at_yasure...
> cf wrote:
>
> >DB2 is not IBM DATABASE, it's the link to a oracle database.
> >I have 2 oracle database 9iR2
> >
> >"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
> >news:1066759023.268672_at_yasure...
> >
> >
> >>cf wrote:
> >>
> >>
> >>
> >>>I have the same error.
> >>>
> >>>When the netwook down :
> >>>ORA-02068: following severe error from db2
> >>>ORA-03113: end-of-file on communication channel
> >>>
> >>>and when the netwook UP :
> >>>ORA-02051: Echec d'une autre session dans la même transaction
> >>>ORA-02063: preceding line from db2
> >>>
> >>>
> >>>"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
> >>>news:1066749967.390972_at_yasure...
> >>>
> >>>
> >>>
> >>>
> >>>>cf wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Hi
> >>>>>First execuse me for my poor english.
> >>>>>
> >>>>>conn system/@db1
> >>>>>
> >>>>>select count(*) from dual_at_db2
> >>>>>/
> >>>>>COUNT(*)
> >>>>>---------
> >>>>> 1
> >>>>>
> >>>>>When the netwook broken the same request return
> >>>>>ORA-02051 and ORA-02063
> >>>>>
> >>>>>When then netwook up, i have the same errors.
> >>>>>
> >>>>>But in an others session, the request is good.
> >>>>>
> >>>>>Thanks in advances.
> >>>>>Christophe.
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>Try a table in the target schema.
> >>>>
> >>>>--
> >>>>Daniel Morgan
> >>>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> >>>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> >>>>damorgan_at_x.washington.edu
> >>>>(replace 'x' with a 'u' to reply)
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>Is DB2 the name of an Oracle database or is it the IBM database product
> >>known as DB2?
> >>
> >>--
> >>Daniel Morgan
> >>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> >>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> >>damorgan_at_x.washington.edu
> >>(replace 'x' with a 'u' to reply)
> >>
> >>
> >>
> Then all I can tell you is that I can not duplicate the error messages
> you are getting using 9.2.0.4
> on W2K connecting across my network to 9.2.0.4 on Solaris 9: The
> technique works just fine.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Thu Oct 23 2003 - 09:59:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US