Oracle9i,我插入数据和删除数据都可以正常完成,但数据库只要一回滚,就出错,以前没遇到过这问题,实在找不到原因!望大家指教,谢谢!
<Mar 3, 2009 2:49:22 PM CST> <Error> <JTA> <110412> <Xid=111:bacdfb4c66ea662f(17967994),Status=Rolled back. [Reason=Unknown],HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=239,activeThread=Thread[ExecuteThread: '89' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection]=(state=rolledback,assigned=server01,xar=weblogic.jdbc.jts.Connection@1e47e1d,re-Registered = false),SCInfo[testdomain+server01]=(state=rolledback),properties=({weblogic.jdbc=t3://192.168.101.4:6001}),local properties=({modifiedListeners=[weblogic.ejb20.internal.TxManager$TxListener@2720d, weblogic.ejb20.internal.TxManager$TxListener@1152879, weblogic.ejb20.internal.TxManager$TxListener@1f5c365]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=server01+192.168.101.4:6001+testdomain+t3+, Resources={})],CoordinatorURL=server01+192.168.101.4:6001+testdomain+t3+) completed heuristically: (weblogic.jdbc.jts.Connection, HeuristicHazard, (javax.transaction.xa.XAException: ORA-12151: TNS:received bad packet type from network layer
<Mar 3, 2009 2:49:22 PM CST> <Error> <JTA> <110412> <Xid=111:bacdfb4c66ea662f(17967994),Status=Rolled back. [Reason=Unknown],HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=239,activeThread=Thread[ExecuteThread: '89' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection]=(state=rolledback,assigned=server01,xar=weblogic.jdbc.jts.Connection@1e47e1d,re-Registered = false),SCInfo[testdomain+server01]=(state=rolledback),properties=({weblogic.jdbc=t3://192.168.101.4:6001}),local properties=({modifiedListeners=[weblogic.ejb20.internal.TxManager$TxListener@2720d, weblogic.ejb20.internal.TxManager$TxListener@1152879, weblogic.ejb20.internal.TxManager$TxListener@1f5c365]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=server01+192.168.101.4:6001+testdomain+t3+, Resources={})],CoordinatorURL=server01+192.168.101.4:6001+testdomain+t3+) completed heuristically: (weblogic.jdbc.jts.Connection, HeuristicHazard, (javax.transaction.xa.XAException: ORA-12151: TNS:received bad packet type from network layer
后面一堆是报错信息还是alert日志里面的错误信息记录?
不见oracledbalgtu兄弟好多天啊!
从这个错误看,同意三楼的说法,不一定是oracle的错误,从weblogic找原因了
同意这种看法!
楼主可以以plsql里面,再试几个次回滚操作,如果正常说明了确实是网络丢包;
如果每次回滚都是操作错误,那可要查看回滚表空间是不是空间受到限制了?或者是磁盘已经满了?