cat <<-'EOF' > check_start_db.sh
#!/bin/bash
HOSTMEI=$1
DBMEI=$2
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job start" | tee -a /tmp/check_start_db_$(date '+%Y%m').log
CNT=0
MAXCNT=30
while true; do
ssh ${HOSTMEI} "sudo su - -c '/u01/app/19.0.0/grid/bin/crsctl stat res ora.${DBMEI}.db'" 2>&1 | tee -a /tmp/check_start_db_$(date '+%Y%m').log
RET=$?
if [ ${RET} -ne 0 ] ; then
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job error( ${RET} )" | tee -a /tmp/check_start_db_$(date '+%Y%m').log
exit 100
fi
n=$(tail -n 2 /tmp/check_start_db_$(date '+%Y%m').log | grep "ONLINE.*ONLINE" | wc -l)
if [ ${n} -eq "1" ] ; then
break
fi
CNT=$((CNT+1))
if [ ${CNT} -ge ${MAXCNT} ] ; then
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job timeout" | tee -a /tmp/check_start_db_$(date '+%Y%m').log
exit 100
fi
sleep 60
done
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job end" | tee -a /tmp/check_start_db_$(date '+%Y%m').log
exit 0
EOF
cat check_start_db.sh
chmod +x check_start_db.sh
./check_start_db.sh mmdb131 crm
cat /tmp/check_start_db_$(date '+%Y%m').log
