Getting ORA-44003 in the alert log. [ID 605025.1]  

--------------------------------------------------------------------------------
 Modified 15-JUL-2008     Type PROBLEM     Status MODERATED  

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

--------------------------------------------------------------------------------

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1.0
This problem can occur on any platform.

Symptoms
You could be getting many of the following errors in alert log :

ORA-12012: error on auto execute of job 9771
ORA-44003: invalid SQL name

They are usually generated by an Auto Advisor job.

The ORA-44003 can also be reproduced when you run the job explicitly :
SQL> execute dbms_scheduler.run_job('AUTO_SPACE_ADVISOR_JOB');
BEGIN dbms_scheduler.run_job('AUTO_SPACE_ADVISOR_JOB'); END;

*
ERROR at line 1:
ORA-44003: invalid SQL name
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1

Changes
Upgrade from an earlier release.
Cause
Unpublished Bug 4519934 AUTO_SPACE_ADVISOR_JOB can fail with ORA-44003
Information about the bug is in Note 4519934.8
Solution
1. The bug is fixed in 10.2.0.2 onwards.

OR

2. You can use the following workaround to stop the errors :

    SQL> execute dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB');

OR

3. You can apply one-off Patch 4519934 if available for your database version and platform.