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

在 Oracle 10g 中，以前熟悉的一些参数已经 deprecated 了，有的时候很烦人。

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

Total System Global Area  213909504 bytes
Fixed Size                   778156 bytes
Variable Size             128983124 bytes
Database Buffers           83886080 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
SQL>
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.
SQL>

告诉我们去 alert log 中查看信息。查找...

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

oops ，10g 不支持该参数了? 原来在 10g 中，当打开归档模式(archive log mode) ，则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式，但是自动归档没有被设定的情况了。这也算是 Oracle 修正的一个小Bug。如果是从 9i 升级到 10g 的话，不注意可能会有点小问题的。要解决该问题，需要重置 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.

Total System Global Area  213909504 bytes
Fixed Size                   778156 bytes
Variable Size             128983124 bytes
Database Buffers           83886080 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
SQL>

It's OK now. 查看一下 10g 中都有那些参数是 deprecated 的:

SQL> SELECT NAME, description
  2    FROM v$parameter
  3   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
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)

12 rows selected.

SQL>

参数替代情况

Deprecated parameters in release 10g: 
------------------------------------------------ 
 
BUFFER_POOL_KEEP (replaced by DB_KEEP_CACHE_SIZE) 
BUFFER_POOL_RECYCLE (replaced by DB_RECYCLE_CACHE_SIZE) 
PLSQL_COMPILER_FLAGS (replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG) 
DRS_START (replaced by DG_BROKER_START) 
FAST_START_IO_TARGET (replaced by FAST_START_MTTR_TARGET) 
MTS_CIRCUITS (replaced by CIRCUITS) 
MTS_DISPATCHERS (replaced by DISPATCHERS) 
MTS_MAX_DISPATCHERS (replaced by MAX_DISPATCHERS) 
MTS_MAX_SERVERS (replaced by MAX_SHARED_SERVERS) 
MTS_SERVERS (replaced by SHARED_SERVERS) 
MTS_SESSIONS (replaced by SHARED_SERVER_SESSIONS) 
PARALLEL_SERVER (replaced by CLUSTER_DATABASE) 
PARALLEL_SERVER_INSTANCES (replaced by CLUSTER_DATABASE_INSTANCES) 
 

废弃的参数:

Obsolete parameters in 10g: 
--------------------------------------- 
 
DBLINK_ENCRYPT_LOGIN 
HASH_JOIN_ENABLED 
LOG_PARALLELISM 
MAX_ROLLBACK_SEGMENTS 
MTS_CIRCUITS 
MTS_DISPATCHERS 
MTS_LISTENER_ADDRESS 
MTS_MAX_DISPATCHERS 
MTS_MAX_SERVERS 
MTS_MULTIPLE_LISTENERS 
MTS_SERVERS 
MTS_SERVICE 
MTS_SESSIONS 
OPTIMIZER_MAX_PERMUTATIONS 
ORACLE_TRACE_COLLECTION_NAME 
ORACLE_TRACE_COLLECTION_PATH 
ORACLE_TRACE_COLLECTION_SIZE 
ORACLE_TRACE_ENABLE 
ORACLE_TRACE_FACILITY_NAME 
ORACLE_TRACE_FACILITY_PATH 
PARTITION_VIEW_ENABLED 
PLSQL_NATIVE_C_COMPILER 
PLSQL_NATIVE_LINKER 
PLSQL_NATIVE_MAKE_FILE_NAME 
PLSQL_NATIVE_MAKE_UTILITY 
ROW_LOCKING 
SERIALIZABLE 
TRANSACTION_AUDITING 
UNDO_SUPPRESS_ERRORS 
DISTRIBUTED_TRANSACTIONS 
MAX_TRANSACTION_BRANCHES 
PARALLEL_BROADCAST_ENABLED 
STANDBY_PRESERVES_NAMES 
ALWAYS_ANTI_JOIN 
ALWAYS_SEMI_JOIN 
DB_BLOCK_LRU_LATCHES 
DB_BLOCK_MAX_DIRTY_TARGET 
DB_FILE_DIRECT_IO_COUNT 
GC_DEFER_TIME 
GC_RELEASABLE_LOCKS 
GC_ROLLBACK_LOCKS 
HASH_MULTIBLOCK_IO_COUNT 
INSTANCE_NODESET 
JOB_QUEUE_INTERVAL 
OPS_INTERCONNECTS 
OPTIMIZER_PERCENT_PARALLEL 
SORT_MULTIBLOCK_READ_COUNT 
TEXT_ENABLE