主頁 > 知識(shí)庫 > Oracle undo_management參數(shù)不一致錯(cuò)誤

Oracle undo_management參數(shù)不一致錯(cuò)誤

熱門標(biāo)簽:外呼線路外顯本地號(hào)碼 征服者火車站地圖標(biāo)注 阿爾巴尼亞地圖標(biāo)注app 百度地圖標(biāo)注素材 美圖秀秀地圖標(biāo)注 開封智能外呼系統(tǒng)廠家 征服眼公司地圖標(biāo)注 人工智能地圖標(biāo)注自己能做嗎 word地圖標(biāo)注方向
環(huán)境Linux 5.8 10.2.0.5 RAC,兩個(gè)節(jié)點(diǎn)只能一個(gè)節(jié)點(diǎn)mount,如果嘗試mount另外節(jié)點(diǎn)就報(bào)ORA-01105和ORA-01606錯(cuò)誤
數(shù)據(jù)庫版本
復(fù)制代碼 代碼如下:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

crs資源情況
復(fù)制代碼 代碼如下:

[oracle@node1 dbs]$ $ORA_CRS_HOME/bin/crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....D1.inst application    OFFLINE   OFFLINE               
ora....D2.inst application    ONLINE    ONLINE    node2       
ora.PROD.db    application    ONLINE    ONLINE    node2       
ora....SM1.asm application    ONLINE    ONLINE    node1       
ora....E1.lsnr application    ONLINE    ONLINE    node1       
ora.node1.gsd  application    ONLINE    ONLINE    node1       
ora.node1.ons  application    ONLINE    ONLINE    node1       
ora.node1.vip  application    ONLINE    ONLINE    node1       
ora....SM2.asm application    ONLINE    ONLINE    node2       
ora....E2.lsnr application    ONLINE    ONLINE    node2       
ora.node2.gsd  application    ONLINE    ONLINE    node2       
ora.node2.ons  application    ONLINE    ONLINE    node2       
ora.node2.vip  application    ONLINE    ONLINE    node2
 

節(jié)點(diǎn)1 mount報(bào)錯(cuò)
復(fù)制代碼 代碼如下:

SQL> startup
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2094832 bytes
Variable Size             113248528 bytes
Database Buffers           50331648 bytes
Redo Buffers                6291456 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01606: gc_files_to_locks not identical to that of another mounted instance
Error:    ORA 1105 
Text:     mount is incompatible with mounts by other instances 
-------------------------------------------------------------------------------
Cause:  An attempt was made to mount the database, but another instance has already mounted 
        a database by the same name, and the mounts are not compatible.
        dditional messages will accompany this message to report why the mounts are incompatible.
Action:  See the accompanying messages for the appropriate action to take.

Error:  ORA 1606 
Text:   GC_FILES_TO_LOCKS not identical to that of another mounted instance 
-------------------------------------------------------------------------------
Cause:  The initialization parameter GC_FILES_TO_LOCKS is not the same as 
        another instance mounted in parallel mode.
        This parameter must be the same as that for all shared instances.
Action: Modify the parameter to be compatible with the other instances, then
        shut down and restart the instance.
 

根據(jù)這個(gè)錯(cuò)誤提示,查詢兩個(gè)節(jié)點(diǎn)的gc_files_to_locks參數(shù),均為空值(默認(rèn)值),也就是值相同
復(fù)制代碼 代碼如下:

SQL> show parameter gc_files_to_locks;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
gc_files_to_locks                    string
 

檢查兩個(gè)節(jié)點(diǎn)的gc相關(guān)隱含參數(shù),發(fā)現(xiàn)所有值也均一致
復(fù)制代碼 代碼如下:

NAME                           DESCRIPTION                                                           VALUE  
------------------------------ --------------------------------------------------------------------- -------
_gc_affinity_limit             dynamic affinity limit                                                50     
_gc_affinity_minimum           dynamic affinity minimum activity per minute                          6000   
_gc_affinity_time              if non zero, enable dynamic object affinity                           10     
_gc_async_memcpy               if TRUE, use async memcpy                                             FALSE  
_gc_check_bscn                 if TRUE, check for stale blocks                                       TRUE   
_gc_coalesce_recovery_reads    if TRUE, coalesce recovery reads                                      TRUE   
_gc_defer_time                 how long to defer down converts for hot buffers                       3      
_gc_dissolve_undo_affinity     if TRUE, dissolve undo affinity after an offline                      FALSE  
_gc_dynamic_affinity_locks     if TRUE, get dynamic affinity locks                                   TRUE   
_gc_element_percent            global cache element percent                                          103    
_gc_global_lru                 turn global lru off, make it automatic, or turn it on                 AUTO   
_gc_initiate_undo_affinity     if TRUE, initiate undo affinity after an online                       TRUE   
_gc_integrity_checks           set the integrity check level                                         1      
_gc_keep_recovery_buffers      if TRUE, make recovery buffers current                                TRUE   
_gc_latches                    number of latches per LMS process                                     8      
_gc_maximum_bids               maximum number of bids which can be prepared                          0      
_gcs_fast_reconfig             if TRUE, enable fast reconfiguration for gcs locks                    TRUE   
_gcs_latches                   number of gcs resource hash latches to be allocated per LMS process   64     
_gcs_pkey_history              number of pkey remastering history                                    4000   
_gcs_process_in_recovery       if TRUE, process gcs requests during instance recovery                TRUE   
_gcs_resources                 number of gcs resources to be allocated                                      
_gcs_shadow_locks              number of pcm shadow locks to be allocated                                   
_gc_statistics                 if TRUE, kcl statistics are maintained                                TRUE   
_gcs_testing                   GCS testing parameter                                                 0      
_gc_tsn_undo_affinity          if TRUE, use TSN undo affinity                                        TRUE   
_gc_undo_affinity              if TRUE, enable dynamic undo affinity                                 TRUE   
_gc_undo_affinity_locks        if TRUE, get affinity locks for undo                                  TRUE   
_gc_use_cr                     if TRUE, allow CR pins on PI and WRITING buffers                      TRUE   
_gc_vector_read                if TRUE, vector read current buffers                                  TRUE
 

仔細(xì)對比數(shù)據(jù)庫參數(shù),發(fā)現(xiàn)undo異常
復(fù)制代碼 代碼如下:

--節(jié)點(diǎn)1
SQL>  show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      MANUAL
undo_retention                       integer     900
undo_tablespace                      string      SYSTEM

 
--節(jié)點(diǎn)2
SQL>  show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
 

這里已經(jīng)明確,因?yàn)閮蓚€(gè)節(jié)點(diǎn)的undo_*相關(guān)參數(shù)配置不正確,導(dǎo)致數(shù)據(jù)庫只能一個(gè)節(jié)點(diǎn)mount。進(jìn)一步定位問題發(fā)現(xiàn),原來是因?yàn)閐ba粗心在編輯節(jié)點(diǎn)1的參數(shù)文件的時(shí)候把undo_*相關(guān)的參數(shù)給弄丟了,從而數(shù)據(jù)庫使用了默認(rèn)值undo_management=manual,undo_tablespace=system
您可能感興趣的文章:
  • oracle錯(cuò)誤代碼大全(超詳細(xì))
  • oracle 11g em重建報(bào)唯一約束錯(cuò)誤解決方法
  • oracle 10g OEM常規(guī)錯(cuò)誤(Unknown host specified)解決
  • plsql連接oracle數(shù)據(jù)庫報(bào)ora 12154錯(cuò)誤解決方法
  • Oracle AS關(guān)鍵字 提示錯(cuò)誤
  • 在oracle 數(shù)據(jù)庫中查看一個(gè)sql語句的執(zhí)行時(shí)間和SP2-0027錯(cuò)誤
  • Oracle常見錯(cuò)誤診斷
  • 安裝Oracle加載數(shù)據(jù)庫錯(cuò)誤areasQueries的解決
  • ORACLE出現(xiàn)錯(cuò)誤1033和錯(cuò)誤ORA-00600的解決方法

標(biāo)簽:酒泉 泰安 葫蘆島 海北 淮南 孝感 宜春 六安

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《Oracle undo_management參數(shù)不一致錯(cuò)誤》,本文關(guān)鍵詞  Oracle,undo,management,參數(shù),;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《Oracle undo_management參數(shù)不一致錯(cuò)誤》相關(guān)的同類信息!
  • 本頁收集關(guān)于Oracle undo_management參數(shù)不一致錯(cuò)誤的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章