Tag Archives: ORA-7445

ORA-7445(kjbcrcomplete)错误

客户10.2.0.5 RAC在验证表的逻辑结构是出现ORA-7445错误。 错误信息如下: Sun Mar 31 03:45:16 EAT 2013 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_4039.trc: ORA-07445: 出现异常错误: 核心转储 [kjbcrcomplete()+5521] [SIGSEGV] [Invalid permissions FOR mapped object] [0x00000002A] [] [] 详细TRACE信息为: Ioctl ASYNC_CONFIG error, errno = 1 *** 2013-03-31 02:20:45.846 *** ACTION NAME:() 2013-03-31 … Continue reading

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

ORA-600(17147)和ORA-7445(__lwp_kill)错误

客户10.2.0.4 RAC环境出现ORA-600[17147]和ORA-7445[__lwp_kill]错误。 错误信息为: Fri DEC 14 16:05:56 2012 Errors IN file /oraclelog/admin/orcl/bdump/orcl2_diag_27263.trc: ORA-07445: exception encountered: core dump [__lwp_kill()+48] [SIGIOT] [UNKNOWN code] [0x000006A7F] [] [] ORA-00600: internal error code, arguments: [17147], [0x9FFFFFFFFD3E6BB8], [], [], [], [], [], [] Fri DEC 14 … Continue reading

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

ORA-7445(ptmax)错误

一个9.2.0.8上的bug。 虽然12c已经发布,但是仍然有部分客户的核心数据库还跑在9i环境上,有碰到了一个9208上的bug。 Thu May 16 14:18:48 2013 Errors IN file /oracle/oracle/admin/orcl/udump/orcl_ora_11922.trc: ORA-07445: 出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address NOT mapped TO object] [0x000000010] [] [] Thu May 16 14:19:49 2013 Errors IN file /oracle/oracle/admin/orcl/udump/orcl_ora_12389.trc: ORA-07445: 出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address NOT … Continue reading

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

ORA-7445(kclfusion_1)错误

客户10.2.0.4 RAC环境在启动时出现ORA-7445错误。 错误信息为: Wed Jun 27 05:10:51 2012 Starting ORACLE instance (normal) Wed Jun 27 05:11:24 2012 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 aggr1 192.168.168.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 … Continue reading

Posted in BUG | Tagged , , | Leave a comment

ORA-1000导致的ORA-7445错误

客户10.2.0.1环境,出现了ORA-1000错误并导致了ORA-7445错误的产生。 Oracle的ORA-1000错误是个普通的问题,就是当前使用的游标值超过了OPEN_CURSOR初始化参数的值,而这个错误导致的ORA-7445错误还是第一次看到: Thu Oct 28 16:32:57 2010 Errors IN file /u01/app/oracle/admin/orcl/orcl/orcl_mmon_356528.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-00604: error occurred at recursive SQL level 2 ORA-01000: maximum OPEN cursors exceeded 在文档ORA-7445 Followed By ORA-1000 “MAXIMUM … Continue reading

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

ORA-7445(ksfd_odmwat)错误

Oracle 9206 RAC环境访问LOGMINER视图时报错。 错误信息: Wed Aug 10 17:06:37 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_20704.trc: ORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address NOT mapped TO object] [0x000000008] [] [] Wed Aug 10 17:07:22 2011 Trace dumping IS performing id=[cdmp_20110810170722] 对应的TRACE信息为: *** … Continue reading

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

ORA-7445(opipls)错误

客户的9206数据库出现ORA-7445错误。 错误信息: Fri Apr 17 09:11:24 2009 Errors IN file /opt/app/admin/orcl/udump/orcl1_ora_15039.trc: ORA-07445: exception encountered: core dump [000000010102BD1C] [SIGSEGV] [Address NOT mapped TO object] [0x000000004] [] [] Fri Apr 17 09:11:25 2009 Trace dumping IS performing id=[cdmp_20090417091125] 导致该错误详细信息: *** 2009-04-17 09:11:24.746 … Continue reading

Posted in BUG | Tagged , , | Leave a comment

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(lnxadd)错误

一个由于低版本JDBC驱动导致的错误。 告警日志中错误信息为: Fri Aug 12 19:00:03 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_28464.trc: ORA-07445: exception encountered: core dump [lnxadd()+471] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Fri Aug 12 19:00:04 2011 Trace dumping IS performing id=[cdmp_20110812190004] 根据MOS文档setDouble On INSERT Corrupts … Continue reading

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