Tag Archives: ACCESS_VIOLATION

ORA-7445(_kkdlavc)错误

客户10.2.0.1 for Windows出现ORA-7445错误。 没有打过补丁的数据库出现问题的几率果然很大: Thu Mar 29 15:11:50 2012 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_880.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] [] 这个问题是由于访问了一个不正常的视图所致,解决方法就是重建视图。关于这个bug的描述可以参考文档ORA-07445 [kkdlavc()+284] When Performing Query Against a View。

Posted in BUG | Tagged , , , , | Leave a comment

ORA-7445(_kkqtnloCbk)错误

客户10.2.0.1 for Windows 32数据库出现ORA-7445[_kkqtnloCbk]错误。 告警日志中错误信息为: Tue Nov 08 14:56:39 2011 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4720.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] [] 导致这个错误的原因是Oracle处理ANSI语法时出现异常,参考文档Bug 4204383 Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries。 这个错误影响10.2.0.3以下版本,Oracle在10.2.0.4和11.1.0.6中对这个问题进行了修正。 事实证明,Oracle对于ANSI的标准SQL写法的支持更容易存在问题,如果没有明确的跨数据库需求,建议使用Oracle自己的SQL语法,尤其是外联接的语法,更是容易出现问题。

Posted in BUG | Tagged , , , , , , | Leave a comment

ORA-7445(ksfqpcb)错误

在Oracle 10.2.0.4 RAC for Windows环境的告警日志中发现了这个错误。 Windows下的Oracle维护的不多,而Windows下的RAC就更少见了,而对应的这个错误也是比较少见的: Wed Oct 13 13:00:07 2010 Errors IN file c:\app\oracle\product\10.2.0\admin\cam\bdump\cam1_arc1_6052.trc: ORA-16038: 日志 2 SEQUENCE# 508 无法归档。 ORA-19504: 无法创建文件"" ORA-00312: 联机日志 2 线程 1: ‘+CAM/cam/onlinelog/group_2.266.724245379’ Wed Oct 13 13:00:32 2010 Errors IN file c:\app\oracle\product\10.2.0\admin\cam\bdump\cam1_m000_3972.trc: ORA-07445: 出现异常错误: … Continue reading

Posted in BUG | Tagged , , , , , , , , | Leave a comment

ORA-7445(_ssbev_env)错误

客户的Oracle 10201 for Windows环境频繁出现这个错误。 详细的错误信息为: Fri DEC 16 16:27:02 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] Fri DEC 16 16:27:03 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] … Continue reading

Posted in BUG | Tagged , , , , , , , | Leave a comment

Windows环境下的ORA-7445(ACCESS_VIOLATION)和ORA-4030错误

客户Windows环境下32位的Oracle 10.2.0.3,在告警日志中发现多次ORA-7445和ORA-4030错误信息。 详细信息为: Mon Aug 01 15:06:06 2011 Errors IN file e:\oradata\acscnprd\trc\usr\acscnprd_ora_3356.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x605033BB] [ADDR:0x4] [UNABLE_TO_WRITE] [] Mon Aug 01 15:06:06 2011 Errors IN file e:\oradata\acscnprd\trc\usr\acscnprd_ora_3356.trc: ORA-04030: OUT OF process memory WHEN trying TO … Continue reading

Posted in BUG | Tagged , , , , , , , | Leave a comment