Pls help to get the cause:
Exception data: java.rmi.RemoteException: ORA-20000: ERROR: (ORA-20000: ERROR: (ORA-02049: timeout: distributed transaction waiting for lock) OTHERS error (1788651)) for 1788651
ORA-06512: at "CNOS.INVENTORY4_PKG", line 1111
ORA-06512: at "CNOS.INVENTORY4_PKG", line 941
distributed_lock_timeout is set to 60, whether we need to increase this ?
As you said to treat this dead lock in oracle dead lock will been taken care automatically so we can leave this error as such is there any chance it will resolve automatically.. please advice.