客户数据库报如下错误：
Fri Feb 6 22:00:16 2009
Errors in file / oracle /admin/pnbrw/bdump/pnbrw2_j000_14187.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 1344
ORA-06512: at “SYS.DBMS_SPACE”, line 1560
Fri Feb 6 22:06:48 2009
在metalink上查了一下，发现是 oracle 的bug：4707226 - Appsst Srv 10g : Auto_Space_Advisor_Job Failed With Ora-20000，具体描述可参考Notes: 343795.1。
根据343795.1的描述，对比DBA_AUTO_SEGADV_CTL和DBA_TABLESPACES，发现一个tablespace有问题：
- sql>select tablespace_name,status
- from dba_auto_segadv_ctl
- where tablespace_name not in(select tablespace_name from dba_tablespaces);
- TABLESPACE_NAME STATUS
- ------------------------------------
- LCMC_MES_DAT BEING_PROCESSED
也就是说LCMC_MES_DAT表空间被删除了但auto_space_advisor_job_proc还在统计该tablespace的数据，于是报错。
解决方法：
1.打patch 4707226
2.如果不想打patch，可按如下步骤进行：
1).Recreate the tablespace temporarily
- sql>create tablespace LCMC_MES_DAT datafile '/tmp/lcmc_mes.dbf' size 100k;
2).Run the space advisor
- sql>exec dbms_space.auto_space_advisor_job_proc;
3).Drop the tablespace again
- sql>drop tablespace LCMC_MES_DAT;
这样auto_space_advisor_job_proc在LCMC_MES_DAT删除后就能继续运行。
No Comments
Be the first to comment on this entry.
Leave a comment
Fields in bold are required. Email addresses are never published or distributed.
Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.
Line breaks and paragraphs are automatically converted.
Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.