alter日志中报了如下错误

Errors in file /oracle/app/oracle/admin/hbtms/bdump/hbtms_j000_889114.trc:

ORA-12012: error on auto execute of job 8887

ORA-44003: invalid SQL name

查询trace文件

/oracle/app/oracle/admin/hbtms/bdump/hbtms_j000_889114.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/app/oracle/product/10.2

System name:    AIX

Node name:      bill570a

Release:        3

Version:        5

Machine:        00C3F2DB4C00

Instance name: hbtms

Redo thread mounted by this instance: 1

Oracle process number: 39

Unix process pid: 889114, image: oracle@bill570a (J000)

*** ACTION NAMEAUTO_SPACE_ADVISOR_JOB) 2009-10-05 22:09:24.149

*** MODULE NAMEDBMS_SCHEDULER) 2009-10-05 22:09:24.149

*** SERVICE NAMESYS$USERS) 2009-10-05 22:09:24.149

*** SESSION ID1150.11514) 2009-10-05 22:09:24.149

*** 2009-10-05 22:09:24.149

ORA-12012: error on auto execute of job 8887

ORA-44003: invalid SQL name

可以知道是自动的这个查询表空间的job报的错

然后查询

Select * from dba_objects where object_name =’ AUTO_SPACE_ADVISOR_JOB’

查出状态有效。

Select* from dba_scheduler_jobs

Where job_name=’ AUTO_SPACE_ADVISOR_JOB’

查询一下数据库版本

Select * from v$version;(可以看出数据库10.2.0.1的)

网上查出这是一个bug

这个是10201的BUG
处理方法有3种:
1、升级
2、打PATCH4519934
3、禁止这个JOB
execute dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB');

Subject: Getting ORA-44003 in the alert log.
  Doc ID: 605025.1 Type:  PROBLEM
  Modified Date:  15-JUL-2008 Status:  MODERATED

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.

References
Note 4519934.8 - Bug 4519934 - AUTO_SPACE_ADVISOR_JOB can fail with ORA-44003


Subject: Bug 4519934 - AUTO_SPACE_ADVISOR_JOB can fail with ORA-44003
  Doc ID: 4519934.8 Type:  PATCH
  Modified Date:  24-SEP-2008 Status:  PUBLISHED

Description
AUTO_SPACE_ADVISOR_JOB can fail with ORA-44003 "invalid SQL name"
if the segment names contain unusual characters.
eg: segment names like '%~%'