Category Archives: BUG

Oracle bugs

ORA-7445(lxsCntChar)错误

Posted on 2012/09/23 by yangtingkun

使用正则表达式导致的错误。 错误信息为： Fri DEC 16 15:37:51 2011 Exception [TYPE: SIGSEGV, Invalid permissions FOR mapped object] [ADDR:0x2AFEA42A4000] [PC:0x9016222, lxsCntChar()+210] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/orcl/ods1/trace/orcl1_ora_12150.trc (incident=41375): ORA-07445: exception encountered: core dump [lxsCntChar()+210] [SIGSEGV] [ADDR:0x2AFEA42A4000] [PC:0x9016222] [Invalid permissions FOR mapped … Continue reading →

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

SCHEDULER调用XDB程序导致性能问题

Posted on 2012/09/22 by yangtingkun

客户数据库出现SCHEDULER后台作业频繁调用XDB包，导致系统性能受到影响，数据库版本为10.2.0.3。 导致性能问题的SQL为： BEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN NULL; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN NULL; END; END;BEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, … Continue reading →

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

ORA-600(kfgFinalize_2)错误

Posted on 2012/09/21 by yangtingkun

11.2.0.1的ASM出现ORA-600[kfgFinalize_2]错误。 错误信息为： Fri Jun 17 09:59:51 2011 NOTE: No asm libraries found IN the system * instance_number obtained FROM CSS = 2, checking FOR the existence OF node 0… * node 0 does NOT exist. instance_number = 2 Starting ORACLE … Continue reading →

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

ORA-600(KSFD_DECAIOPC)和ORA-600(kfioReapIO00)错误

Posted on 2012/09/20 by yangtingkun

由于共享磁盘问题导致的两个ORA-600错误。 客户的10.2.0.4 RAC for Linux X86-64，在告警日志中出现了大量的错误信息： Tue Apr 24 16:15:04 2012 Errors IN file /u01/admin/orcl/udump/orcl1_ora_10437.trc: ORA-00600: internal error code, arguments: [KSFD_DECAIOPC], [0xFC213CBF0], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [<0x9293a0>] [SIGSEGV] [Address NOT mapped TO object] … Continue reading →

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

ORA-7445(kghfrf)错误

Posted on 2012/09/19 by yangtingkun

又是一个EXADATA上的错误。 数据库版本为11.2.0.2 RAC，错误信息为： Tue DEC 06 10:34:33 2011 Exception [TYPE: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x908F8BC, kghfrf()+94] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_12085.trc (incident=42231): ORA-07445: exception encountered: core dump [kghfrf()+94] [SIGSEGV] [ADDR:0x0] [PC:0x908F8BC] [SI_KERNEL(general_protection)] [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_42231/orcl1_ora_12085_i42231.trc USE … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

11gr2出现ORA-29280错误

Posted on 2012/09/15 by yangtingkun

客户的11.2.0.3 RAC环境自动运行的JOB报错ORA-29280。 详细错误信息为： Sat Sep 15 05:59:59 2012 VKRM started WITH pid=54, OS id=32622 Sat Sep 15 06:00:09 2012 Errors IN file /opt/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j001_32634.trc: ORA-12012: error ON auto EXECUTE OF job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1" ORA-29280: invalid directory path ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436 … Continue reading →

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

ORA-7445(kkfipbr)错误

Posted on 2012/09/14 by yangtingkun

在客户的10.2.0.4 RAC for X86-64环境中碰到了这个错误。 错误信息为： Fri Apr 27 13:40:20 2012 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_1851.trc: ORA-07445: exception encountered: core dump [kkfipbr()+8] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] []Fri Apr 27 13:40:20 2012 Errors in file /opt/app/oracle/admin/ora/udump/ora1_ora_1851.trc: ORA-07445: exception encountered: … Continue reading →

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

ORA-7445(opitca)错误

Posted on 2012/09/13 by yangtingkun

10.2.0.4 RAC环境出现ORA-7445[opitca]错误。 错误信息如下： Wed Oct 19 17:50:41 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_26638.trc: ORA-07445: exception encountered: core dump [opitca()+4618] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Wed Oct 19 17:50:42 2011 Trace dumping IS performing id=[cdmp_20111019175042] Wed Oct 19 … Continue reading →

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

ORA-7445(_intel_fast_memcpy.A)错误

Posted on 2012/09/12 by yangtingkun

在10.2.0.4 RAC for X86-64环境上出现了ORA-7445[_intel_fast_memcpy.A]的错误。 以前碰到过几次的memcpy有关的错误，但是这个错误函数是第一次碰到： Sat Apr 7 17:27:11 2012 Errors IN file /opt/app/oracle/admin/orcl/bdump/orcl1_j002_16579.trc: ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address NOT mapped TO object] [0x2A9734C000] [] []Sat Apr 7 17:27:11 2012 Errors in file /opt/app/oracle/admin/orcl/bdump/orcl1_j002_16579.trc: ORA-07445: exception encountered: … Continue reading →

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

ORA-7445(kqlSubheapPin)错误

Posted on 2012/09/11 by yangtingkun

Oracle 10.2.0.4 for X86-64数据库出现ORA-7445[kqlSubheapPin]错误。 错误信息为： Tue Jul 26 13:27:05 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: core dump [kqlSubheapPin()+84] [SIGSEGV] [Address NOT mapped TO object] [0x000000110] [] []Tue Jul 26 13:27:05 2011 Errors in file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: … Continue reading →

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