0

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

问题归档 2019-04-14
848
摘要:目标:分析报错及寻求解决方案。现象:DBalert日志,出现ORA-600/07445/48215现象,且间隔几分钟,刷新出重复信息记录,...

问题描述

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

现象: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).

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
最新发布
暂无内容,敬请期待...
数据库资讯
最新 热门 更多
本月热门
近期活动
全部
暂无活动,敬请期待...
相关课程
全部
暂无课程,敬请期待...