ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
来源:互联网 发布:网络上课平台 编辑:程序博客网 时间:2024/05/19 18:00
数据库升级到11.2.0.3 后稳定运行了一年多了,alert日志中出现下述错误。
Sun Dec 16 15:00:07 2012 (这一天是周日)
Errors in file /opt/ora11g/diag/rdbms/ORACNBJ1/trace/ORACNBJ1_j001_6548.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 1
原因:
由于DBSNMP.BSLN_INTERNAL表中记录有冲突导致。
导致DBSNMP.BSLN_INTERNAL中记录有冲突的原因可能是用模板创建数据库,或克隆数据库导致的。
解决方法:
删除并重建DBSNMP USER。
由于平时很少用DBCONSOLE去维护数据库,所以就关掉了dbconsole。加上是生产库,也没有去重建DBSNMP USER.
在关掉dbconsole后,观察了两周这个错误并没有重现。
一些是MOS中给出的说明:
Cause:
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.
Solution
For 11.2.0.2, please apply generic Patch 10110625.
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
【MOS】ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" [ID 1413756.1]
- ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
- ORA-06512: at "DBSNMP.BSLN_INTERNAL"
- ORA-06512: at "DBSNMP.BSLN_INTERNAL",
- ORA-06512 DBSNMP.BSLN_INTERNAL
- DBSNMP用户的BSLN_INTERNAL出现ORA-12012和ORA-6502错误的解决方法
- 导数据时ORA-06512: at "SYS.DBMS_STATS", line 14015
- impdp错误 ORA-06512: at "SYS.UTL_FILE", line 536解决办法
- impdp 报ORA-06512: at "SYS.UTL_FILE", line 488 ORA-29283: invalid file operation
- User does not exist: ORA-06512: at "SYSMAN.MGMT_USER", line 122 ORA-06
- ORA-14501: object is not partitioned ORA-06512: at "KPI.P_KPI_M_2G_WASRATE_GRID", line 54
- oracle11g expdp报错 ORA-06512: at "SYS.UTL_FILE", line 536
- oracle11g expdp报错 ORA-06512: at "SYS.UTL_FILE", line 536
- Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been det
- Java程序异常 open cussors查询 ORA-01000: maximum open cursors exceeded ORA-06512: at "××××××", line ×× 通
- ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS"
- expdp ORA-39165: Schema DBSNMP was not found
- oracle语句报错 * ERROR at line 2: ORA-00923: FROM keyword not found where expected
- ora-06512:at "SYS.UTL_FILE" 问题总结
- Nagios远程监控软件的安装与配置详解(1)
- 二维码彩色广告招牌的切割制作问题(C#.net下对彩色二维码圆角样式及改进)
- 多类物体实时识别算法
- BSTR* 到 Char* 解决乱码
- win7.win8下wubi安装ubuntu 12.10详解
- ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
- 开发感想
- tomcat5.X与jdk1.4不兼容
- Nagios远程监控软件的安装与配置详解(2)
- 视频跟踪和行为分析算法
- firfox新标签页打开的设置与优化
- 分布式消息中间件 MetaQ 作者庄晓丹专访
- IOS给任意UIView截屏
- java书中小例子5