--=======================
-- ORA-32004 的錯誤處理
--=======================
?
??? 啟動數據庫時，收到了 ORA - 32004 的錯誤，錯誤多是一些過時且在當前版本中不在使用的參數，如果碰到類似的錯誤，只需要將其
reset 即可。
?
1. 出現的錯誤提示 ???
??? 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 ??????? -- 分析錯誤
??? 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 參數中清除過時的參數后啟動正常
??? 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. 查看當前版本不再建議使用的參數
??? 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 不再支持的參數 ?
?
??? * 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 不建議使用參數 ?
??? * 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. 更多參考
有關閃回特性請參考
??????? Oracle 閃回特性(FLASHBACK DATABASE)
Oracle 閃回特性(FLASHBACK DROP & RECYCLEBIN)
Oracle 閃回特性(Flashback Query 、Flashback Table)
Oracle 閃回特性(Flashback Version 、Flashback Transaction)
?
有關基于用戶管理的備份和備份恢復的概念請參考：
??????? Oracle 冷備份
??????? Oracle 熱備份
??????? Oracle 備份恢復概念
??????? Oracle 實例恢復
??????? Oracle 基于用戶管理恢復的處理 ( 詳細描述了介質恢復及其處理 )
???????
??? 有關 RMAN 的恢復與管理請參考：
??????? RMAN 概述及其體系結構
??????? RMAN 配置、監控 與管理
??????? RMAN 備份詳解
??????? RMAN 還原與恢復
???????
??? 有關 Oracle 體系結構請參考：
??????? Oracle 實例和Oracle 數據庫(Oracle 體系結構)
??????? Oracle 表空間與數據文件
??????? Oracle 密碼文件
??????? Oracle 參數文件
??????? Oracle 聯機重做日志文件(ONLINE LOG FILE)
??????? Oracle 控制文件(CONTROLFILE)
??????? Oracle 歸檔日志
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
