Error ORA-01591 with oracle 9i

From: news.wanadoo.fr <speron_at_telys.com>
Date: Wed, 31 May 2006 13:44:14 +0200
Message-ID: <447d818e$0$21290$8fcfb975@news.wanadoo.fr>

Hello,

When I start my web server (weblogic 8.1 SP3), I get the following message :

<May 31, 2006 12:27:34 PM GMT> <Error> <WLW> <000000> <SQLException in cleanupDocuments(): VendorCode = 1591
java.sql.SQLException: ORA-01591: lock held by in-doubt distributed transaction 5.4.191715

oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)

Identified with user oracle and connected with sqlplus as dba, I tried to make a ROLLBACK FORCE '5.4.191715' and oracle tells me that It doesn't know this ID !!!

Is there any command to make a global ROLLBACK for locked transactions ?

Thanks a lot for your help

Stéphane Received on Wed May 31 2006 - 06:44:14 CDT