Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
lock held by in-doubt distributed transaction

lock held by in-doubt distributed transaction

2005-02-09       - By Tony.Adolph@(protected)
Reply:     1     2     3     4     5  

Hi Mark,
Thanks for the feedback. I tried...

SQL> alter session set "_smu_debug_mode" = 4;

Session altered.

SQL> exec dbms_transaction.purge_lost_db_entry('4.18.4935');
BEGIN dbms_transaction.purge_lost_db_entry('4.18.4935'); END;

*
ERROR at line 1:
ORA-06510 (See ORA-06510.ora-code.com): PL/SQL: unhandled user-defined exception
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_TRANSACTION", line 94
ORA-06512 (See ORA-06512.ora-code.com): at line 1

:-(

Tony



"Powell, Mark D" <mark.powell@(protected)>
Sent by: oracle-l-bounce@(protected)
02/08/2005 06:48 PM
Please respond to
mark.powell@(protected)


To
oracle-l@(protected)
cc

Subject
RE: lock held by in-doubt distributed transaction






I believe this is a bug.  The first solution I saw was support telling
people to convert their systems to using regular rollback segments but I
believe that you can issue ' alter session set "_smu_debug_mode" = 4; ' to
get around the problem.  I do not have the bug number so before you alter
your session you may want to check metalink on the hidden parameter.
HTH -- Mark D Powell --


-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Tony.Adolph@(protected)
Sent: Tuesday, February 08, 2005 11:55 AM
To: oracle-l@(protected)
Cc: Maxim.Demenko@(protected)
Subject: lock held by in-doubt distributed transaction


Hi folks,
One of our developers has just reported this error after a simple select:

select COUNT(*) FROM tracking.tracked_lacosa_request
                             *
ERROR at line 1:
ORA-01591 (See ORA-01591.ora-code.com): lock held by in-doubt distributed transaction 4.18.4935

So I looked for the in doubt transaction as follows:

select * from dba_2pc_neighbors;

and

select * from dba_2pc_pending;

but both returned no rows.

I tried the same query and also get the same error.  I bounced the
database (immediate) and still get the error and all the time with the
same transaction id 4.18.4935.  I got the developers to bounce their jboss

but no joy.

I tried dbms_transaction.purge_lost_db_entry:

SQL> exec dbms_transaction.purge_lost_db_entry('4.18.4935');
BEGIN dbms_transaction.purge_lost_db_entry('4.18.4935'); END;

*
ERROR at line 1:
ORA-30019 (See ORA-30019.ora-code.com): Illegal rollback Segment operation in Automatic Undo mode
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_TRANSACTION", line 65
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_TRANSACTION", line 85
ORA-06512 (See ORA-06512.ora-code.com): at line 1

Any ideas folks?

Cheers
Tony

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l