--=======================
-- ORA-32004 的錯(cuò)誤處理
--=======================
?
??? 啟動(dòng)數(shù)據(jù)庫(kù)時(shí)，收到了 ORA - 32004 的錯(cuò)誤，錯(cuò)誤多是一些過(guò)時(shí)且在當(dāng)前版本中不在使用的參數(shù)，如果碰到類似的錯(cuò)誤，只需要將其
reset 即可。
?
1. 出現(xiàn)的錯(cuò)誤提示 ???
??? sys@ORCL> startup
??? ORA-32004: obsolete and/or deprecated parameter(s) specified
??? ORACLE instance started.
?
??? Total System Global Area ? 184549376 bytes
??? Fixed Size ????????????????? 1218412 bytes
??? Variable Size ????????????? 83888276 bytes
??? Database Buffers ?????????? 96468992 bytes
??? Redo Buffers ??????????????? 2973696 bytes
??? Database mounted.
??? Database opened.
?
2. 查看告警日志獲得如下信息 ?
??? sys@ORCL > ho oerr ora 32004 ??????? -- 分析錯(cuò)誤
??? 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 .
???
??? -- 從告警日志中獲得如下信息
??? Deprecated system parameters with specified values:
??? ? sql_trace
??? End of deprecated system parameter listing
?
3. 從 spfile 參數(shù)中清除過(guò)時(shí)的參數(shù)后啟動(dòng)正常
??? sys@ORCL > alter system reset sql_trace scope = spfile sid = '*' ;
?
??? System altered .
?
??? sys@ORCL > startup force ;
??? ORACLE instance started .
?
??? Total System Global Area ? 184549376 bytes
??? Fixed Size ????????????????? 1218412 bytes
??? Variable Size ????????????? 83888276 bytes
??? Database Buffers ?????????? 96468992 bytes
??? Redo Buffers ??????????????? 2973696 bytes
??? Database mounted .
??? Database opened . ???
?
4. 查看當(dāng)前版本不再建議使用的參數(shù)
??? sys@ORCL > select * from v$version where rownum < 2 ;
?
??? BANNER
??? ----------------------------------------------------------------
??? Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
?
??? sys@ORCL > select name , description ???????????????????
??? ? 2 ? from v$parameter where isdeprecated = 'TRUE' ;
?
??? NAME ?????????????????????????? DESCRIPTION
??? ------------------------------ --------------------------------------------------------------
??? lock_name_space ??????????????? lock name space used for generating lock names for standby/clo
??????????????????????????????? ?? ne 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
??? 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
??? 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
??? 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
??? global_context_pool_size ?????? Global Application Context Pool Size in Bytes
??? plsql_compiler_flags ?????????? PL/SQL compiler flags
??? sql_trace ????????????????????? enable SQL trace
??? parallel_automatic_tuning ????? enable intelligent defaults for parallel execution parameters
??? drs_start ????????????????????? start DG Broker monitor (DMON process)
?
5. 下面是 Oracle 10gR2 不再支持的參數(shù) ?
?
??? * ENQUEUE_RESOURCES ( undocumented in 10gR2 )
??? * DBLINK_ENCRYPT_LOGIN
??? * HASH_JOIN_ENABLED ( undocumented parameter )
??? * LOG_PARALLELISM ( undocumented parameter )
??? * MAX_ROLLBACK_SEGMENTS
??? * MTS_CIRCUITS ( this is replaced by CIRCUITS )
??? * MTS_DISPATCHERS ( this is replaced by DISPATCHERS )
??? * MTS_LISTENER_ADDRESS
??? * MTS_MAX_DISPATCHERS ( this is replaced by MAX_DISPATCHERS )
??? * MTS_MAX_SERVERS ( this is replaced by MAX_SHARED_SERVERS )
??? * MTS_MULTIPLE_LISTENERS
??? * MTS_SERVERS ( this is replaced by SHARED_SERVERS )
??? * MTS_SERVICE
??? * MTS_SESSIONS ( this is replaced by SHARED_SERVER_SESSIONS )
??? * OPTIMIZER_MAX_PERMUTATIONS ( undocumented parameter )
??? * 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 ( undocumented parameter )
??? * PLSQL_NATIVE_C_COMPILER
??? * PLSQL_NATIVE_LINKER
??? * PLSQL_NATIVE_MAKE_FILE_NAME
??? * PLSQL_NATIVE_MAKE_UTILITY
??? * ROW_LOCKING ( undocumented parameter )
??? * SERIALIZABLE ( undocumented parameter )
??? * TRANSACTION_AUDITING ( undocumented parameter )
??? * UNDO_SUPPRESS_ERRORS
???
6. 下面是 Oracle 10gR2 不建議使用參數(shù) ?
??? * LOGMNR_MAX_PERSISTENT_SESSIONS ( Oracle Streams uses it )
??? * MAX_COMMIT_PROPAGATION_DELAY
??? * REMOTE_ARCHIVE_ENABLE
??? * SERIAL_REUSE
??? * SQL_TRACE
??? * BUFFER_POOL_KEEP [replaced by DB_KEEP_CACHE_SIZE]
??? * BUFFER_POOL_RECYCLE [replaced by DB_RECYCLE_CACHE_SIZE]
??? * GLOBAL_CONTEXT_POOL_SIZE
??? * LOCK_NAME_SPACE
??? * LOG_ARCHIVE_START
??? * MAX_ENABLED_ROLES
??? * PARALLEL_AUTOMATIC_TUNING
??? * PLSQL_COMPILER_FLAGS [replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG] ???
7. 更多參考
有關(guān)閃回特性請(qǐng)參考
??????? Oracle 閃回特性(FLASHBACK DATABASE)
Oracle 閃回特性(FLASHBACK DROP & RECYCLEBIN)
Oracle 閃回特性(Flashback Query 、Flashback Table)
Oracle 閃回特性(Flashback Version 、Flashback Transaction)
?
有關(guān)基于用戶管理的備份和備份恢復(fù)的概念請(qǐng)參考：
??????? Oracle 冷備份
??????? Oracle 熱備份
??????? Oracle 備份恢復(fù)概念
??????? Oracle 實(shí)例恢復(fù)
??????? Oracle 基于用戶管理恢復(fù)的處理 ( 詳細(xì)描述了介質(zhì)恢復(fù)及其處理 )
???????
??? 有關(guān) RMAN 的恢復(fù)與管理請(qǐng)參考：
??????? RMAN 概述及其體系結(jié)構(gòu)
??????? RMAN 配置、監(jiān)控 與管理
??????? RMAN 備份詳解
??????? RMAN 還原與恢復(fù)
???????
??? 有關(guān) Oracle 體系結(jié)構(gòu)請(qǐng)參考：
??????? Oracle 實(shí)例和Oracle 數(shù)據(jù)庫(kù)(Oracle 體系結(jié)構(gòu))
??????? Oracle 表空間與數(shù)據(jù)文件
??????? Oracle 密碼文件
??????? Oracle 參數(shù)文件
Oracle 數(shù)據(jù)庫(kù)實(shí)例啟動(dòng)關(guān)閉過(guò)程
??????? Oracle 聯(lián)機(jī)重做日志文件(ONLINE LOG FILE)
??????? Oracle 控制文件(CONTROLFILE)
??????? Oracle 歸檔日志
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系： 360901061
您的支持是博主寫(xiě)作最大的動(dòng)力，如果您喜歡我的文章，感覺(jué)我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長(zhǎng)非常感激您！手機(jī)微信長(zhǎng)按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
