在 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