Tag Archives: ORA-600

ORA-600(6928)错误

Posted on 2011/11/01 by yangtingkun

客户的测试环境碰到了这个错误。 告警日志中错误如下： Sat Oct 15 01:21:40 GMT+08:00 2011ALTER SYSTEM SET service_names=’SYS$SYS.KUPC$S_1_20111015004332.DB’,’db’ SCOPE=MEMORY SID=’db1′; Sat Oct 15 01:21:40 GMT+08:00 2011ALTER SYSTEM SET service_names=’db’ SCOPE=MEMORY SID=’db1′; Sat Oct 15 01:39:03 GMT+08:00 2011Errors IN file /u01/app/oracle/admin/db/udump/db11_ora_4325842.trc: ORA-00600: 内部错误代码, 参数: [6928], [886], [], [], … Continue reading →

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

ORA-600(ktecgeb-2)错误

Posted on 2011/10/30 by yangtingkun

还是一个ORA-600错误，这个错误出现在10.2环境中。 客户的DATA GUARD环境中的物理备库，由于要进行测试，因此设置了FLASHBACK ON，创建了恢复点，然后激活成主库并打开，准备进行测试，但是发现在后台告警日志中出现了这个错误，详细的错误信息如下： Completed: ALTER DATABASE OPEN Wed Oct 26 22:08:27 2011 Errors IN file /oracle/admin/standdb/bdump/standdb_j003_446902.trc: ORA-00600: internal error code, arguments: [ktecgeb-2], [788585233], [0], [], [], [], [], [] Wed Oct 26 22:08:33 2011 Errors IN file /oracle/admin/standdb/bdump/standdb_j003_446902.trc: ORA-00600: … Continue reading →

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

ORA-600(kjcsombd:2)错误

Posted on 2011/10/29 by yangtingkun

又是一个9208 RAC上的错误，事实上这个错误和上一篇文章中描述的错误相关性很大，因为在上一篇节点关闭并报错的同时，这个节点出现了这个ORA-600错误。 ORA-600(kjccgmb:1)错误：https://yangtingkun.net/?p=245 在当前节点上的详细错误信息为： Thu Oct 13 18:13:10 2011 IPC Send timeout detected. Sender ospid 1228900 Thu Oct 13 18:13:12 2011 Communications reconfiguration: instance 1 Thu Oct 13 18:13:12 2011 Trace dumping IS performing id=[cdmp_20111013181312] Thu Oct 13 18:13:17 2011 … Continue reading →

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

ORA-600(kjccgmb:1)错误

Posted on 2011/10/28 by yangtingkun

在客户的9208 RAC环境中碰到了这个错误。 相信信息如下： Thu Oct 13 18:07:25 2011 Shutting down instance: further logons disabled Shutting down instance (immediate) License high water mark = 369 Thu Oct 13 18:07:45 2011 ALTER DATABASE CLOSE NORMAL Thu Oct 13 18:07:45 2011 SMON: disabling … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(729)错误

Posted on 2011/10/19 by yangtingkun

客户数据库出现ORA-600[729]错误。 详细信息如下： Sun Oct 16 04:31:31 2011 Errors IN file /u01/app/oracle/admin/db1/udump/db1_ora_6459722.trc: ORA-00600: internal error code, arguments: [729], [360], [SPACE leak], [], [], [], [], []Sun Oct 16 04:31:31 2011 Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_6459722.trc: ORA-00600: internal error code, arguments: [729], [360], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(krfg_first_barrier1)错误

Posted on 2011/10/18 by yangtingkun

客户在打开FLASHBACK的时候碰到了这个错误。 详细的错误如下： Tue Oct 18 10:55:02 2011 ALTER DATABASE MOUNT Tue Oct 18 10:55:06 2011 Setting recovery target incarnation TO 1 Tue Oct 18 10:55:06 2011 Successful mount OF redo thread 1, WITH mount id 830459142 Tue Oct 18 10:55:06 … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(krd_check_slaves_1)错误

Posted on 2011/10/16 by yangtingkun

物理STANDBY环境在进行恢复时碰到这个错误。 详细错误信息为： <pre lang=’SQL’>Sun Sep 11 06:59:47 2011 alter database recover datafile list clear Sun Sep 11 06:59:47 2011 Completed: alter database recover datafile list clear Sun Sep 11 06:59:47 2011 alter database recover datafile list 1 , 2 , … Continue reading →

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

ORA-600(kmgs_pre_process_request_6)错误

Posted on 2011/10/15 by yangtingkun

这个bug比较神奇，如果SGA设置为4G的整数倍，就会导致系统CRASH。以前听说过这个bug，这次还是第一次碰到。 详细的错误如下： <pre lang=’SQL’>Tue Oct 11 10:44:34 2011 Starting ORACLE instance (normal) Tue Oct 11 10:44:34 2011 Specified value of sga_max_size is too small, bumping to 12884901888 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Autotune of … Continue reading →

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

ORA-600(2103)错误

Posted on 2011/10/11 by yangtingkun

检查客户数据库告警日志时，发现ORA-600(2103)错误。 这是一个9208 RAC for Linux 32bit环境，当出现这个错误时，LGWR进程CRASH，导致数据库实例DOWN掉： Sun DEC 7 18:15:02 2008 Errors IN file /u01/product/admin/RAC/bdump/rac2_lgwr_491766.trc: ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], [] Sun DEC 7 18:15:03 2008 Errors IN file /u01/product/admin/RAC/bdump/rac2_lgwr_491766.trc: ORA-00600: internal error … Continue reading →

Posted in BUG | Tagged , | Leave a comment

ORA-600(ksxprqfre3)错误

Posted on 2011/10/10 by yangtingkun

客户的9208环境下的RAC出现这个错误。 详细错误信息为： Errors IN file /u01/product/admin/RAC/bdump/rac1_ora_708706.trc: ORA-00600: internal error code, arguments: [ksxprqfre3], [0x110320F28], [], [], [], [], [], [] ORA-10382: parallel query server interrupt (reset) . . . Errors IN file /u01/product/admin/RAC/bdump/rac1_p002_1212438.trc: ORA-00600: internal error code, arguments: [ksxprqfre3], [0x110319308], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment