My Oracle Support Banner

ORA-7445, ORA-21779, And ORA-600 Result in Database Crash When AIX cio Mount Option Used (Doc ID 555234.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)

Symptoms

NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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 <FILESYSTEM_FILE>/oracle/admin/<INSTANCE_NAME>/bdump/<INSTANCE_NAME>_s000_315658.trc: 
ORA-07445: exception encountered: core dump [] [] [] [] [] [] 
ORA-21779: duration not active 
Fri Feb 1 03:27:55 2008 
Errors in file <FILESYSTEM_FILE>/oracle/admin/<INSTANCE_NAME>/bdump/<INSTANCE_NAME>_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 <FILESYSTEM_FILE>/oracle/admin/<INSTANCE_NAME>/bdump/<INSTANCE_NAME>_cjq0_491966.trc: 
ORA-07445: exception encountered: core dump [] [] [] [] [] [] 
Fri Feb 1 03:27:58 2008 
Errors in file <FILESYSTEM_FILE>/oracle/admin/<INSTANCE_NAME>/bdump/<INSTANCE_NAME>_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 <FILESYSTEM_FILE>/oracle/admin/<INSTANCE_NAME>/bdump/<INSTANCE_NAME>_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=<FILESYSTEM_FILE>/s816tewka01.dbf 
fno=6 lblksz=16384 fsiz=3200 
(FOB) flags=2 fib=700000038c3a4a0 incno=0 pending i/o cnt=0 
fname=<FILESYSTEM_FILE>/s816teinti01.dbf 
fno=16 lblksz=16384 fsiz=65536 
(FOB) flags=2 fib=700000038c39268 incno=0 pending i/o cnt=0 
fname=<FILESYSTEM_FILE>/s816teintd01.dbf 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.