ORA-00600[1:dbktDefFileInit], [48005] +ORA-07445+ORA-48216

目标：分析报错及寻求解决方案。

现象：DB alert日志，出现ORA-600/07445/48215现象，且间隔几分钟，刷新出重复信息记录，如下见详情。

如下DB Alert日志输出：

ARCH: FAL archive failed. Archiver continuing

ORACLE Instance zykrac1 - Archival Error. Archiver continuing.

Mon Mar 25 00:22:19 2019

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x9827618, dbgtrRecNewestGet()+8] [flags: 0x0, count: 1]

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x9827618, dbgtrRecNewestGet()+8] [flags: 0x2, count: 2]

Errors in file :

ORA-00600: internal error code, arguments: [1:dbktDefFileInit], [48005], [], [], [], [], [], [], [], [], [], []

ORA-07445: exception encountered: core dump [dbgtrRecNewestGet()+8] [SIGSEGV] [ADDR:0x0] [PC:0x9827618] [Address not mapped to object] []

ORA-48216: Field Len Exceeds Max Field Length [5] [30] [8236] [66]

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x9827618, dbgtrRecNewestGet()+8] [flags: 0x2, count: 3]

Errors in file :

ORA-00600: internal error code, arguments: [1:dbktDefFileInit], [48005], [], [], [], [], [], [], [], [], [], []

ORA-49204: Recursive DDE invocation at Phase I

ORA-00600: internal error code, arguments: [1:dbktDefFileInit], [48005], [], [], [], [], [], [], [], [], [], []

ORA-07445: exception encountered: core dump [dbgtrRecNewestGet()+8] [SIGSEGV] [ADDR:0x0] [PC:0x9827618] [Address not mapped to object] []

ORA-48216: Field Len Exceeds Max Field Length [5] [30] [8236] [66]

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x9827618, dbgtrRecNewestGet()+8] [flags: 0x2, count: 4]

数据库中，alert 日志经常刷新，间隔几分钟出现

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x9827618, dbgtrRecNewestGet()+8] [flags: 0x0, count: 1]

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x9827618, dbgtrRecNewestGet()+8] [flags: 0x2, count: 2]

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10000] [PC:0x10000, {empty}] [flags: 0x2, count: 3]

Alert及XML见附件

/oradb/oracle/diag/rdbms/dg/zykrac1/alert/log.xml ，目录下，间隔30分钟，输出xml文件。

现象看是ORA-00600 [17147] ORA-48216 When Querying V$DIAG_ALERT_EXT View (文档 ID 2119059.1)

补丁程序18909196: QUERIES INVOLVING X$DBGALERTEXT SOMETIMES FAIL DUE TO ORA-48216

解决方法：

1. Download and install the one-off Patch 18909196, available for your platform (this issue only exists in 11.2.0.4). If a patch does not exist for your platform please open a Service Request for Oracle Support.

-OR-

2. Implement the workaround: remove (i.e. delete) the xml-based alert log within <ADR_HOME>/alert/log.xml (and log_*.xml).