#!/bin/ksh # ----------------------------------------------------------------------- # Filename: wait4ora.ksh # Purpose: Sleep until a database becomes available # Author: Frank Naude, Oracle FAQ # ----------------------------------------------------------------------- LOG=$0.log SLEEP_TIME=60 if [ ! -t 0 ]; then # Write output to log if we run from cron exec 1>>${LOG} 2>&1 fi if [ "${1}" = "" ]; then echo "USAGE: Please supply a database name..." exit fi unset TWO_TASK export ORACLE_SID=${1} export ORACLE_HOME=`grep -i "^${1}:" /etc/oratab|cut -d: -f2 -s` export PATH=$ORACLE_HOME/bin:$PATH echo "" echo "Waiting for database $1 to become available..." echo "Database: $ORACLE_SID Home: $ORACLE_HOME" while : do sqlplus -s >/dev/null 2>&1 "monitor/monitor" <