ORA-06512: at "DBSNMP.BSLN_INTERNAL"

收到报警邮件
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:

-- Drop the BSNMP 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

2，如果不需要此功能，可以禁止

3，此错误对数据库影响不大，报错一般不会很频繁，可以忽略