to check database running mode
select open_mode from v$database;
Identify Dead User Processes
ps -ef | grep LOCAL | grep oracle$ORACLE_SID
List Dead User Process ID
ps -ef | grep LOCAL | grep oracle$ORACLE_SID | awk '{print $2}'
Kill Dead User Processes
$ kill -9 $(ps -ef | grep LOCAL | grep oracle$ORACLE_SID | awk '{print $2}')
$ echo $?