ORA-32004: obsolete and/or deprecated parameter(s) specified

原创

yanse 2011-04-14 22:35:40 博主文章分类：oracle ©著作权

文章标签 职场 SQL 休闲 ora-32004 文章分类 数据库

©著作权归作者所有：来自51CTO博客作者yanse的原创作品，请联系作者获取转载授权，否则将追究法律责任

启动数据库时，报如下错误：
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。

SQL> host oerr ora 32004

32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause: One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.

alert中：

Deprecated system parameters with specified values:
fast_start_io_target
End of deprecated system parameter listing

解决 1 通过alter system reset 恢复

2 在pfile中去掉该参数然后 create spfile from pfile