Intermitent ORA-600 [526], [0x...], [...], [shared pool] On Different Statements
(Doc ID 428027.1)
Last updated on FEBRUARY 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterInformation in this document applies to any platform.
Symptoms
You are seeing the database report a lot of ORA-600 [526] with third argument pointing to [shared pool].
The error can cause the instance to crash if it hits a background process.
Wed Mar 7 13:46:16 2007
Errors in file <FILESYSTEM_PATH>/udump/<INSTANCE_NAME>_ora_7399.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Wed Mar 7 13:46:19 2007
Errors in file <FILESYSTEM_PATH>/udump/<INSTANCE_NAME>_ora_7399.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Wed Mar 7 13:56:27 2007
Errors in file <FILESYSTEM_PATH>/bdump/<INSTANCE_NAME>_smon_13078.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 8 out of maximum 100 non-fatal internal errors.
Wed Mar 7 13:56:32 2007
Errors in file <FILESYSTEM_PATH>/bdump/<INSTANCE_NAME>_smon_13078.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Wed Mar 7 13:56:35 2007
Errors in file <FILESYSTEM_PATH>/bdump/<INSTANCE_NAME>_pmon_12383.trc:
ORA-00474: SMON process terminated with error
Wed Mar 7 13:56:35 2007
PMON: terminating
instance due to error 474
Errors in file <FILESYSTEM_PATH>/udump/<INSTANCE_NAME>_ora_7399.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Wed Mar 7 13:46:19 2007
Errors in file <FILESYSTEM_PATH>/udump/<INSTANCE_NAME>_ora_7399.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Wed Mar 7 13:56:27 2007
Errors in file <FILESYSTEM_PATH>/bdump/<INSTANCE_NAME>_smon_13078.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 8 out of maximum 100 non-fatal internal errors.
Wed Mar 7 13:56:32 2007
Errors in file <FILESYSTEM_PATH>/bdump/<INSTANCE_NAME>_smon_13078.trc:
ORA-00600: internal error code, arguments: [526], [0x0600E7BA0], [7], [shared pool], [3], [0x0600E7B00], [2], []
Wed Mar 7 13:56:35 2007
Errors in file <FILESYSTEM_PATH>/bdump/<INSTANCE_NAME>_pmon_12383.trc:
ORA-00474: SMON process terminated with error
Wed Mar 7 13:56:35 2007
PMON: terminating
instance due to error 474
Changes
CPU_COUNT was set to invalid number
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 |