<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    tbwshc

    ORA-600(1265)錯誤

    客戶的數據庫出現ORA-600錯誤,錯誤函數為1265。

     

     

    數據庫版本為10.2.0.4 for Linux,錯誤信息為:

    Fri Aug 26 22:00:11 2011
    Errors in file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc:
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    Fri Aug 26 22:00:13 2011
    Errors in file /opt/app/
    oracletb/admin/orcl/udump/orcl1_ora_16655.trc:
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    Fri Aug 26 22:00:13 2011
    Trace dumping is performing id=[cdmp_20110826220013]
    Fri Aug 26 22:00:14 2011
    Errors in file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc:
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-06512: at "USER1.P_PRO", line 5
    ORA-04088: error during execution of trigger 'USER1.P_PRO'
    Fri Aug 26 22:00:15 2011
    Errors in file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc:
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-06512: at "USER1.P_PRO ", line 5
    ORA-04088: error during execution of trigger 'USER1.P_PRO'
    ORA-06512: at "USER1.U_PRO ", line 25
    Fri Aug 26 22:00:17 2011
    Errors in file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc:
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-02067: transaction or savepoint rollback required
    Fri Aug 26 22:00:18 2011
    Errors in file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc:
    ORA-00600: internal error code, arguments: [17281], [600], [0x2E134EEC0], [], [], [], [], []
    ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], []
    ORA-02067: transaction or savepoint rollback required

    這個錯誤是ORA-600[1265]錯誤引發的,隨后還出現了ORA-600[17281]、ORA-4088和ORA-2067錯誤。其中ORA-2067的描述為:

    $ oerr ora 2067
    02067, 00000, "transaction or savepoint rollback required"
    // *Cause: A failure (typically a trigger or stored procedure with multiple
    // remote updates) occurred such that the all-or-nothing execution
    // of a previous Oracle call cannot be guaranteed.
    // *Action: rollback to a previous savepoint or rollback the transaction
    // and resubmit.

    從這個描述和Oracle的報錯信息不難判斷,Oracle在通過觸發器更新遠端表時引發了這個600錯誤。

    根據Oracle的MOS文檔Bug 5655419 Distributed transaction hits ORA-600:[1265] or ORA-600:[k2gget: downgrade] in 10.2的描述,這個錯誤和分布式事務有關,確認影響的版本就是當前環境的10.2.0.4。這個錯誤的產生一般與窗口維護有關,可以看到問題的發生時刻恰好是22點,從這個時刻開始,Oracle進入維護窗口,進行空間回收統計信息收集等后臺工作,顯然就是因為窗口的變化導致了這個錯誤的產生。

    Oracle在11.1.0.6中FIXED了這個bug。除了版本升級外,可以考慮將包含分布式事務修改的程序放到遠離時間窗口改變時間。

    posted on 2012-08-30 13:09 chen11-1 閱讀(1366) 評論(0)  編輯  收藏


    只有注冊用戶登錄后才能發表評論。


    網站導航:
     
    主站蜘蛛池模板: 免费一级毛suv好看的国产网站 | 日韩高清免费观看| 亚洲中文字幕久久精品无码2021| 无码免费一区二区三区免费播放| 国产亚洲人成无码网在线观看| 美女巨胸喷奶水视频www免费| 中文字幕亚洲一区| 国产精品网站在线观看免费传媒 | 97se亚洲综合在线| 猫咪免费人成网站在线观看| 亚洲男人都懂得羞羞网站| 99久久99久久精品免费观看 | 亚洲色欲色欲综合网站| 99re在线这里只有精品免费| 亚洲日韩中文字幕天堂不卡| 免费无码肉片在线观看| 国产亚洲精品91| 亚洲夜夜欢A∨一区二区三区| 成人A片产无码免费视频在线观看 成人电影在线免费观看 | 亚洲国产日韩在线成人蜜芽| 国产在线国偷精品产拍免费| 国产精品亚洲综合网站| 国产亚洲精品精品国产亚洲综合| 免费看少妇高潮成人片| 亚洲人成综合在线播放| 日本午夜免费福利视频| 成人免费av一区二区三区| 亚洲黄网在线观看| 成人永久免费高清| 手机看片国产免费永久| 亚洲av无码一区二区三区观看| 国产精品免费视频一区| 国产成人免费AV在线播放| 2019亚洲午夜无码天堂| 亚洲午夜爱爱香蕉片| 182tv免费观看在线视频| 亚洲AV无码AV吞精久久| 久久久久亚洲AV成人无码网站| 毛片免费全部免费观看| 两个人看的www免费视频| 亚洲熟妇无码八V在线播放|