Error will Looks Like this :

Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_1781806.trc:
ORA-12012: error on auto execute of job 23122
ORA-06550: line 1, column 780:
PLS-00201: identifier ‘DBSNMP.BSLN_INTERNAL’ must be declared

Solution :

First Check if its Failed Or not :

select log_date,status from dba_scheduler_job_run_details  where job_name=’BSLN_MAINTAIN_STATS_JOB’
order by log_date desc;

LOG_DATE                                                                    STATUS
———————————————————————— ————
08-JUL-12 PM                                         FAILED
09-JUL-12 PM                                         FAILED
10-JUL-12 PM                                         FAILED
11-JU:L-12 PM                                        FAILED
12-DEC-12 PM                                        FAILED

 to Fix it Run

SQL> @?/rdbms/admin/catnsnmp.sql
SQL> @?/rdbms/admin/catsnmp.sql

Done & Enjoy

Osama Mustafa

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.