Re: Best way to handle Oracle shutdowns from Unix script

question 2: exp help=yes

question 1: write a script to capture process id(s) of active Oracle connections - $pid=`ps -ef | grep oracle<SID> | cut <options>`

then superuser kill those process ids,
then shutdown normal.

This works better than doing a shutdown immediate every time you shutdown. If you shutdown immediate time after time, eventually you run into problems. Received on Tue Oct 14 1997 - 00:00:00 CDT