Tag Archives: ORA-600

ORA-600(qerrmOStart2)错误

Posted on 2012/05/15 by yangtingkun

客户11.2.0.2 RAC for Solaris 10出现ORA-600错误。 错误信息为： Fri May 11 14:22:45 2012 Errors IN file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trc (incident=194913): ORA-00600: 内部错误代码, 参数: [qerrmOStart2], [1740], [ORA-01740: 标识符中缺失双引号 ], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trc Fri May 11 … Continue reading →

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

ORA-600(qkaffsindex5)错误

Posted on 2012/05/14 by yangtingkun

客户11.2.0.2 RAC for Solaris10上的错误。 错误信息为： 2012-05-04 22:00:04.768000 +08:00 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" 2012-05-04 22:00:17.279000 +08:00 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_5730.trc (incident=231810): ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], … Continue reading →

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

ORA-600(ksnpost:ksnigb)错误

Posted on 2012/05/12 by yangtingkun

客户10.2.0.5 RAC for HP-UX ia64出现ORA-600(ksnpost:ksnigb)的错误。 错误信息如下： Wed Apr 25 16:32:21 UTC 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc: ORA-00600: Message 600 NOT found; No message file FOR product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb] Wed Apr 25 16:32:55 UTC 2012 Trace dumping IS performing id=[cdmp_20120425163255] … Continue reading →

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

在线索引重建被取消导致大量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(qertbFetchByRowID)错误

Posted on 2012/05/08 by yangtingkun

以前也碰到过这个错误，不过由于无法直接连接数据库，没有办法深入分析。这次虽然同样没有办法连接数据库，但是获取了更详细的信息，基本确定导致问题的原因。 错误信息如下： Wed May 09 10:41:32 2012 Errors IN file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []Wed May 09 10:41:32 2012 Errors in file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], … Continue reading →

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

ORA-600(kgavsd_3)错误

Posted on 2012/05/05 by yangtingkun

客户9208环境出现ORA-600[kgavsd_3]错误。 错误信息为： Thu DEC 15 15:47:57 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_659472.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 2 ORA-03113: end-of-file ON communication channel ORA-03113: end-of-file ON … Continue reading →

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

ORA-600(ktspfupdst-1)错误

Posted on 2012/05/01 by yangtingkun

客户9208数据库出现ORA-600[ktspfupdst-1]错误。 错误信息为： Sat Mar 31 02:50:48 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_1896900.trc: ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operationSat Mar … Continue reading →

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

ORA-600(6002)错误

Posted on 2012/04/19 by yangtingkun

客户数据库出现ORA-600(6002)错误。 在告警文件中出现大量的错误： Sun Apr 1 16:15:41 2012 Errors IN file /oracle/orcl/udump/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], [] Sun Apr 1 16:16:43 2012 Errors IN file /oracle/orcl/udump/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], … Continue reading →

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

恢复导致ORA-600(kccfhb_1)错误

Posted on 2012/04/17 by yangtingkun

这篇文章仍然是RMAN-600错误的后续系列。 RMAN-600(8201)错误：https://yangtingkun.net/?p=690 RMAN-600(8201)错误的重现：https://yangtingkun.net/?p=716 恢复数据库出现ORA-38727：https://yangtingkun.net/?p=759 当控制文件里存在更大RESETLOGS的ORPHAN时，Oracle在10.2.0.3及以前版本是存在bug的，开始仅仅认为这个问题影响CATALOG模式的备份。但是测试发现，对于数据库的恢复同样存在影响。 如果数据库的FLASHBACK出于打开状态，那么恢复操作就会报错ORA-38727错误，而如果FLASHBACK处于关闭状态，恢复操作就可能碰到ORA-600(kccfhb_1)错误。 [orat1@hpserver2 ~]$ sqlplus / AS sysdba SQL*Plus: Release 10.2.0.3.0 – Production ON Mon Apr 16 10:58:58 2012 Copyright (c) 1982, 2006, Oracle. ALL Rights Reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.3.0 … Continue reading →

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

ORA-600(kcratr_scan_lastbwr)错误

Posted on 2012/04/05 by yangtingkun

客户的测试环境中出现这个错误。 信息如下： 2012-03-22 11:10:24.991000 +08:00 Beginning crash recovery OF 1 threads parallel recovery started WITH 15 processes Started redo scan Hex dump OF (file 2, block 130960) IN trace file /oracle11r2/app/diag/rdbms/orcl/orcl/trace/orcl_ora_8087.trc Reading datafile ‘/oradata/orcl/sysaux01.dbf’ FOR corruption at rdba: 0x0081ff90 (file … Continue reading →

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