How to Kill all Oracle processes from OS-Linux
Usually if any sessions are causing much load on server and you are unable to connect to instance any more even using prelim, there will be some situations where you have to clear all the Oracle processes either local or remote connections. If you have many sessions and in that case it will be time taking and not easy to kill each session by using “kill -9 <pid>”, Instead of that with a single command you can kill all processes, If you have multiple database then based on the $ORACLE_SID you can clear only processes belongs to the particular instance.
Use “ps -ef|grep pmon”, then based on the instance name you can grep list of processes.
-bash-3.2$ ps -ef|grep pmon oracle 3428 1 0 13:05 ? 00:00:00 ora_pmon_ind oracle 3662 3386 0 13:07 pts/1 00:00:00 grep pmon -bash-3.2$ ps -ef|grep ind oracle 3428 1 0 13:05 ? 00:00:00 ora_pmon_ind oracle 3430 1 0 13:05 ? 00:00:00 ora_psp0_ind oracle 3432 1 0 13:05 ? 00:00:00 ora_vktm_ind oracle 3436 1 0 13:05 ? 00:00:00 ora_gen0_ind oracle 3438 1 0 13:05 ? 00:00:00 ora_mman_ind oracle 3440 1 0 13:05 ? 00:00:00 ora_diag_ind oracle 3444 1 0 13:05 ? 00:00:00 ora_dbrm_ind oracle 3446 1 0 13:05 ? 00:00:00 ora_dia0_ind oracle 3448 1 0 13:05 ? 00:00:00 ora_dbw0_ind oracle 3450 1 0 13:05 ? 00:00:00 ora_lgwr_ind oracle 3452 1 0 13:05 ? 00:00:00 ora_ckpt_ind oracle 3454 1 0 13:05 ? 00:00:00 ora_smon_ind oracle 3456 1 0 13:05 ? 00:00:00 ora_reco_ind oracle 3458 1 0 13:05 ? 00:00:00 ora_lreg_ind oracle 3460 1 0 13:05 ? 00:00:00 ora_mmon_ind oracle 3462 1 0 13:05 ? 00:00:00 ora_mmnl_ind oracle 3464 1 0 13:05 ? 00:00:00 ora_d000_ind oracle 3466 1 0 13:05 ? 00:00:00 ora_s000_ind oracle 3485 1 0 13:05 ? 00:00:00 ora_nss2_ind oracle 3488 1 0 13:05 ? 00:00:00 ora_tmon_ind oracle 3490 1 0 13:05 ? 00:00:00 ora_arc0_ind oracle 3492 1 0 13:05 ? 00:00:00 ora_arc1_ind oracle 3494 1 0 13:05 ? 00:00:00 ora_arc2_ind oracle 3496 1 0 13:05 ? 00:00:00 ora_arc3_ind oracle 3498 1 0 13:05 ? 00:00:00 ora_tt00_ind oracle 3500 1 0 13:05 ? 00:00:00 ora_smco_ind oracle 3509 1 0 13:05 ? 00:00:00 ora_w000_ind oracle 3511 1 0 13:05 ? 00:00:00 ora_aqpc_ind oracle 3516 1 2 13:05 ? 00:00:01 ora_p000_ind oracle 3518 1 3 13:05 ? 00:00:02 ora_p001_ind oracle 3520 1 0 13:05 ? 00:00:00 ora_p002_ind oracle 3522 1 0 13:05 ? 00:00:00 ora_p003_ind oracle 3550 1 0 13:05 ? 00:00:00 ora_qm02_ind oracle 3554 1 0 13:05 ? 00:00:00 ora_q002_ind oracle 3556 1 0 13:05 ? 00:00:00 ora_q003_ind oracle 3570 1 0 13:06 ? 00:00:00 ora_cjq0_ind oracle 3574 1 0 13:06 ? 00:00:00 ora_p004_ind oracle 3576 1 0 13:06 ? 00:00:00 ora_p005_ind oracle 3578 1 0 13:06 ? 00:00:00 ora_p006_ind oracle 3580 1 0 13:06 ? 00:00:00 ora_p007_ind oracle 3664 3386 0 13:07 pts/1 00:00:00 grep ind
From above command you can still get output of only PID which you are going to kill and of course you can crosscheck.
-bash-3.2$ ps -ef|grep ind|grep -v grep|awk '{print $2}'
3428
3430
3432
3436
3438
3440
3444
3446
3448
3450
3452
3454
3456
3458
3460
3462
3464
3466
3485
3488
3490
3492
3494
3496
3498
3500
3509
3511
3516
3518
3520
3522
3550
3554
3556
3570
3574
3576
3578
3580
The above command is just only displays and now we will kill the same processes by adding kill statment to the above command
-bash-3.2$ kill -9 `ps -ef|grep ind|grep -v grep|awk '{print $2}'`
-bash-3.2$ ps -ef|grep ind|grep -v grep|awk '{print $2}'
-bash-3.2$
Now all the processes belongs to “ind” were cleared, you can crosscheck again with the below command.
-bash-3.2$ps -ef|grep pmon oracle 3891 3386 0 13:12 pts/1 00:00:00 grep pmon -bash-3.2$ ps -ef|grep ind oracle 3901 3386 0 13:12 pts/1 00:00:00 grep ind -bash-3.2$
— Happy Reading —
