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)  編輯  收藏


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


          網站導航:
           
          主站蜘蛛池模板: 南木林县| 衡阳县| 彰化县| 旬邑县| 平罗县| 江山市| 龙门县| 白山市| 宁南县| 河间市| 新野县| 呼图壁县| 开鲁县| 台山市| 酒泉市| 扶余县| 巴林右旗| 鞍山市| 兴城市| 白沙| 屯昌县| 榆林市| 内黄县| 嵊州市| 怀柔区| 内江市| 克什克腾旗| 阿荣旗| 扶绥县| 临沭县| 灵武市| 集贤县| 勐海县| 朝阳市| 建始县| 砚山县| 永宁县| 南投市| 东乌| 大同县| 常州市|