ORA-3113 And ORA-7445 [kcbzww] Database doesn't Open
(Doc ID 455979.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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.
Database startup fails with ora-7445[kcbzww].
In alert.log:
Wed Aug 22 16:56:38 2007
ALTER DATABASE OPEN
Wed Aug 22 16:56:38 2007
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: <FILESYSTEM_PATH>\REDO03.LOG
Successful open of redo thread 1
Wed Aug 22 16:56:38 2007
SMON: enabling cache recovery
Wed Aug 22 16:56:38 2007
Successfully onlined Undo Tablespace 1.
Wed Aug 22 16:56:38 2007
SMON: enabling tx recovery
Wed Aug 22 16:56:38 2007
Database Characterset is WE8MSWIN1252
Wed Aug 22 16:56:39 2007
Errors in file <FILESYSTEM_PATH>\udump\<INSTANCE_NAME>_ora_5652.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kcbzww+329]
ALTER DATABASE OPEN
Wed Aug 22 16:56:38 2007
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: <FILESYSTEM_PATH>\REDO03.LOG
Successful open of redo thread 1
Wed Aug 22 16:56:38 2007
SMON: enabling cache recovery
Wed Aug 22 16:56:38 2007
Successfully onlined Undo Tablespace 1.
Wed Aug 22 16:56:38 2007
SMON: enabling tx recovery
Wed Aug 22 16:56:38 2007
Database Characterset is WE8MSWIN1252
Wed Aug 22 16:56:39 2007
Errors in file <FILESYSTEM_PATH>\udump\<INSTANCE_NAME>_ora_5652.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kcbzww+329]
In trace file:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 1
*** SERVICE NAME:(SYS$USERS) 2007-08-22 16:56:39.328
*** SESSION ID:(29.3) 2007-08-22 16:56:39.328
*** 2007-08-22 16:56:39.328
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump:[ACCESS_VIOLATION] [_kcbzww+329] [PC:0x498D45] [ADDR:0xB252C0D8] [UNABLE_TO_READ] []
Current SQL statement for this session:
select order#,columns,types from access$ where d_obj#=:1
With the OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 1
*** SERVICE NAME:(SYS$USERS) 2007-08-22 16:56:39.328
*** SESSION ID:(29.3) 2007-08-22 16:56:39.328
*** 2007-08-22 16:56:39.328
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump:[ACCESS_VIOLATION] [_kcbzww+329] [PC:0x498D45] [ADDR:0xB252C0D8] [UNABLE_TO_READ] []
Current SQL statement for this session:
select order#,columns,types from access$ where d_obj#=:1
Call stack trace:
kcbzww kcbzgb kcbzib kcbgtcr ktrget kdiixs1 qerixtFetch qertbFetchByRowID opifch2 opifch opiodr rpidrus rpidru rpiswu2 rpidrv rpifch kqllod
Changes
Database running on AMD platform.
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 |