Home » Server Options » Replication » ora-01591 : Lock held by in doubt transaction
ora-01591 : Lock held by in doubt transaction [message #75512] Wed, 23 June 2004 04:21
S Varshney
Messages: 1
Registered: June 2004
Junior Member
 



Hi.



 



We are using oracle 8.0 replication features. It is  multi master based replication

with two sites(L1 and L2) . One of  the site(L2) was having  network  connectivity

 issue for two days. After two days when we started the site database, we found

 transaction are not getting replicated to the sites…

On replication manager when I go and click it shows me error – Ora-01591 lock

held by in-doubt transaction 9.2.118602.

 



At site L2 I found the state of pending transaction is committed but at L1 the state

of pending transaction is prepared. I tried to manually commit the transaction

using following command

 force commit ‘9.2.118602’ at site L1

but still the state of pending transaction is ‘prepared’.  Please suggest how to

start replication and resolve the error..

 

thanks in advance 



 

SV
Previous Topic: Problem in 8i replication
Next Topic: SharePlex for Oracle 8i
Goto Forum:
  


Current Time: Thu Mar 28 14:52:42 CDT 2024