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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7419833/viewspace-628733/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7419833/viewspace-628733/