Sometimes, a daemon process (a constantly running process, like
an Oracle listener) may fail, and when a daemon process fails, a job
is required to keep it running.
I write code that runs on a cron every 5 minutes to see if the
daemon is running, and if not, start it. See here:
#**************************************************************
# Check if daemon called checkmymail is running . . . .
#**************************************************************
oracle_up=`ps -ef|grep
checkmymail|grep -v grep|wc -l`;
oracle_num=`expr $oracle_up`
if [ $oracle_num -lt 1 ]
then nohup
/u01/mtscripts/checkmymail >2&1 &
fi
For more on scheduling UNIX jobs, see the Dr. Tim Hall book "Oracle
Job Scheduling"
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
