收到报警邮件
Sun Jan 12 00:00:04 2014
Errors in file /tol/app/oracle/admin/coredb/diag/rdbms/dg_115/coredb/trace/coredb_j000_16208.trc:
ORA-12012: error on auto execute of job 12696
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
查看一下trace文件
*** 2014-01-12 00:00:04.056
*** SESSION ID:(580.63318) 2014-01-12 00:00:04.056
*** CLIENT ID:() 2014-01-12 00:00:04.056
*** SERVICE NAME:(SYS$USERS) 2014-01-12 00:00:04.056
*** MODULE NAME:(DBMS_SCHEDULER) 2014-01-12 00:00:04.056
*** ACTION NAME:(BSLN_MAINTAIN_STATS_JOB) 2014-01-12 00:00:04.056
ORA-12012: error on auto execute of job 12696
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
~
发现trace文件跟alter日志都差不多,没有太多可用的信息
从上述的信息可以看出是DBSNMP用户下的BSLN_INTERNAL过程报错
这个用户是oracle内部用户,出现这种错误,感觉一般都是bug所致
检查发现,确实有个bug跟此错误有关,Bug 10110625: DBSNMP.BSLN_INTERNAL RECEIVES ORA-06502
解决方法:
1,可尝试重建DBSNMP
-- Login as sys user.
SQL> sqlplus / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql
Sun Jan 12 00:00:04 2014
Errors in file /tol/app/oracle/admin/coredb/diag/rdbms/dg_115/coredb/trace/coredb_j000_16208.trc:
ORA-12012: error on auto execute of job 12696
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
查看一下trace文件
*** 2014-01-12 00:00:04.056
*** SESSION ID:(580.63318) 2014-01-12 00:00:04.056
*** CLIENT ID:() 2014-01-12 00:00:04.056
*** SERVICE NAME:(SYS$USERS) 2014-01-12 00:00:04.056
*** MODULE NAME:(DBMS_SCHEDULER) 2014-01-12 00:00:04.056
*** ACTION NAME:(BSLN_MAINTAIN_STATS_JOB) 2014-01-12 00:00:04.056
ORA-12012: error on auto execute of job 12696
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
~
发现trace文件跟alter日志都差不多,没有太多可用的信息
从上述的信息可以看出是DBSNMP用户下的BSLN_INTERNAL过程报错
这个用户是oracle内部用户,出现这种错误,感觉一般都是bug所致
检查发现,确实有个bug跟此错误有关,Bug 10110625: DBSNMP.BSLN_INTERNAL RECEIVES ORA-06502
解决方法:
1,可尝试重建DBSNMP
-- Login as sys user.
SQL> sqlplus / as sysdba
-- From the sqlplus execute the following:
SQL> @$ORACLE_HOME/rdbms/admin/catnsnmp.sql
SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql
2,如果不需要此功能,可以禁止
3,此错误对数据库影响不大,报错一般不会很频繁,可以忽略
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23249684/viewspace-1155906/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23249684/viewspace-1155906/