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

CPU资源紧张，数据库登陆不进去，查看告警日志出现如下错误：

Mon Jul 9 22:00:02 2012

Errors in file /u01/app/oracle/admin/szcargo/bdump/szcargo_j000_30923.trc:

ORA-12012: error on auto execute of job 8887

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 1338

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

查询为Oracle Bug，重启操作系统，重启数据库

SQL> SELECT TABLESPACE_NAME,STATUS FROM DBA_AUTO_SEGADV_CTL WHERE TABLESPACE_NAME NOT IN(SELECT TABLESPACE_NAME FROM DBA_TABLESPACES);

TABLESPACE_NAME 　STATUS

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

PLUS_DATA 　　　　COMPLETE

·CREATE TABLESPACE PLUS_DATA

SQL>CREATE TABLESPACE PLUS_DATA DATAFILE '/TMP/LCMC_MES.DBF' SIZE 100K;

·RUN THE SPACE ADVISOR

SQL>EXEC DBMS_SPACE.AUTO_SPACE_ADVISOR_JOB_PROC;

·DROP THE TABLESPACE AGAIN

SQL>DROP TABLESPACE PLUS_DATA ;

按上述操作完成后即可解决这个问题。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24389441/viewspace-1058797/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24389441/viewspace-1058797/