ORA-01591: lock held by in-doubt distributed transaction string
Answer / guest
Cause: Trying to access resource that is locked by a dead
two-phase commit transaction that is in prepared state.
Action: DBA should query the pending_trans$ and related
tables, and attempt to repair network connection(s) to
coordinator and commit point. If timely repair is not
possible, DBA should contact DBA at commit point if known or
end user for correct outcome, or use heuristic default if
given to issue a heuristic commit or abort command to
finalize the local portion of the distributed transaction.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
SQL*Loader-00914: Error locking table string in exclusive mode.
ORA-24141: rule set string.string does not exist
NNO-00262: warning: cannot write checkpoint file "string"
ORA-37113: OLAP API initialization error: (string)
ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
ORA-16029: cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
ORA-13420: the SRID of the geometry parameter was not null
ORA-19922: there is no parent row with id string and level string
ORA-24329: invalid character set identifier
ORA-29368: consumer group string does not exist
RMAN-07521: cannot create recovery catalog in database version string; version string required
TNS-12615: TNS:preempt error