Monthly Archives: May 2012

ORA-600(krboReadBitmap_badbitmap)错误

Posted on 2012/05/21 by yangtingkun

一个备份导致的错误。 数据库版本为10.2.0.3 RAC for HP-UX，在备份数据库的时候出现了这个ORA-600错误： Sat Oct 29 04:39:31 2011 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_29252.trc: ORA-00600: internal error code, arguments: [krboReadBitmap_badbitmap], [57599987], [+DATA/orcl/datafile/ts1.ora], [6], [30], [17629205], [1024], [52822033] Sat Oct 29 04:39:53 2011 Backup optimization FOR file +DATA/orcl/datafile/ts1.ora stopped due TO … Continue reading →

Posted in BUG | Tagged , , , , , , , | 1 Comment

ORA-7445(_kgscReleaseCursor)和ORA-4030错误

Posted on 2012/05/20 by yangtingkun

又一个ORA-4030引起的错误。 数据库版本10.2.0.3 for Windows 64环境。错误信息为： Tue Mar 13 20:51:28 中国标准时间 2012 Errors IN file d:\oracle\admin\orcl\udump\orcl_ora_6136.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kgscReleaseCursor+174] [PC:0x423AA92] [ADDR:0xC] [UNABLE_TO_READ] [] ORA-04030: 在尝试分配 244 字节 (kxs-heap-w,kntx.1) 时进程内存不足 Tue Mar 13 20:51:32 中国标准时间 2012 Errors IN file d:\oracle\admin\orcl\udump\orcl_ora_6136.trc: … Continue reading →

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

编译过程导致ORA-4068错误

Posted on 2012/05/19 by yangtingkun

一个10203上的bug，这种问题还是第一次碰到。 在10.2.0.3上，存在bug可能导致编译过程或视图失败，而失败的结果并不只是当前视图或过程不可用，而是可能影响整个数据字典，导致存储过程在执行时出现ORA-4068错误。 错误信息如下： ORA-04068: existing state OF packages has been discarded. ORA-04065: NOT executed, altered OR dropped stored PROCEDURE P_PACKAGE.P_PRO ORA-06508: PL/SQL: could NOT find program unit being called: P_PACKAGE.P_PRO ORA-06512: at line 1ORA-04068: existing state of packages has been … Continue reading →

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

ORA-600(kglobpn-bad-pga)错误

Posted on 2012/05/18 by yangtingkun

这个错误比较罕见，无论是GOOGLE还是METALINK都找不到任何的相关信息。 数据库版本是11.2.0.2 RAC环境，这个错误之所以这么罕见，也和11.2的版本太新，以致于很多问题都还没有暴露出来有关。 错误信息为： 2012-03-29 04:06:02.353000 +08:00 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18355.trc (incident=144401): ORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_144401/orcl1_ora_18355_i144401.trc 2012-03-29 04:10:12.017000 +08:00 Dumping diagnostic DATA IN … Continue reading →

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

ORA-7445(ksuklms)错误

Posted on 2012/05/17 by yangtingkun

客户的11.2.0.2 RAC环境出现了这个ORA-7445[ksuklms]错误。 错误信息为： 2012-05-10 16:25:38.561000 +08:00 Exception [TYPE: SIGSEGV, Address NOT mapped TO object] [ADDR:0x163A] [PC:0x100A554A8, ksuklms()+392] [flags: 0x0, COUNT: 1] Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_28387.trc (incident=449642): ORA-07445: exception encountered: core dump [ksuklms()+392] [SIGSEGV] [ADDR:0x163A] [PC:0x100A554A8] [Address NOT mapped TO object] … Continue reading →

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

ORA-600(kjbrrefp:key)和ORA-600(kjbmprlst:shadow)错误

Posted on 2012/05/16 by yangtingkun

这两个错误是由同一个BUG导致的。 数据库环境11.2.0.2 RAC for Solaris sparc，错误信息如下： 2012-01-29 06:15:10.168000 +08:00 Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_lms3_81.trc (incident=384590): ORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], [] Incident details IN: /app/diag/rdbms/orcl/orcl1/incident/incdir_384590/orcl1_lms3_81_i384590.trc USE ADRCI OR Support Workbench … Continue reading →

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

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-7445(dbgrlWriteAlertDetail_int)和ORA-4030导致实例崩溃

Posted on 2012/05/13 by yangtingkun

客户11.2.0.2 RAC for Solaris 10 sparc单实例出现ORA-7445和ORA-4030操作，导致实例崩溃。 这个错误比较严重： 2012-05-04 02:02:26.403000 +08:00 Archived Log entry 949 added FOR thread 1 SEQUENCE 518 ID 0x70a64e83 dest 1: Archived Log entry 950 added FOR thread 1 SEQUENCE 519 ID 0x70a64e83 dest 1: Thread 1 … 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