ORA-12012: error on auto execute of job 388947

此錯誤反覆出現:

Wed Sep 9 22:00:03 2009

Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_j001_12246.trc:

ORA-12012: error on auto execute of job 388947

ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid

ORA-06512: at "SYS.PRVT_ADVISOR", line 1624

ORA-06512: at "SYS.DBMS_ADVISOR", line 186

ORA-06512: at "SYS.DBMS_SPACE", line 1344

ORA-06512: at "SYS.DBMS_SPACE", line 1560

查metalink,提sr,oracle顧問解決辦法如下:

CAUSE JUSTIFICATION
====================
Article-ID: Note 343795.1
Title: Auto Space Advisor For Tablespaces Fails ORA-20000


.
PROPOSED SOLUTION(S)
======================

Bug 4707226 is fixed in 10.2.0.3 and release 11.0.

Workaround:
1] Check the tablespaces in DBA_AUTO_SEGADV_CTL and compare with DBA_TABLESPACES to determin
e which tablespace has been dropped

2] Recreate the tablespace temporarily
sql> create tablespace datafile '' size 100k;

3] Run the space advisor
sql> exec dbms_space.auto_space_advisor_job_proc;

4] Drop the tablespace again
sql> drop tablespace ;


The dbms_space.auto_space_advisor_job_proc will continue to work after the tablespace is dropped.


Bug 4707226 has been backported to release 10.2.0.1 and 10.2.0.2 on some platforms.

Please check MetaLink for Patch 4707226.

[@more@]