-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: ORA-600
ORA-600(kcbshlc_1)和ORA-7445(kggchk)错误
以前同时记录两个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
ORA-600(17271)错误
告警日志中发现了ORA-600(17271)错误。 详细错误信息为: Fri Mar 6 17:15:37 2009 Errors IN file /home/oracle/admin/ARIC/udump/aric_ora_28118.trc: ORA-00600: internal error code, arguments: [17271], [instantiation SPACE leak], [], [], [], [], [], [] ORA-03135: connection lost contactFri Mar 6 17:15:37 2009 Errors in file /home/oracle/admin/ARIC/udump/aric_ora_28118.trc: ORA-00600: internal … Continue reading
ORA-600(qerfxFetch_01)错误
在客户的9201数据库中,发现这个错误。 错误信息为: Wed Jul 29 09:23:32 2009 Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []Wed Jul 29 09:23:32 2009 Errors in file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], … Continue reading
ORA-600(5351)错误
在告警日志中发现了ORA-600(5351)错误,同时出现大量的There are 3 memory allocation errors for object-level stat错误。 详细的错误信息为: Tue Jun 22 12:00:09 2010 Thread 1 advanced TO log SEQUENCE 1522 CURRENT log# 3 seq# 1522 mem# 0: /dev/rredo03 There are 6 memory allocation errors FOR object-level stat IN … Continue reading
Posted in BUG
Tagged 5351, memory allocation errors, object-level, ORA-600, shared_pool, _OBJECT_STATISTICS
Leave a comment
ORA-600(kokegPinLob1)错误
客户10.2.0.5 Oracle for AIX系统中,出现了这个ORA-600错误。 其中错误信息为: Fri Nov 18 19:50:18 GMT+08:00 2011Errors IN file /oracle/admin/ccicwmix/udump/ccicwmix_ora_4915530.trc: ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []Fri Nov 18 19:50:18 GMT+08:00 2011Errors in file /oracle/admin/ccicwmix/udump/ccicwmix_ora_4915530.trc: ORA-00600: internal error code, arguments: … Continue reading
ORA-600(kgscLogOff-notempty)错误
客户的10.2.0.2环境在告警日志中出现这个错误。 错误信息为: Thu Oct 27 21:18:03 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_27896.trc: ORA-00600: internal error code, arguments: [kgscLogOff-notempty], [1], [], [], [], [], [], [] Thu Oct 27 21:18:05 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_27896.trc: ORA-00600: internal error code, arguments: [kgscLogOff-notempty], [1], … Continue reading
ORA-600(15160)错误
客户数据库中发现了这个错误。 在告警日志中错误如下: Wed Nov 2 11:13:17 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_9007.trc: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [] Wed Nov 2 11:13:36 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_9007.trc: ORA-00600: internal error code, arguments: [15160], [], … Continue reading
ORA-600(2037)错误
最近已经碰到多起客户数据库无法打开的情况,这就是其中一次。 这是一个10201 for Windows 64bit数据库,在一次掉电后,数据库无法启动,在后台告警日志中出现下列的错误: Mon Oct 31 00:00:28 2011 ALTER DATABASE OPEN Mon Oct 31 00:00:28 2011 Beginning crash recovery OF 1 threads parallel recovery started WITH 16 processes Mon Oct 31 00:00:28 2011 Started redo scan Mon Oct … Continue reading
Posted in BUG
Tagged 2037, DISTRIBUTE TRANSACTION, IMU, kcbs_dump_adv_state, ORA-600, ORA-7445
Leave a comment
ORA-600(kcrrupirfs.20)错误
在客户的数据库告警日志中发现这个错误。 错误信息如下: Thu Sep 29 14:29:26 2011 ALTER DATABASE force logging Thu Sep 29 14:29:26 2011 ALTER DATABASE FORCE LOGGING command IS waiting FOR existingdirect writes TO finish. This may take a long TIME. Completed: ALTER DATABASE force logging LAST_CHECK … Continue reading
Posted in BUG
Tagged DG_CONFIG, kcrrupirfs.20, LOG_ARCHIVE_CONFIG, LOG_ARCHIVE_DEST_N, LOG_ARCHIVE_DEST_STATE_N, ORA-600
Leave a comment
ORA-1251和ORA-600(kjccgmb:l)错误
客户的数据库出现了ORA-1251错误,进而引发了ORA-600(kjccgmb:l)错误。 数据库版本是9208 RAC for Linux X86-64。客户数据库一个数据文件突然不可用,被置为OFFLINE状态: ORA-01171: datafile 44 going offline due TO error advancing checkpoint ORA-01122: DATABASE file 44 failed verification CHECK ORA-01110: DATA file 44: ‘/dev/raw/raw77’ ORA-01251: UNKNOWN File Header Version READ FOR file NUMBER 44ORA-01171: datafile 44 … Continue reading