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 閱讀(1367) 評論(0)  編輯  收藏


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


          網站導航:
           
          主站蜘蛛池模板: 许昌市| 德阳市| 邻水| 玉林市| 双柏县| 松溪县| 天台县| 津市市| 琼结县| 太仆寺旗| 罗江县| 桑日县| 册亨县| 宝兴县| 都江堰市| 瑞丽市| 屏山县| 鹿邑县| 冷水江市| 兴业县| 沙洋县| 万全县| 马关县| 安阳县| 安丘市| 教育| 田东县| 历史| 翁源县| 赞皇县| 惠来县| 台东市| 宝兴县| 油尖旺区| 武宁县| 丰顺县| 潼南县| 寻甸| 柳林县| 泗阳县| 辉南县|