当前位置：首页 > news >正文

Oracle 10g之ORA-32004问题

news 来源：原创 2024/5/3 1:43:24

做多元化控制文件时遇到了以下问题：

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              88082000 bytes
Database Buffers          192937984 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

查看oracle给出的问题描述：

SQL> host oerr ora 32004;
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause: One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.

查了查资料说是oracle 10G已经不支持该参数了，当打开归档模式（archive log mode），则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式，但是自动归档没有被设定的情况了。要解决该问题需要重置 log_archive_start 参数。

SQL> alter system reset log_archive_start SCOPE=SPFILE SID='*';

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

重启后再不报ORA-32004错误了！

查看10g中都有那些参数是 deprecated 的：

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

NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
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

NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
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

NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
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

NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
global_context_pool_size
Global Application Context Pool Size in Bytes

plsql_compiler_flags
PL/SQL compiler flags

sql_trace
enable SQL trace

NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
parallel_automatic_tuning
enable intelligent defaults for parallel execution parameters

drs_start
start DG Broker monitor (DMON process)

17 rows selected.