Monday, January 1, 2018

Could not reserve record 2 tries keep trying oracle forms -Sloution


  1. This error happens because there is locked session and the solution to kill the session using the following steps :-
  • first fin the locked session using this query from db account select sid,serial# from v$session where sid in (select a.SESSION_ID from v$locked_object a, dba_objects b where a.object_id = b.object_id and a.SESSION_ID not in (select a.SESSION_ID from v$locked_object a, dba_objects b where a.object_id = b.object_id and session_id in (select sid from v$lock where block = 1)));
  • Then kill the locked session using sid,serial# from the first query  using this :- alter system kill session '119,148 ' immediate;

No comments:

Post a Comment

signer information does not match signer information of other classes in the same package in Oracle forms java bean

The Main issue to this , is there are many jar File have same package name on it To Solve the issue ,used  JDeveloper or any java develo...