Ora-06508: Pl/Sql: Could Not Find Program Unit Being Called: DBSNMP.BSLN_INTERNAL

You are seeing following errors in the database alert.log file:

ORA-12012: error on auto execute of job 41042 ORA-04063: package body "DBSNMP.BSLN_INTERNAL" has errors ORA-06508: PL/SQL: could not find program unit being called: "DBSNMP.BSLN_INTERNAL" ORA-06512: at line 1

or

Errors in file <trace file name>.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

Solution:

For security reasons, the privileges on DBMS_JOB package to public has been removed.

Verify:

select * from dba_tab_privs where table_name='DBMS_JOB'; GRANTEE      OWNER        TABLE_NAME   GRANTOR      PRIVILEGE    GRA HIE ------------ ------------ ------------ ------------ ------------ --- --- OWBSYS       SYS          DBMS_JOB     SYS          EXECUTE      NO  NO SYSMAN       SYS          DBMS_JOB     SYS          EXECUTE      NO  NO EXFSYS       SYS          DBMS_JOB     SYS          EXECUTE      NO  NO

Please grant explicit execute permissions on DBMS_JOB to DBSNMP user:

sqlplus / as sysdba GRANT EXECUTE ON sys.dbms_job to DBSNMP;

I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.