-
Title
Error: 12069 - OCITransRollback failed with ORA-1013 -
Description
Blocking on STP
Event_log output
Error: 12069 - OCITransRollback failed with ORA-1013. [sp_opst(osp)/9211]
Internal error: Error rolling back transaction for session 5: ORA-01013: user requested cancel of current operation.OPO output
24708 1 Blocked on table "schema"."table_name" at session 5
24708 1 blocking sid = 8672
24708 1 blocked waiting on external sid 8672
24708 1 sigalrm
24708 1 Blocked on table "schema"."table_name" at session 5 -
Cause
1) The OPO output shows that the session is being blocked by the the sid 8672
2) Check the target database for information on sid 8677. You are checking to see if it's a session that can be cancelled, such as user or application DML.
-
Resolution
kill the oracle session and the post queue should start moving again.
-
Additional Information
Please also see Solution SOL17443 as well.