Re: ora-01013

From: Njål A. Ekern <n.a.ekern_at_usit.uio.no>
Date: Tue, 30 Jun 1998 13:05:34 +0200
Message-ID: <3598C67E.4F82@usit.uio.no>

Zdenka Spoljaric wrote:
>
> We run Oracle 7.3.3.4 on Unix AIX sp 4.1.5. Very often when running long
> jobs we get an error ORA-01013 - user requested cancel of current operation
> even though the user did not cancel the job. Does anyone know what can be a
> reason for this error ?

Maybe this:

PROBLEMS & SOLUTIONS

ORA-1013 is Received by Queries in 7.3.3.3 when DCD is enabled.

Problem:

Long running queries receive ORA-1013 in 7.3.3.3 when Dead Connection Detection
enabled. Disabling DCD will resolve the problem.

Solution:

You are running to Bug430972 which is fixed in SQL*Net V.2.3.4

Workaround is to disable DCD. Another potential workaround is to keep the
DCD on, but to change the expiration time to take longer than the query takes.

References:

BUG: 430972
BUG: 351547 Njål

>
> Any help highly appreciated
>
> E-mail me on zspoljar_at_pm.com.au

--
Njål Arild Ekern, ADB-seksjonen USIT
Postboks 1059 Blindern, 0316 OSLO
Tlf 22852477, fax 22852730 Received on Tue Jun 30 1998 - 06:05:34 CDT