Tag Archives: ORA-7445

在线索引重建被取消导致大量ORA-600(kghstack_underflow_internal_3)错误

Posted on 2012/05/11 by yangtingkun

客户在比较繁忙的时刻执行了索引的REBUILD操作，导致大量会话被锁，最终对ONLINE REBUILD操作执行了取消操作，引发了一系列更严重的ORA-600错误。 登录数据库后，发现两个节点上ORACLE_BASE所在目录都已经100%占用。数据库无法正常通过/ AS SYSDBA方式登录。 查询告警日志发现大量的ORA-600和ORA-7445错误： Tue May 08 21:20:26 EAT 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_1555.trc: ORA-07445: exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalid permissions FOR mapped object] [0x000000000] [] [] Tue May 08 21:20:27 EAT 2012 Errors IN file … Continue reading →

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

数据字典不一致造成大量ORA-600和ORA-7445错误

Posted on 2012/03/23 by yangtingkun

测试环境中，由于将数据字典表错误的导入到当前的数据库SYS用户下，导致数据字典出现了不一致的状态，反应出来的结果就是大量的ORA-600和ORA-7445错误。 列几个错误信息，简单记录一下这个问题： Fri Feb 10 16:30:14 CST 2012 Errors IN file /u01/app/oracle/admin/orcl10g/udump/orcl10g_ora_8690.trc: ORA-00600: internal error code, arguments: [16201], [1403], [], [], [], [], [], [] Fri Feb 10 16:30:16 CST 2012 Errors IN file /u01/app/oracle/admin/orcl10g/udump/orcl10g_ora_8690.trc: ORA-00600: internal error code, arguments: … Continue reading →

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

ORA-7445(dbgrmqmqpk_query_pick_key)错误

Posted on 2012/03/06 by yangtingkun

客户数据库上出现了ORA-7445[dbgrmqmqpk_query_pick_key]错误。 详细错误信息为： Sun Nov 13 00:20:24 2010 Exception [TYPE: SIGSEGV, Address NOT mapped TO object] [ADDR:0xB38F0000000049] [PC:0x100213D08, dbgrmqmqpk_query_pick_key()+0f88] Errors IN file /opt/diag/rdbms/orcl/orcl/trace/orcl_m001_272500.trc (incident=137962): ORA-07445: 出现异常错误: 核心转储 [dbgrmqmqpk_query_pick_key()+0f88] [SIGSEGV] [ADDR:0xB38F0000000049] [PC:0x100213D08] [Address NOT mapped TO object] [] Incident details IN: /opt/diag/rdbms/orcl/orcl/incident/incdir_137962/orcl_m001_272500_i137962.trc … Continue reading →

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

ORA-7445(krslvna)错误

Posted on 2012/02/16 by yangtingkun

告警日志中出现ORA-7445[krslvna]错误，随后导致数据库的崩溃。 错误信息为： Thu Sep 8 04:12:07 2011 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 lan900 192.168.11.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 lan901 10.142.132.0 configured FROM OCR FOR … Continue reading →

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

ORA-610内部错误

Posted on 2012/01/29 by yangtingkun

ORA-600内部错误司空见惯了，这个ORA-610的内部错误还是第一次见到。 完整的相关错误信息如下： Wed Jun 22 10:01:08 2011 Errors IN file /oracle10g/admin/orcl/bdump/orcl_ora_27376.trc: ORA-00610: Internal error code Wed Jun 22 10:02:16 2011 WARNING: inbound connection timed OUT (ORA-3136) Wed Jun 22 10:05:02 2011 Process J000 died, see its trace file Wed Jun … Continue reading →

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

ORA-7445(kcsgrsn)错误

Posted on 2012/01/28 by yangtingkun

告警日志中出现这个错误。 错误信息如下： Thu DEC 23 01:00:02 2010 Starting background process EMN0 EMN0 started WITH pid=290, OS id=21705 Thu DEC 23 01:00:02 2010 Shutting down instance: further logons disabled Thu DEC 23 01:00:10 2010 Stopping background process QMNC Thu DEC 23 … Continue reading →

Posted in BUG | Tagged , , | 1 Comment

ORA-600(kgh_heap_sizes:ds)和ORA-600(kghGetHpSz1)错误

Posted on 2012/01/14 by yangtingkun

在客户10203数据库中发现多个ORA-600和ORA-7445错误。 详细错误信息如下： Tue DEC 27 11:13:55 2011 Errors IN file /oracle/admin/htzback/udump/htzback_ora_22492.trc: ORA-00600: 内部错误代码, 参数: [kgh_heap_sizes:ds], [0x2B902679E3F8], [], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [kghGetHpSz1], [0x2B902679F868], [], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [kghstack_free2], [], [], [], … Continue reading →

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

ORA-7445(kcrfw_update_blk_list)错误

Posted on 2011/12/25 by yangtingkun

客户的11.2数据库测试环境中碰到了ORA-7445(kcrfw_update_blk_list)错误。 详细的错误信息如下： Tue DEC 20 22:00:02 2011 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue DEC 20 22:00:46 2011 Exception [TYPE: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/trace/fhacdb_lgwr_24506.trc … Continue reading →

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

ORA-600(kcbshlc_1)和ORA-7445(kggchk)错误

Posted on 2011/12/18 by yangtingkun

以前同时记录两个ORA-600错误，多半是由于这个两个错误在同时，是同一次故障的不同表现，而这次两个错误则是分别出现。 客户的10.2.0.4的逻辑STANDBY备库上前后几次出现了这两个错误： Thu Jun 16 13:45:05 2011 Errors IN file /u01/app/oracle/admin/db/bdump/db_pmon_27660.trc: ORA-07445: exception encountered: core dump [kggchk()+77] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Thu Jun 16 13:45:13 2011 CKPT: terminating instance due TO error 472 Instance TERMINATED … Continue reading →

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

ORA-7445(_ssbev_env)错误

Posted on 2011/12/17 by yangtingkun

客户的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