Getting ORA-1000 On The Cjq0 Process After Upgrade To 11g (Doc ID 808203.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.8 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

Alert.log shows errors :

CJQ0 started with pid=48, OS id=24250
Setting Resource Manager plan SCHEDULER[0x260F4]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

....

Errors in file /u01/misc/diag/rdbms/orcl/orcl/trace/orcl_cjq0_24250.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Fri Apr 10 00:53:48 2009
Errors in file /u01/misc/diag/rdbms/orcl/orcl/trace/orcl_cjq0_24250.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded


Changes

Upgraded to 11.1.0.7

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