Oracle DBA, How To, Error, Cause and Action

ORA-02058: no prepared transaction found with ID string

ORA-02058: no prepared transaction found with ID string




Cause: no transaction with local_tran_id or global_tran_id found in the pending_trans$ table in prepared state.




Action: check the pending_trans$ table.