oracle 10.2.0.1.0
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
数据库已经打开。
SQL>
查了一下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.
查看alert文件：
Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing
SQL> show parameter log_archive_start
NAME TYPE VALUE
------------------------------------ ----------- ------------------
log_archive_start boolean TRUE
原来10g已经不支持该参数了。在 10g 中，当打开归档模式(archive log mode) ，则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式，但是自动归档没有被设定的情况了。在9i的时代，常常有人忘了修改log_archive_start这个参数，导致日志无法自动归档，从而导致数据库挂起。10g考虑到这点做了改进。要解决此问题，只要重置这个参数就可以了。
SQL> ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';
系统已更改。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
数据库已经打开。
SQL>
好了，没问题了。现在我们来查看一下 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行。
SQL>
10g参数替代情况：
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)
10g废弃的参数：
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
阅读(831) | 评论(0) | 转发(0) |
