ORA-00040: Active Time Limit Exceeded - Call Aborted when running RMAN (Doc ID 1272388.1)

Last updated on MARCH 01, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Mar-2017***

Symptoms

On 11gR1 RMAN session connected as SYS fail with ORA-00040: active time limit exceeded - call aborted:

...
channel ORA_DISK_3: starting piece 26 at 27-OCT-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_3 channel at 10/27/2010 16:49:41
ORA-00040: active time limit exceeded - call aborted
...



There is a non-default active resource manager plan with SWITCH TIME directives for some consumer groups, but there is no SWITCH TIME enabled for SYS_GROUP.

<Patch 8369546> has been applied to eliminate the possibility of hitting <Bug 8369546> SQL EXECUTION GETS INTERRUPTED BY RESOURCE MANAGER WHEN EXEC TIME <MAX EXEC TIME, but it did not change the behavior.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms