1)Kill all Oracle processes associated with the ORACLE_SID
2)Use the ipcs –pmb command to identify all held RAM memory segments.
3)ipcs -a gives the following information
a)------ Shared Memory Segments --------
b)------ Semaphore Arrays --------
4)ipcrm -m shmid
5)ipcrm -s semid
6)we can create a single command to terminate all Oracle processes associated with your hung database instance.
root> ps -efgrep $ORACLE_SID \grep -v grepawk '{print $2}'xargs -i kill -9 {}