问题描述
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.
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。