[错误处理]ORA-12012: error on auto execute of job ,ORA-06512: at "DBSNMP.BSLN_INTERNAL", line

oracle版本:11.1.0.6.0

偶尔出现以下错误

Sun Aug 26 15:00:08 2012
Errors in file /var/u01/app/diag/rdbms/testdb/down/trace/down_j001_8151.trc:
ORA-12012: error on auto execute of job 11689
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
Sun Aug 26 16:00:52 2012

查找MOS，通过这篇文章找到了解决办法。文章中指明：dbsnmp用户缺少执行sys.dbms_job权限造成错误。
Ora-06508: Pl/Sql: Could Not Find Program Unit Being Called: "DBSNMP.BSLN_INTERNAL" [ID 1323597.1]


解决办法：
1.查看dbsnmp是否拥有执行sys.dbms_job的权限，发现没有这个权限

SQL> select * from dba_tab_privs where table_name='DBMS_JOB';

GRANTEE    OWNER      TABLE_NAME     GRANTOR    PRIVILEGE  GRANTABLE  HIERARCHY
---------- ---------- -------------- ---------- ---------- ---------- ----------
PUBLIC       SYS          DBMS_JOB         SYS    EXECUTE    YES          NO
EXFSYS       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO
SYSMAN       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO
OWBSYS       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO

2.授予dbsnmp用户执行sys.dbms_job权限

GRANT EXECUTE ON sys.dbms_job to DBSNMP;

3.确认

SQL> select * from dba_tab_privs where table_name='DBMS_JOB';

GRANTEE    OWNER      TABLE_NAME     GRANTOR    PRIVILEGE  GRANTABLE  HIERARCHY
---------- ---------- -------------- ---------- ---------- ---------- ----------
PUBLIC       SYS          DBMS_JOB         SYS    EXECUTE    YES          NO
DBSNMP       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO
EXFSYS       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO
SYSMAN       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO
OWBSYS       SYS          DBMS_JOB         SYS    EXECUTE    NO          NO