Tag Archives: ORA-12012

ORA-600(ktspfnsb-1)错误

Posted on 2012/11/15 by yangtingkun

Exadata环境在收集统计信息时出现这个错误。 客户数据库11.2.0.2 RAC on Exadata在收集统计信息是出现的错误： Sun Feb 05 22:22:44 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc (incident=255085): ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_255085/orcl2_j002_21084_i255085.trc Sun Feb 05 22:22:56 … 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-27468错误

Posted on 2012/07/02 by yangtingkun

客户10.2.0.4环境告警日志出现ORA-27468错误。 详细错误信息为： Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl1_j000_18724.trc: ORA-12012: error ON auto EXECUTE OF job 42791 ORA-27468: "EXFSYS.RLM$EVTCLEANUP" IS locked BY another processErrors in file /u01/app/oracle/admin/orcl/bdump/orcl1_j000_18724.trc: ORA-12012: error on auto execute of job 42791 ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process 导致这个错误的原因在于升级时没有执行catupgrd.sql，而是执行了建库的部分脚本如catalog.sql和catproc.sql，这导致只有CATALOG视图和系统的PACKAGE以及TYPE的版本更新到10.2.0.4，而其他数据库中组件的版本并没有升级，仍然是10.2.0.1。 … Continue reading →

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

DBSNMP用户的BSLN_INTERNAL出现ORA-6502错误

Posted on 2011/09/28 by yangtingkun

11.2.0.2环境的数据库，出现了ORA-12012和ORA-6502错误。 在alert文件中发现了这个错误，详细错误信息如下： 2011-09-04 00:00:01.014000 +08:00 Errors IN file /u01/app/oracle/diag/rdbms/fhacdb1/fhacdb1/trace/fhacdb1_j000_13709.trc: ORA-12012: error ON auto EXECUTE OF job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-06502: PL/SQL: NUMERIC OR VALUE error ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 ORA-06512: at line 12011-09-04 00:00:01.014000 +08:00 Errors in file /u01/app/oracle/diag/rdbms/fhacdb1/fhacdb1/trace/fhacdb1_j000_13709.trc: ORA-12012: error … Continue reading →

Posted in BUG | Tagged , , | 1 Comment