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 |
ORA-12899: value too large for column string (actual: string, maximum: string)
ORA-01045: user string lacks CREATE SESSION privilege; logon denied
NID-00105: Need to specify "LOGFILE=<logfile>" when using APPEND=YES option
AMD-00140: internal error: [string] [string] [string] [string] [string]
DRG-11214: execution of procedure filter stored procedure has failed
ORA-23456: flavor string does not contain "string"
ORA-03291: Invalid truncate option - missing STORAGE keyword
AMD-00147: invalid Custom Measure creation mode "string" specified
ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
NNL-01041: Data stream open failures: number
ORA-02185: a token other than WORK follows COMMIT
ORA-06316: IPA: Invalid database SID