Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02049: timeout

jmft2012Mar 13 2013 — edited Mar 15 2013

11gR2.

we have web app and two dbs as the backend. some transactions have been done via the db links between the two dbs.

We have had often like :

at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-02049: timeout: distributed transaction waiting for lock [See nested exception: java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock ]
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:109)

Bu we can not find ORA-02049 in the trace files of the both dbs' trace file locations. Why?

current DISTRIBUTED_LOCK_TIMEOUT=60, may want to increase to 300 (5 min).
What would be the negative for the increasing?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2013

Added on Mar 13 2013

#general-database-discussions

12 comments

10,894 views