ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
来源:互联网 发布:时时彩后一做号软件 编辑:程序博客网 时间:2024/04/30 01:13
一.版本信息
操作系统版本:
AIX 6100
数据库版本:
11.2.0.3(psu5)
二.错误描述
在alert 日志中发现如下报错
Sun Sep 28 15:00:22 2014Errors in file /oracle/app/oracle/diag/rdbms/xxx/xxx/trace/xxx2_j000_8519814.trc:ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"ORA-06502: PL/SQL: numeric or value errorORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073ORA-06512: at line 1
trace文件中信息同alert日志文件中报错类似
SQL> select log_date,status from dba_scheduler_job_run_details where job_name='BSLN_MAINTAIN_STATS_JOB' order by log_date desc;LOG_DATE STATUS--------------------------------------------------------------------------- ------------------------------28-SEP-14 03.00.22.110836 PM +08:00 FAILED21-SEP-14 03.00.20.124075 PM +08:00 FAILED14-SEP-14 03.00.20.780679 PM +08:00 FAILED07-SEP-14 03.00.24.276810 PM +08:00 FAILED31-AUG-14 03.00.02.057835 PM +08:00 FAILED
#通过dba_scheduler_job_run_details视图我们可以看到在alert出现报错的时间有一条失败记录
三.问题原因及解决方案
通过MOS查到如下NOTE (Doc ID 1413756.1)
MOS给的解释是:
As in a specific customer's situation, the issue can occur when a Database is created with a template from the old database or created as a clone from another database. The existing records in table "DBSNMP.BSLN_BASELINES" conflict with new baseline information inserted in the cloned database, thereby containing inconsistent information.
#如果你的数据库是通过模板创建,或者是克隆的,那么这个错误就可能好发生。因为原数据库中"DBSNMP.BSLN_BASELINES" 表的记录可能会同新插入数据冲突。
MOS给出的解决方案是:
This issue is fixed in 11.2.0.4.
For 11.2.0.2 and 11.2.0.3, please apply Patch 10110625 (if available for your platform and database version).
临时解决方案:
As a workaround, the DBSNMP user can be dropped and re-created using the standard scripts.
Ensure you have Backed up your database.
-- Login as sys user. SQL> sqlplus / as sysdba -- From the sqlplus execute the following: -- Drop the DBSNMP user by executing catnsnmp.sql script. SQL> @$ORACLE_HOME/rdbms/admin/catnsnmp.sql -- Create the DBSNMP user by executing catsnmp.sql SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql
##详细情况请查看 "Doc ID 1413756.1"
四. 解决过程
因为暂时没有条件给现网数据库打补丁,所以决定先采用临时解决方案进行处理。
但是在重建执行@$ORACLE_HOME/rdbms/admin/catsnmp.sql命令重建DBSNMP时报如下错误:
Package body created.Package body created.declare*ERROR at line 1:ORA-04068: existing state of packages has been discardedORA-04061: existing state of package "DBSNMP.BSLN" has been invalidatedORA-04065: not executed, altered or dropped package "DBSNMP.BSLN"ORA-06508: PL/SQL: could not find program unit being called: "DBSNMP.BSLN"ORA-06512: at line 18PL/SQL procedure successfully completed.
发生该错误的具体原因,及解决方案将在我的另一篇博客中详细解释。博客连接如下:
http://blog.csdn.net/shaochenshuo/article/details/39669273
- ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
- ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
- ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
- ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-01950: no privileges on
- oracle-ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_%
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_3"
- ORA-12012: error on auto execute of job "ORACLE_OCM
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"
- "ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And "ORA-29280: invalid dir
- ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1 ORA-29280: invalid directory
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1" 错误处理
- ORA-12012: error on auto execute of job “ORACLE_OCM"."MGMT_CONFIG_JOB_2_1”
- ORA-12012: error on auto execute of job;PLS-00306: wrong number or types ofarguments in call to
- ORA- 12012 : err or on aut o execu te of job ORACLE_OCM. MGMT_CONFIG_JOB_2_1 ORA-29280: inval
- crontab - auto execute schedule on unix/linux
- Dataguard Error 1017 ORA-16191 sys lock
- 谷歌浏览器开发工具使用教程
- 有关C#+ASP.NET中用户控件(webusercontrol)使用问题2则
- 数据挖掘-关联分析频繁模式挖掘Apriori、FP-Growth及Eclat算法的JAVA及C++实现
- Linux基础学习(二)配置yum源以及硬盘分区管理
- linux 系统编程-学习笔记2-文件I/O-open-read
- ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
- json数组对象和对象数组详细介绍
- 基于RBAC的Easyui树形权限菜单的实现原理
- struts2中的constant配置详解
- 黑马程序员——MAC系统快捷键汇总
- alias
- nohub 管理后台任务
- 不容错过的iOS 8的导航交互
- 腾讯笔试题回顾