数据库启动报错 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;