on 06-18-2009 2:43 AM
Hi Experts
In my alert_<sid>.log, i found the following error.
ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2009-06-16 22:00:12.326
MODULE NAME:(DBMS_SCHEDULER) 2009-06-16 22:00:12.326
SERVICE NAME:(SYS$USERS) 2009-06-16 22:00:12.326
SESSION ID:(63.2575) 2009-06-16 22:00:12.326
2009-06-16 22:00:12.326
ORA-12012: error on auto execute of job 8889
ORA-44003: invalid SQL name
Please help me to resolve the issue
Thanks & Regards
Venkatesan J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
search SAP notes with this keyword and you'll find your answer rapidly:
AUTO_SPACE_ADVISOR_JOB
and you wil lfind SAP Note 974781 - Oracle database 10g: Internal maintenance jobs
Hi Venkat,
Check any Job running in background
select job_name,enabled from dba_scheduler_jobs;
U can disable .
SurendraJain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.