-
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
Monthly Archives: January 2012
ORA-600(kohfrm771)错误
一个空间数据库相关的bug。 错误信息如下： Thu Jan 6 08:24:16 2011 Errors IN file /oracle/admin/oasisdb/udump/oasisdb1_ora_5597.trc: ORA-00600: 内部错误代码, 参数: [kohfrm771], [], [], [], [], [], [], [] ORA-13234: 无法访问 R-tree-INDEX 表 [MDRT TABLE] ORA-29400: 数据插件错误Error – OCI_NODATAThu Jan 6 08:24:16 2011 Errors in file /oracle/admin/oasisdb/udump/oasisdb1_ora_5597.trc: … Continue reading
ORA-600(prsHintQbLevel-1)错误
客户数据库出现ORA-600(prsHintQbLevel-1)错误信息。 错误信息如下： Thu Jun 10 13:05:09 2010 Errors IN file /oracle/admin/oasisdb/udump/oasisdb1_ora_13644.trc: ORA-00600: internal error code, arguments: [prsHintQbLevel-1], [316], [], [], [], [], [], [] Thu Jun 10 13:05:11 2010 Trace dumping IS performing id=[cdmp_20100610130511]Thu Jun 10 13:05:09 2010 Errors in … Continue reading
ORA-600(20084)错误
数据库告警日志中出现错误ORA-600(20084)。 错误信息如下： Mon Aug 31 14:56:51 2009 Errors IN file /oracle/admin/oasisdb/udump/oasisdb1_ora_4787.trc: ORA-00600: 内部错误代码, 参数: [20084], [18125507], [60], [18125507], [60], [], [], []Mon Aug 31 14:56:51 2009 Errors in file /oracle/admin/oasisdb/udump/oasisdb1_ora_4787.trc: ORA-00600: 内部错误代码, 参数: [20084], [18125507], [60], [18125507], [60], [], [], … Continue reading
安装11g RAC出现PRCT-1011错误
安装RAC数据库出现PRCT-1011错误。 详细错误信息为： An internal error occurred WITHIN cluster verification framework Unable TO obtain network interface list FROM Oracle ClusterwarePRCT-1011: Failed TO run “oifcfg”. Detailed error: NULLAn internal error occurred within cluster verification framework Unable to obtain network interface list from … Continue reading
ORA-600(13030)错误
在ITPUB上看到的一个UPDATE RETURN引发的ORA-600错误。 告警日志中错误如下： Mon Jan 16 09:50:13 2012 Errors IN file /DATA/dir1/app/oracle/admin/moyzkf1/udump/moyzkf1_ora_27801.trc: ORA-00600: internal error code, arguments: [13030], [1], [], [], [], [], [], []Mon Jan 16 09:50:13 2012 Errors in file /data/dir1/app/oracle/admin/moyzkf1/udump/moyzkf1_ora_27801.trc: ORA-00600: internal error code, arguments: [13030], [1], … Continue reading
收集统计信息报错ORA-1422
10.2.0.4环境执行DBMS_STATS包时出现ORA-1422错误。 详细错误信息为： SQL> EXECUTE dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’) BEGIN dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’); END; ORA-01422: 实际返回的行数超出请求的行数 ORA-06512: 在 "SYS.DBMS_STATS", line 13437 ORA-06512: 在 "SYS.DBMS_STATS", line 13457 ORA-06512: 在 line 2SQL> execute dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’) begin dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’); … Continue reading
ORA-600(2141)错误
客户数据库在将STANDBY数据库启用为主库时出现了这个错误。 错误信息为： Thu Jan 12 08:57:50 2012 Errors IN file /oracle/admin/qtsys/udump/qtsys2_ora_21561380.trc: ORA-00600: internal error code, arguments: [2141], [3099815372], [0], [], [], [], [], [] Thu Jan 12 08:57:50 2012 Errors IN file /oracle/admin/qtsys/udump/qtsys2_ora_21561380.trc: ORA-00600: internal error code, arguments: [2141], [3099815372], … Continue reading
ORA-600(kgh_heap_sizes:ds)和ORA-600(kghGetHpSz1)错误
在客户10203数据库中发现多个ORA-600和ORA-7445错误。 详细错误信息如下： Tue DEC 27 11:13:55 2011 Errors IN file /oracle/admin/htzback/udump/htzback_ora_22492.trc: ORA-00600: 内部错误代码, 参数: [kgh_heap_sizes:ds], [0x2B902679E3F8], [], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [kghGetHpSz1], [0x2B902679F868], [], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [kghstack_free2], [], [], [], … Continue reading
Posted in BUG
Tagged kghGetHpSz1, kghstack_free2, kgh_heap_sizes:ds, ORA-600, ORA-602, ORA-7445, pfrtcs, _intel_fast_memcpy.A
Leave a comment
告警日志出现分布式事务缺少DTP服务信息
客户的RAC环境中出现这个告警信息。 详细信息如下： Thu DEC 23 09:23:15 2011 Running Distributed Transactions IN RAC WITHOUT DTP service.Thu Dec 23 09:23:15 2011 Running Distributed Transactions in RAC without DTP service. 查询MOS发现，对于10.2版本的数据库，如果连接RAC环境，且执行分布式事务，那么应该启用DTP服务。 从告警日志的其他部分，可以发现数据库确实使用了分布式事务，因为已经出现了分布式事务的错误： Tue DEC 23 09:25:14 2011 DISTRIB TRAN 44444444.99A137F01FBF14AACDCA8A9D3C8FED5800000000 IS LOCAL tran … Continue reading
由于DBTIME时间太短导致AWR出现告警信息
一个客户的RAC环境的AWR，由于DB TIME时间太短，导致出现告警信息。 这是一个10.2.0.5 RAC for Linux X86环境，由于全部应用都连接到一个节点上，因此另一个节点出现这个告警。 在AWR报告中的正文开始之前的部分，有下面的告警信息： WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid. 虽然以前也碰到过节点很闲的情况，但是真没有碰到过负载这么轻的系统： Snap Id Snap Time … Continue reading