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;
[code]SQL> select value from v$diag_info where name ='Diag Alert';

VALUE
--------------------------------------------------------------------------------
/oracle/diag/rdbms/orasql/orasql/alert[/code]
alert中发现如下：
[code]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. [/code]
查看弃用的参数
[code]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. [/code]