i followed the steps which i got from the metalink.
select LOCAL_TRAN_ID, TRAN_COMMENT,STATE,STATUS from pending_trans$;
SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID, STATE, MIXED, HOST, COMMIT#
FROM DBA_2PC_PENDING
WHERE LOCAL_TRAN_ID ='10.25.36897';
COMMIT FORCE '10.25.36897', '10146005246693';
after commiting the transaction i am able to insert.
but the same error is comming again...So what steps i can take for stoping it
I think it is the problem with the aplication ?
my god - what a load of rubbish, you cannot set transation like that!! all you are doing is supressing the error it gives
gee whizz
It does remove pending transaction even when commit or rollback force do not work .try it for yourself before calling it 'load of rubbish"
Under certain conditions, it may not be possible for an automatic recovery to execute without errors. As a result, recovery cannot identify it. (A possible symptom for this situation is when the ORA-02062 error is raised.) In this case, the DBA may use the DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure to clean up any entries whose state is not "prepared."
Last edited by BV1963; 07-09-2008 at 10:47 AM.
One, who thinks that the other one who thinks that know and does not know, does not know either!
please let me know why the transaction is pending,how to find where it is blocking.How to check which query is performing when the state of transaction
is prepared