ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

最新推荐文章于 2026-07-13 10:08:54 发布

原创最新推荐文章于 2026-07-13 10:08:54 发布 · 936 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

ORA-Error

Oracle 11G版本已不再支持一些旧的参数,如果设置的话会报ORA-32004错误, 通过这个命令可以还原参数设置'alter system reset parameter_name scope=spfile;'，执行后重启库生效。

如设置旧的参数后，还原 “standby_archive_dest”参数设置:

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SYS#ora11g> show parameter standby_archive_dest;

NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
standby_archive_dest string ?/dbs/arch

SYS#ora11g> alter system set standby_archive_dest='/orachivelog' scope=spfile;

SYS#ora11g> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS#ora11g>
SYS#ora11g> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 368263168 bytes
Fixed Size                     1336596 bytes
Variable Size                 289409772 bytes
Database Buffers           71303168 bytes
Redo Buffers                 6213632 bytes
Database mounted.
Database opened.

SYS#ora11g>alter system reset standby_archive_dest scope=spfile;
SYS#ora11g> shut immediate;
SYS#ora11g> startup open;
ORACLE instance started.
Total System Global Area 368263168 bytes
Fixed Size                      1336596 bytes
Variable Size                289409772 bytes
Database Buffers           71303168 bytes
Redo Buffers                 6213632 bytes
Database mounted.
Database opened.

=================================================================================

QQ: 164798858@qq.com
Sina: weibo.com/kaijunfeng
Yahoo: fffygapl@yahoo.com.cn