ITPub博客

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

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

原创 Linux操作系统 作者:马瑞琪 时间:2011-01-20 11:17:11 0 删除 编辑

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

接下来看查看alert:

Starting up ORACLE RDBMS Version: 10.1.0.3.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 50331648
  __large_pool_size        = 4194304
  __java_pool_size         = 8388608
  sga_target               = 167772160
  control_files            = /u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl, /u01/app/oracle/oradata/orcl/control03.ctl
  db_block_size            = 8192
  __db_cache_size          = 100663296
  db_cache_advice          = OFF
  compatible               = 10.1.0.2.0
  log_archive_start        = TRUE
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /u01/app/oracle/flash_recovery_area/
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  background_dump_dest     = /u01/app/oracle/admin/orcl/bdump
  user_dump_dest           = /u01/app/oracle/admin/orcl/udump
  core_dump_dest           = /u01/app/oracle/admin/orcl/cdump
  audit_trail              = FALSE
  db_name                  = orcl
  open_cursors             = 300
  pga_aggregate_target     = 16777216
Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing
PMON started with pid=2, OS id=13659
MMAN started with pid=3, OS id=13661
DBW0 started with pid=4, OS id=13663
LGWR started with pid=5, OS id=13665
CKPT started with pid=6, OS id=13667
SMON started with pid=7, OS id=13669
RECO started with pid=8, OS id=13671
Thu Jan 20 10:42:24 2011

上网搜了一下:说是:原来10g的以下几个参数不能同时使用,否则,会导致本错误出现。
  LOG_ARCHIVE_DEST
  LOG_ARCHIVE_DEST_n
 DB_RECOVERY_FILE_DEST
  注意,10g默认使用快速恢复区。 DB_RECOVERY_FILE_DEST

我的alert的错误信息:

Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing

系统反对使用  log_archive_start参数 

查看  数据库

SQL> show parameter log_archive_start;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     TRUE
无意间把这个参数 设置成为  true,正常的应该是 false。

log_archive_start参数在10g中已经被抛弃,无意间给设置后所以产生以上的错误;

 

alter system set log_archive_start=false scope=spfile;
重新启动数据库;
 startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              66068508 bytes
Database Buffers          100663296 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
 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 instance started.
Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              66068508 bytes
Database Buffers          100663296 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
  ------到此:问题解决

总结:

原来10g有的参数被抛弃,所以修改之后,就会报错,只能重置参数才可以。

那么,怎么查看那些参数被抛弃了呢:
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
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
max_enabled_roles
max number of roles a user can have enabled
global_context_pool_size
Global Application Context Pool Size in Bytes
serial_reuse
reuse the frame. segments
plsql_compiler_flags
PL/SQL compiler flags
parallel_automatic_tuning
enable intelligent defaults for parallel execution parameters
drs_start
start DG Broker monitor (DMON process)

 

 


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

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

注册时间:2010-11-10

  • 博文量
    7
  • 访问量
    42510