ORA-7445, ORA-21779, And ORA-600 Result in Database Crash When AIX cio Mount Option Used

(Doc ID 555234.1)

Last updated on DECEMBER 06, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.3 and later
IBM AIX on POWER Systems (64-bit)

Symptoms

MMNL terminated and crashed the database after a series of ORA-7445, ORA-2119, and various ORA-600 errors.  This happened intermittently.

Fri Feb 1 03:27:55 2008 
Errors in file /u01/home/app/oracle/admin/beats/bdump/beats_s000_315658.trc: 
ORA-07445: exception encountered: core dump [] [] [] [] [] [] 
ORA-21779: duration not active 
Fri Feb 1 03:27:55 2008 
Errors in file /u01/home/app/oracle/admin/beats/bdump/beats_s000_315658.trc: 
ORA-00600: internal error code, arguments: [kspgsp2], [0x000000000], [906], [shadow_core_dump], [], [], [], [] 
ORA-07445: exception encountered: core dump [] [] [] [] [] [] 
ORA-21779: duration not active 
Fri Feb 1 03:27:57 2008 
Errors in file /u01/home/app/oracle/admin/beats/bdump/beats_cjq0_491966.trc: 
ORA-07445: exception encountered: core dump [] [] [] [] [] [] 
Fri Feb 1 03:27:58 2008 
Errors in file /u01/home/app/oracle/admin/beats/bdump/beats_s004_524418.trc: 
ORA-00600: internal error code, arguments: [751], [0], [0], [], [], [], [], [] <--- several more of these 
Fri Feb 1 03:28:03 2008 
Errors in file /u01/home/app/oracle/admin/beats/bdump/beats_ckpt_668044.trc: 
ORA-07445: exception encountered: core dump [] [] [] [] [] [] 
Fri Feb 1 03:28:10 2008 
MMNL: terminating instance due to error 472 


The tracefile contained the string "Aborting this subtree dump because of state consistency" under the Process Section.   Only files in a filesystem mounted with the AIX cio option (/u10 in this example) were listed as FOB:

---------------------------------------- 
SO: 700000027147c58, type: 0, owner: 0, flag: -/-/-/0x00 
Aborting this subtree dump because of state inconsistency 
(FOB) flags=2 fib=700000038c38030 incno=0 pending i/o cnt=0 
fname=/u10/ORADATA/beats/s816tewka01.dbf 
fno=6 lblksz=16384 fsiz=3200 
(FOB) flags=2 fib=700000038c3a4a0 incno=0 pending i/o cnt=0 
fname=/u10/ORADATA/beats/s816teinti01.dbf 
fno=16 lblksz=16384 fsiz=65536 
(FOB) flags=2 fib=700000038c39268 incno=0 pending i/o cnt=0 
fname=/u10/ORADATA/beats/s816teintd01.dbf 

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