How do I fix my ORA-02049?
To resolve ORA-02049, you would need to increase the SHARED_POOL_SIZE value in init. ora . If you find that the shared pool is large enough and the ORA-02049 error continues to exist, you may also want to try flushing the shared pool with ALTER SYSTEM FLUSH SHARED_POOL; to free even more space.
How to fix ORA-02049 timeout distributed transaction waiting for lock?
ORA-02049: TIMEOUT: DISTRIBUTED TRANSACTION WAITING FOR LOCK
- RELATED. A BLOCKING SESSION.
- DIAGNOSE.
- TESTCASE.
- As a database administrator you can increase the distributed_lock_timeout parameter to a high value.
- REFERENCES.
What is distributed_ lock_ timeout?
DISTRIBUTED_LOCK_TIMEOUT specifies the amount of time (in seconds) for distributed transactions to wait for locked resources. See Also: Oracle Database Concepts and Oracle Database Administrator’s Guide for more information on data concurrency.
What is JTA timeout?
WebLogic will automatically roll back transactions that don’t complete in a certain number of seconds. To change the setting, open the WebLogic Server Console, go to the JTA page for the domain ATG is installed in, and change the value in the Timeout Seconds field. ATG recommends setting the timeout to 120 seconds.
How do I increase my JTA timeout?
To change this setting, connect to WebLogic Server Administration Console. On the Domain > Configuration > JTA >Timeout Seconds tab, modify the Java Transaction API (JTA) timeout to be a minimum of 600.
What is the time out in ora-02049?
ORA-02049: time-out: distributed transaction waiting for lock Cause : The time to wait on a lock in a distributed transaction has been exceeded. This time is specified in the initialization parameter DISTRIBUTED_LOCK_TIMEOUT.
When does my Oracle get an ora-02063 error?
The My Oracle Support Community (MOSC) gives a description of the ORA-02063 error, saying that it happens when “you want to query or update a remote table and receive the following error”: This notes that the error can typically occur in response to an error at a remote database or table.
What causes the error ora-02042 in Java?
The ORA-02042 is an error caused by too many distributed transactions; we will speak more about what these are momentarily. The cause of this error is that the distributed transaction table was full due to too many distributed transactions remaining active.