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

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

Re: problem with link ORA-02051 ORA-02063

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 22 Oct 2003 07:14:25 -0700
Message-ID: <1066832078.990050@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 Wed Oct 22 2003 - 09:14:25 CDT

Original text of this message

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