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

最新推荐文章于 2023-12-08 11:01:51 发布

转载最新推荐文章于 2023-12-08 11:01:51 发布 · 59 阅读

本文介绍了当使用不支持的参数时，Oracle数据库启动可能会遇到ORA-32004错误的情况。提供了确认当前初始化参数的方法及如何通过修改spfile或使用init.ora文件来解决这一问题的具体步骤。

如果在某个高一些的版本Oracle中使用了不再支持的参数，那么可能在开启数据库的时候会报错：

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  2087248 bytes
Variable Size             671090352 bytes
Database Buffers         2466250752 bytes
Redo Buffers               14688256 bytes
Database mounted.
Database opened.
SQL>

If you are using an spfile, values for this are given in v$spparamter, not v$parameter. You can confirm whatever initialization parameters are in effect at any given time by doing a 'show parameter parallel' to show what initialization parameter values are at that time for any parameter that has 'parallel' in it's name.

Anyway, to remedy the problem, even if parallel_server is not false, there is still an entry for it in the spfile, and that is why you are receiving the error. It is not serious, but to remove it you will have to recreate the spfile, or start using an init.ora text file instead. Use Step B from note 137483.1 to do this. You can create a pfile from the spfile, remove the parallel_server setting altogether from the pfile, then use the pfile to recreate the spfile.

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

转载于:http://blog.itpub.net/35489/viewspace-631374/