ORA-12012: error on auto execute of job 8913

最新推荐文章于 2022-02-28 10:36:39 发布

congbi4543

最新推荐文章于 2022-02-28 10:36:39 发布

阅读量251

点赞数

文章标签：数据库

这个问题我以前遇见过，不过没有仔细研究，今天多亏棉花帮助，要不然我还是无处下手。

[@more@]

alert：

Mon Aug 11 22:00:37 2008
Errors in file /oracle/app/oracle/admin/1/bdump/1_j000_3285088.trc:
ORA-12012: error on auto execute of job 8913
ORA-03211: The segment does not exist or is not in a valid state

trace：

Dump file /oracle/app/oracle/admin/1/bdump/1_j000_3285088.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options
ORACLE_HOME = /oracle/app/oracle/product/db10g
System name: AIX
Node name: sczfdb1
Release: 3
Version: 5
Machine: 00C04F0E4C00
Instance name: zfora01
Redo thread mounted by this instance: 1
Oracle process number: 319
Unix process pid: 3285088, image: oracle@1 (J000)

*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2008-08-11 22:00:37.873
*** MODULE NAME:(DBMS_SCHEDULER) 2008-08-11 22:00:37.873
*** SERVICE NAME:(SYS$USERS) 2008-08-11 22:00:37.873
*** SESSION ID:(1547.44541) 2008-08-11 22:00:37.873
*** 2008-08-11 22:00:37.873
ORA-12012: error on auto execute of job 8913
ORA-03211: The segment does not exist or is not in a valid state

select * from dba_jobs where job=8913

no rows selected.

以上是现象，不过我没有细致观察，其实从上面也能找到可用信息。

经过棉花指点，我查到

select job_name,failure_count from dba_scheduler_jobs

PURGE_LOG 0
FGR$AUTOPURGE_JOB 0
GATHER_STATS_JOB 0
AUTO_SPACE_ADVISOR_JOB 13

这个Scheduler job AUTO_SPACE_ADVISOR_JOB 失败了13次，

select * from dba_scheduler_job_log能查到具体信息，从时间上看与alert中报错时间相符，说明就是这个Scheduler job 失败了。如果仔细看，在trace也能发现，不过咱当时也不懂AUTO_SPACE_ADVISOR_JOB 是啥玩意。

首先，Scheduler job 是什么东东？我个人认为是oracle自己定义的job，比如可以看到GATHER_STATS_JOB ，这是10g后oracle自动收集统计信息的job

其次，为什么这个job会失败了，通过第二条信息去分析了。

ORA-03211: The segment does not exist or is not in a valid state

Cause: The segment specified in the DBMS_SPACE_ADMIN or DBMS_SPACE operation does not exist or is not in a state appropriate for this operation