ORA-32004

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance 
ORACLE instance started.  
在create spfile from memory后，spfile中会生成2个废弃的参数，将2个参数reset即可： 
alter system reset background_dump_dest  scope=spfile; 
alter system reset user_dump_dest   scope=spfile; 

SQL>  select value from v$diag_info where name ='Diag Alert'; 

VALUE 
-------------------------------------------------------------------------------- 
/oracle/diag/rdbms/orasql/orasql/alert

alert中发现如下： 

Deprecated system parameters with specified values: 
  background_dump_dest     
  user_dump_dest   

SQL> show parameter _dump_dest 

NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
background_dump_dest                 string      /oracle/diag/rdbms/orasql/oras 
                                                 ql/trace 
core_dump_dest                       string      /oracle/diag/rdbms/orasql/oras 
                                                 ql/cdump 
user_dump_dest                       string      /oracle/diag/rdbms/orasql/oras 
                                                 ql/trace 
SQL> alter system reset background_dump_dest  scope=spfile; 

System altered. 

SQL> alter system reset user_dump_dest   scope=spfile; 

System altered. 

SQL> show parameter _dump_dest 

NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
background_dump_dest                 string      /oracle/diag/rdbms/orasql/oras 
                                                 ql/trace 
core_dump_dest                       string      /oracle/diag/rdbms/orasql/oras 
                                                 ql/cdump 
user_dump_dest                       string      /oracle/diag/rdbms/orasql/oras 
                                                 ql/trace 
SQL> startup force 
ORACLE instance started. 

Total System Global Area  627732480 bytes 
Fixed Size                  1366444 bytes 
Variable Size             469763668 bytes 
Database Buffers          146800640 bytes 
Redo Buffers                9801728 bytes 
Database mounted. 
Database opened.

查看弃用的参数 

SQL>  select name from v$parameter where isdeprecated = 'TRUE';   

NAME 
-------------------------------------------------------------------------------- 
lock_name_space 
instance_groups 
resource_manager_cpu_allocation 
active_instance_count 
buffer_pool_keep 
buffer_pool_recycle 
log_archive_start 
standby_archive_dest 
log_archive_local_first 
parallel_server 
parallel_server_instances 
fast_start_io_target 
serial_reuse 
max_enabled_roles 
remote_os_authent 
global_context_pool_size 
cursor_space_for_time 
plsql_v2_compatibility 
plsql_debug 
background_dump_dest 
user_dump_dest 
commit_write 
sql_trace 
parallel_automatic_tuning 
parallel_io_cap_enabled 

25 rows selected.