1. 首页
  2. IT资讯

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

今天发现一个好帖子是关于log_参数冲突的。作者要求明确提出出处,所以我链接一下http://sunwayle.blog.51cto.com/114995/94383

启动数据库时,报如下错误:SQL> startupORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE 例程已经启动。Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145488364 bytesDatabase Buffers 25165824 bytesRedo Buffers 524288 bytes数据库装载完毕。数据库已经打开。SQL> ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID=’*’;系统已更改。SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startupORACLE 例程已经启动。Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145488364 bytesDatabase Buffers 25165824 bytesRedo Buffers 524288 bytes数据库装载完毕。数据库已经打开。知所以然:见下文[url]http://www.dbanotes.net/archives/2004/12/caecora32004.html[/url]

在 Oracle 10g 中,以前熟悉的一些参数已经 deprecated 了,有的时候很烦人。
SQL> STARTUP;ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.Total System Global Area  213909504 bytesFixed Size                   778156 bytesVariable Size             128983124 bytesDatabase Buffers           83886080 bytesRedo Buffers                 262144 bytesDatabase mounted.Database opened.SQL>SQL> host oerr ora 3200432004, 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_startEnd 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> STARTUPORACLE instance started.Total System Global Area  213909504 bytesFixed Size                   778156 bytesVariable Size             128983124 bytesDatabase Buffers           83886080 bytesRedo Buffers                 262144 bytesDatabase 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                          databasebuffer_pool_keep          Number of database blocks/latches in keep buffer poolbuffer_pool_recycle       Number of database blocks/latches in recycle buffer poollog_archive_start         start archival process on SGA initializationparallel_server           if TRUE startup in parallel server modeparallel_server_instances number of instances to use for sizing OPS SGA structuresfast_start_io_target      Upper bound on recovery readsmax_enabled_roles         max number of roles a user can have enabledglobal_context_pool_size  Global Application Context Pool Size in Bytesplsql_compiler_flags      PL/SQL compiler flagsparallel_automatic_tuning enable intelligent defaults for parallel execution parametersdrs_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 

本文出自 “自由—-sunwayle.blog.51cto.com” 博客,请务必保留此出处http://sunwayle.blog.51cto.com/114995/94383

本文出自 51CTO.COM技术博客

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1026761/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194836.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code