操作提示
SQL> create spfile from memory; File created. SQL> startup force;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started. Total System Global Area 830930944 bytes
Fixed Size 2232920 bytes
Variable Size 629149096 bytes
Database Buffers 197132288 bytes
Redo Buffers 2416640 bytes
Database mounted.
Database opened.
解决方案
查询日志，显示哪些参数被弃用。
Deprecated system parameters with specified values:
background_dump_dest
user_dump_dest
生成静态参数文件
SQL> create pfile from spfile; File created.
进行编辑
[oracle@henry dbs]$ vim initPROD1.ora
删除里面有弃用标记的两行参数
*.user_dump_dest='/u01/app/oracle/diag/rdbms/prod1/PROD1/trace'#Deprecate parameter
*.background_dump_dest='/u01/app/oracle/diag/rdbms/prod1/PROD1/trace'#Deprecate parameter
通过静态参数文件创建SPFILE
[oracle@henry dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue May 28 00:20:31 2019 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> create spfile from pfile; File created.
启动数据库（默认使用SPFILE），将不再有的ORA-32004错误。
SQL> startup
ORACLE instance started. Total System Global Area 830930944 bytes
Fixed Size 2232920 bytes
Variable Size 629149096 bytes
Database Buffers 197132288 bytes
Redo Buffers 2416640 bytes
Database mounted.
Database opened.
Versions 11.2, 12.1 Error: ORA-32004 obsolete or deprecated parameter(s) specified for %s instance
-------------------------------------------------------
Cause: Obsolete or deprecated parameters
for this instance type 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.
Versions 9.2, 10.1, 10.2, 11.1 Error: ORA-32004 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.