FRM-92101: A failure has occurred on the Server. You will need to reestablish your session

Hi DAB-Mates,
Almost time, we face this below error while opening forms in oracle application. Please find the below issue and error: 

“FRM-92101: A failure has occurred on the Server. You will need to reestablish your session.” 

If you getting such issue or error then please find the below Simple solution and Work around for this issue or error in our front-end oracle application. 

1. Login to your AP server. If required, then do SU to your accessible user. 
$su – SKU 
Password: **** 
$ 
Here, in above command SKU is the user name. 

2. Then grep for forms f60 as showed in below command. 
$grep f60 |grep SKU 
Here, again SKU is username, for which we have to check if there is any http session is running or not. 

Now, if you are getting below out as shown: 
$grep f60 |grep SKU 

SKU 12345 3456 0 16:19:19 ? 0:11 /ora-data/SKU/appl/fnd/11.5.0/bin/f60webmx server webfile=HTTP-0,0,ora-data.blogspot.com_A8001_ora-data,192.168.1.101 

3. Then find out the Session details from process as shown in above output. 
Try this below sql query, may help you to find out the session details. 

select ' Sid, Serial#, Aud sid : '|| s.sid||' , '||s.serial#||' , '|| s.audsid||chr(10)|| ' DB User / OS User : '||s.username|| ' / '||s.osuser||chr(10)|| ' Machine - Terminal : '|| s.machine||' - '|| s.terminal||chr(10)|| ' OS Process Ids : '|| s.process||' (Client) '||p.spid||' (Server)'|| chr(10)|| ' Client Program Name : '||s.program "Session Info" from v$process p,v$session s where p.addr = s.paddr and s.sid = nvl('&SID',s.sid) and nvl(s.terminal,' ') = nvl('&Terminal',nvl(s.terminal,' ')) and s.process = nvl('&Process',s.process) and p.spid = nvl('&spid',p.spid) and s.username = nvl('&username',s.username) and nvl(s.osuser,' ') = nvl('&OSUser',nvl(s.osuser,' ')) and nvl(s.machine,' ') = nvl('&machine',nvl(s.machine,' ')) and nvl('&SID',nvl('&TERMINAL',nvl('&PROCESS',nvl('&SPID',nvl('&USERNAME', nvl('&OSUSER',nvl('&MACHINE','NO VALUES'))))))) <> 'NO VALUES' 
/ 

If the above query is not clear, please let us know. We can modify it and as per your requirements.

4. If the process status is Inactive, then you can kill the http running session. Almost time it will be inactive. 

$kill -9 12345 

Here, in above command 12345 is the process id.

After these all, please clear cache and login again.

Note: If you have 2 AP nodes, then please login to both AP servers and check for running forms process with that username as here is SKU. 

Some more useful link:
Redo Log Inactive issue
Oracle Database
R12 Application
Oracle Applications
Interviews Questions and Answers
Hope this may useful for you all. If there is any query related to this, please write to us either through comments box or our contact box ora-data.blogspot.com
Thanks,