Intermitent ORA-600 [526], [0x...], [...], [shared pool] On Different Statements (Doc ID 428027.1)

Last updated on AUGUST 23, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Nov-2010***
***Checked for relevance on 23-Aug-2013***

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 /opt/oracle/admin/FOM1ORP1/udump/fom1rp12_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 /opt/oracle/admin/FOM1ORP1/udump/fom1rp12_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 /opt/oracle/admin/FOM1ORP1/bdump/fom1rp12_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 /opt/oracle/admin/FOM1ORP1/bdump/fom1rp12_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 /opt/oracle/admin/FOM1ORP1/bdump/fom1rp12_pmon_12383.trc:
ORA-00474: SMON process terminated with error
Wed Mar 7 13:56:35 2007
PMON: terminating
instance due to error 474

 

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