Find & Kill Linux processes

Recently i wanted to use umount command in order to unmount some drive. I stopped all apps working on that drive with kill -9 <PID>, all user processes pkill -u <user>, but no luck when i use command umount <mount_point> i get the following error..

umount2: Device or resource busy

So i found some smart people that gave me some interesting command:

This one lists processes that is holding he mount point...

fuser -vm <mount_point>

an this one kills...

fuser -km <mount_point>

And then umount <mount_point> works...

Regards!

System Hold, Fix Manager before resetting counters

Concurrent Manager showing status “System Hold, Fix Manager before resetting counters”.

Solution:
To implement the solution, please execute the following steps:

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is
running.

2. Go to cd $FND_TOP/bin

$ adrelink.sh force=y link_debug=y "fnd FNDLIBR"
$ adrelink.sh force=y link_debug=y "fnd FNDFS"
$ adrelink.sh force=y link_debug=y "fnd FNDCRM"
$ adrelink.sh force=y link_debug=y "fnd FNDSM"

3. Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
Note 134007.1 CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables

4. Start the concurrent manager.

5. Retest the issue.

Reference :
SCHEDULE/PRERELEASER MANAGER STATUS : SYSTEM HOLD, FIX MANAGER BEFORE RESETTING [ID 985835.1]

If this does not help and you recently updated on version 12.1.3 then please apply patch from note:

Upgrade 12.1.3: PO Document Approval POXCON, Receiving Transaction RCVOLTM and Inventory Remote INCTM Managers Do Not Start [ID 1413393.1]

Kill concurrent request through database

Find the concurrent request:

SELECT ses.sid,
ses.serial#
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id =<request_id>); 

Kill the database session

SQL> ALTER SYSTEM KILL SESSION ' <sid>, <serial>' IMMEDIATE;

Terminate the request

update fnd_concurrent_requests set status_code='X', phase_code='C' where request_id=<request_id>;
commit;

Change the status to Completed

update fnd_concurrent_requests set status_code='E', phase_code='C' where request_id=<request_id>;
commit;

Status Codes
E -  Error
X -  Terminate
G -  Warning


cancel all scheduled concurrent programs

sqlplus apps/apps
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N';
COMMIT;

Cancel all running concurrent programs.

sqlplus apps/apps
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('R','I');
commit;

To Cancel Specific request:

sqlplus apps/apps
update fnd_concurrent_requests
set status_code='D', phase_code='C'
where request_id=<request id>;
commit;