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

最新推荐文章于 2023-10-23 21:19:19 发布

ckbrqjc0476

最新推荐文章于 2023-10-23 21:19:19 发布

阅读量107

点赞数

本文介绍了解决Oracle 10g数据库中ORA-32004错误的方法，该错误由弃用参数log_archive_start引起。通过设置log_archive_start为FALSE并重置参数，最终成功解决了问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.

总结：

原来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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24873454/viewspace-684349/