Category Archives: BUG

Oracle bugs

ORA-600(qcsgpvc3)错误

Posted on 2012/06/09 by yangtingkun

编译包导致的错误。 数据库版本为10.2.0.4 RAC for Linux X86-64，错误信息为： Fri Nov 4 14:27:47 2011 Errors IN file /u01/admin/orcl/udump/orcl1_ora_15210.trc: ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []Fri Nov 4 14:27:47 2011 Errors in file /u01/admin/orcl/udump/orcl1_ora_15210.trc: ORA-00600: internal error code, … Continue reading →

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

ORA-600(1616)和ORA-569错误

Posted on 2012/06/08 by yangtingkun

出现错误的数据库为Oracle 10.2.0.4 RAC for HP-UX。 在RAC的一个节点上出现了ORA-600[1616]错误和ORA-569错误： Sat Apr 7 03:03:09 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl2_smon_27471.trc: ORA-00569: Failed TO acquire global enqueue. Sat Apr 7 03:04:14 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl2_smon_27471.trc: ORA-00569: Failed TO acquire global enqueue. Sat Apr 7 03:04:15 … Continue reading →

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

ORA-600(ksires_1)错误

Posted on 2012/06/07 by yangtingkun

Oracle RAC 10.2.0.4 for HP-UX环境出现ORA-600[ksires_1]错误。 错误信息为： Mon DEC 13 23:00:13 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_m000_1861.trc: ORA-00600: internal error code, arguments: [ksires_1], [], [], [], [], [], [], [] Mon DEC 13 23:00:15 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_m000_1861.trc: ORA-00600: internal error … Continue reading →

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

ORA-7445(kxfrSortGranuleInstance)错误

Posted on 2012/06/05 by yangtingkun

10.2.0.4 RAC for HP-UX上出现了这个错误。 错误信息为： Sat DEC 31 14:48:42 2011 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl1_ora_26183.trc: ORA-07445: exception encountered: core dump [kxfrSortGranuleInstance()+1248] [SIGBUS] [Invalid address alignment] [0x9FFFFFFFBDF45674] [] [] Sat DEC 31 14:49:26 2011 Thread 1 advanced TO log SEQUENCE 68840 CURRENT … Continue reading →

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

ORA-600(qsmqSetupTableMetadata-2)错误

Posted on 2012/06/04 by yangtingkun

客户10.2.0.4 RAC for HP-UX 11.31在物化视图刷新时出现这个错误。 错误信息如下： Thu May 3 22:54:44 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_21657.trc: ORA-00600: internal error code, arguments: [qsmqSetupTableMetadata-2], [], [], [], [], [], [], [] Thu May 3 22:55:20 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_21657.trc: ORA-12012: error ON … Continue reading →

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

启动取消导致ORA-600(2658)错误

Posted on 2012/06/01 by yangtingkun

客户数据库在SHUTDOWN的过程中执行了取消操作，导致了ORA-600错误。 数据库版本为10.2.0.4 RAC for HP-UX，详细错误信息为： Thu Oct 22 15:05:14 2009 Shutting down instance: further logons disabled Thu Oct 22 15:05:15 2009 Stopping background process QMNC Thu Oct 22 15:05:15 2009 Stopping background process CJQ0 Thu Oct 22 15:05:17 2009 Stopping … Continue reading →

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

ORA-600(17175)错误

Posted on 2012/05/31 by yangtingkun

又是一个导致实例崩溃的BUG。 数据库版本10.2.0.4 RAC for Hp-UX 11.31，在出现这个错误的同时还出现了ORA-601的错误： Wed DEC 1 01:57:55 2010 Errors IN file /u01/app/oracle/admin/orcl2/bdump/orcl21_pmon_3250.trc: ORA-00600: internal error code, arguments: [17175], [255], [], [], [], [], [], [] ORA-00601: cleanup LOCK conflict Wed DEC 1 01:57:57 2010 Trace dumping IS … Continue reading →

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

ORA-600(kccsbck_first)错误

Posted on 2012/05/29 by yangtingkun

客户Oracle10.2.0.4 RAC数据库出现ORA-600(kccsbck_first)错误。 详细错误信息为： Wed Oct 14 17:43:34 2009 ALTER DATABASE FORCE LOGGING Wed Oct 14 17:43:34 2009 ORA-12920 signalled during: ALTER DATABASE FORCE LOGGING… Wed Oct 14 17:43:42 2009 ALTER SYSTEM SET db_unique_name=’PRIMARY’ SCOPE=SPFILE; Wed Oct 14 17:44:01 2009 ALTER … Continue reading →

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

系统空间不足产生ORA-1错误

Posted on 2012/05/27 by yangtingkun

ORA-1错误代表唯一冲突，而空间不足时出现这个错误还是第一次碰到。 错误信息如下： Tue May 01 05:00:11 2012 Non critical error ORA-00001 caught while writing TO trace file "/home/oracle/base/diag/rdbms/orcl/orcl/trace/orcl_ora_31131.trc" Error message: Linux-x86_64 Error: 28: No SPACE LEFT ON device Additional information: 1 Writing TO the above trace file IS disabled FOR … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kkzisf3g.5)错误

Posted on 2012/05/25 by yangtingkun

这个错误是在物化视图刷新过程中产生的。 数据库版本为10.1.0.4，在刷新物化视图时出现这个错误： Fri Nov 5 01:00:03 2010 Errors IN file /oracle/admin/orcl/bdump/orcl_j002_254624.trc: ORA-00600: internal error code, arguments: [kkzisf3g.5], [], [], [], [], [], [], [] Fri Nov 5 01:00:04 2010 Errors IN file /oracle/admin/orcl/bdump/orcl_j002_254624.trc: ORA-00600: internal error code, arguments: [kkzisf3g.5], [], … Continue reading →

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