RE: Database Link Timer (oh, one more thing)
- From: "Shawn Ferris" <shawn@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 24 Jun 2004 15:30:19 -0600 (MDT)
> http://www.oreilly.com/catalog/oracleperl/pdbatoolkit/
You could "try" some variation of this.. I do use this code, and it seems
to work.. YMMV
#!/bin/ksh
me=$$
# Ping the database
( ping_database.sh -s ORACLE_SID ) &
pingproc=$!
(
# Sleep for 60 seconds.. set it accordingly
sleep ${TIMEOUT:-60};
echo "Timed out waiting for ping to complete. Please check for " \
"defunct processes: (pingproc: ${pingproc}, me: ${me})";
ps -f;
kill -TERM ${pingproc} ${PPID} ${me} $$ >/dev/null 2>&1;
) &
sleepproc=$!
# Don't wait for the sleep.. or else it wont be cleared later
# (and fail everytime)
wait ${pingproc};
# This will (hopefully) clear out the sleep counter if the ping returns
# before the sleep completes.
kill -9 ${sleepproc}
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
