Getting ORA-1000 On The Cjq0 Process After Upgrade To 11g
(Doc ID 808203.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.8 [Release 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 /xxx_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 xxxl_cjq0_24250.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Setting Resource Manager plan SCHEDULER[0x260F4]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
....
Errors in file /xxx_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 xxxl_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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |