Form Process Running for more than a day in EBS R12 Instance with process 17170608

Solution:

 

1.     we we need to look for frmweb processes are running for more than 12 hours

$ ps -ef|grep frmweb

 applmgr 17039372  7340170   0 17:34:10      -  0:00 frmweb webfile=5,20327,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

 applmgr 17170608  7340170  93   Dec 19      - 1974:10 frmweb webfile=5,20071,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

 applmgr  5964056  7340170   0 18:21:38      -  0:02 frmweb webfile=5,20332,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

 applmgr  6029820  7340170   0 15:19:44      -  0:00 frmweb webfile=5,20303,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

 applmgr  6160666  7340170   0 11:37:13      -  0:00 frmweb webfile=5,20270,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

 applmgr  6750654  7340170   0 17:24:56      -  0:00 frmweb webfile=5,20325,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

2.     check for processess which is using high CPU by using topas command

3.     Also verfiy that these processes don't have a database session. This can be done using

 select * from v$session where process='<OS process id of frmweb process>'

 this must not return any rows

            SQL> select * from v$session where process='17170608';

 no rows selected

4. Check the process and kill it

               $ ps -ef|grep 17170608

applmgr 17170608  7340170  82   Dec 19      - 1979:29 frmweb        webfile=5,20071,cmsprdap_9000,/ur12app/cmsp/inst/apps/CMSP_cmsprdap/logs/ora/10.1.2/forms/socket.log

                applmgr  6422882  6226260   0 21:07:45  pts/0  0:00 grep 17170608
            $ kill -9 17170608
            $ ps -ef|grep 17170608
              applmgr 13369546  6226260   0 21:08:36  pts/0  0:00 grep 17170608