ORA-600 [Cursor Not Typechecked] Reported In Alert Log
(Doc ID 745146.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
The alert log is showing following error :
ORA-00600: internal error code, arguments: [Cursor not typechecked], [], [], [], [], [], [], []
with call stack functions from the trace file looking similar to:
... kksfbc opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 ...
It is also possible to see the ORA-600 [Cursor not typechecked] in relation to an ORA-7445 [kkscsCheckCursor]:
Mon Oct 31 02:27:14 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x60] [PC:0x187F62E, kkscsCheckCursor()+274]
Mon Oct 31 02:27:20 2011
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_7860.trc (incident=515086):
ORA-00600: internal error code, arguments: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_7829.trc (incident=514894):
ORA-07445: exception encountered: core dump [kkscsCheckCursor()+274] [SIGSEGV] [ADDR:0x60] [PC:0x187F62E] [Address not mapped to object] []
Incident details in:<diagnostic_dest>/diag/rdbms<dbname>/<instname>/incident/incdir_514894/<instname>_ora_7829_i514894.trc
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x60] [PC:0x187F62E, kkscsCheckCursor()+274]
Mon Oct 31 02:27:20 2011
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_7860.trc (incident=515086):
ORA-00600: internal error code, arguments: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_7829.trc (incident=514894):
ORA-07445: exception encountered: core dump [kkscsCheckCursor()+274] [SIGSEGV] [ADDR:0x60] [PC:0x187F62E] [Address not mapped to object] []
Incident details in:<diagnostic_dest>/diag/rdbms<dbname>/<instname>/incident/incdir_514894/<instname>_ora_7829_i514894.trc
where the ORA-7445 [kkscsCheckCursor] call stack trace looks similar to:
... kkscsCheckCursor kksSearchChildList kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx ...
Changes
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 |