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

数据库启动报错 ORA-32004

SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 24 23:14:44 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


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

Total System Global Area 1.3462E+10 bytes
Fixed Size                  2265984 bytes
Variable Size            3087010944 bytes
Database Buffers         1.0335E+10 bytes
Redo Buffers               38014976 bytes
SQL>

查找原因：

# tail -300  /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log | grep WARNING:
WARNING: The background_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the background_dump_dest parameter from the init.ora file.
WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data
WARNING: The new location for the background logs and traces is /u01/app/oracle/diag/rdbms/main/orcl/trace
WARNING: The user_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the user_dump_dest parameter from the init.ora file.
WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data
WARNING: The new location for the user logs and traces is /u01/app/oracle/diag/rdbms/main/orcl/trace

解决：

sqlplus / as sysdba

alter system reset background_dump_dest;
alter system reset diagnostic_dest;
alter system reset user_dump_dest;
shutdown immediate;
startup nomount;