ORA-12012: error on auto execute of job 8887
Hi all,
I have a production db oracle 10g (10.2.0.1.0) on HP-Ux.
In my alertlog file, I am getting the ORA-12012: error on auto execute of job 8887 and ORA-44003: invalid SQL name error for the past few days. when i open the trace file in bdump, showing this message.
oracle/ora10g/oracle/product/10.2.0/db_1/admin/pcil/bdump/pcil_j000_10066.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/ora10g/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: pennadb
Release: B.11.23
Version: U
Machine: ia64
Instance name: pcil
Redo thread mounted by this instance: 1
Oracle process number: 50
Unix process pid: 10066, image: oracle@pennadb (J000)
*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2011-01-29 06:00:23.064
*** MODULE NAME:(DBMS_SCHEDULER) 2011-01-29 06:00:23.064
*** SERVICE NAME:(SYS$USERS) 2011-01-29 06:00:23.064
*** SESSION ID:(423.12606) 2011-01-29 06:00:23.064
*** 2011-01-29 06:00:23.064
ORA-12012: error on auto execute of job 8887
ORA-44003: invalid SQL name
can anyone please give me advice to rectify this problem.
thanks and regards.
Edited by: 785092 on Jan 28, 2011 10:08 PM