随笔分类 -  ora

記錄ora錯誤
記一次undo問題
摘要：記一次undo問題 參考：http://www.linuxidc.com/Linux/2014-06/103780.htm ORA-00376: 無法於此時讀取檔案 3 ORA-01110: 資料檔 3: '/THARS/system/THARSDB1/undotbs01.dbf' ORA-06512: 在 "TNBWOMSDA1.SP_TABLE_LCM1", line 5 ... 阅读全文
posted @ 2017-02-20 16:42 guilingyang 阅读(242) 评论(0) 推荐(0)
分佈式事務故障處理暨ORA-24756: transaction does not exist處理
摘要：ORA-24756处理 看到警告日誌一直報ORA-24756錯誤 Errors in file /oracle/admin/NHMIX01/bdump/nhmix01_reco_4959.trc: ORA-24756: transaction does not exist 但是去找trace文件的時候卻沒有 想到了事務的問題，查dba_2pc_pending ... 阅读全文
posted @ 2016-08-30 11:04 guilingyang 阅读(1679) 评论(0) 推荐(0)
ORA-1461 encountered when generating server alert SMG-3500
摘要：Doc ID 461911.1 Patch 6602742 Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.3 and later Information in this document applies to an 阅读全文
posted @ 2016-04-08 15:56 guilingyang 阅读(716) 评论(0) 推荐(0)