ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-32004: obsolete and/or deprecated parameter(s) specified

原创 Linux操作系统 作者:stevenfox 时间:2011-12-10 11:21:54 0 删除 编辑
SQL> show parameter log_archive_start;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> alter system set log_archive_start=true scope=spfile;
系统已更改。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。
Total System Global Area  452984832 bytes
Fixed Size                  1979360 bytes
Variable Size             130026528 bytes
Database Buffers          314572800 bytes
Redo Buffers                6406144 bytes
数据库装载完毕。
数据库已经打开。
每次启动都会出现这个提示信息:ORA-32004: obsolete and/or deprecated parameter(s) specified
采用这个方法修改后重启是无法消除的,因为数据库还是默认该参数被启用过:
alter system set log_archive_start=false scope=spfile;
SQL> show parameter log_archive_start
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> alter system reset  log_archive_start scope=spfile;
alter system reset  log_archive_start scope=spfile
                                                 *
第 1 行出现错误:
ORA-00905: 缺失关键字
SQL> alter system reset  log_archive_start scope=spfile sid='*';
系统已更改。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area  452984832 bytes
Fixed Size                  1979360 bytes
Variable Size             130026528 bytes
Database Buffers          314572800 bytes
Redo Buffers                6406144 bytes
数据库装载完毕。
数据库已经打开。
那么,怎么查看那些参数被抛弃了呢:
SQL> set pagesize 2000
SQL> select name,description from v$parameter where isdeprecated='TRUE';
NAME                                                                             DESCRIPTION
-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lock_name_space                                                                  lock name space used for generating lock names for standby/clone database
buffer_pool_keep                                                                 Number of database blocks/latches in keep buffer pool
buffer_pool_recycle                                                              Number of database blocks/latches in recycle buffer pool
max_commit_propagation_delay                                                     Max age of new snapshot in .01 seconds
remote_archive_enable                                                            remote archival enable setting
log_archive_start                                                                start archival process on SGA initialization
parallel_server                                                                  if TRUE startup in parallel server mode
parallel_server_instances                                                        number of instances to use for sizing OPS SGA structures
fast_start_io_target                                                             Upper bound on recovery reads
logmnr_max_persistent_sessions                                                   maximum number of threads to mine
serial_reuse                                                                     reuse the frame. segments
max_enabled_roles                                                                max number of roles a user can have enabled
global_context_pool_size                                                         Global Application Context Pool Size in Bytes
plsql_compiler_flags                                                             PL/SQL compiler flags
sql_trace                                                                        enable SQL trace
parallel_automatic_tuning                                                        enable intelligent defaults for parallel execution parameters
drs_start                                                                        start DG Broker monitor (DMON process)
已选择17行。
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7298399/viewspace-713091/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-11-29

  • 博文量
    6
  • 访问量
    16711