Check DB connection

echo "Checking DB connection..."
echo "connect ${DBA_NAME}/${DBA_PASS}@${DB_NAME}"> ${ConnSql}
echo "spool ${SQL_LOG}" >> ${ConnSql}
echo "select * from global_name;" >> ${ConnSql}
echo "exit" >> ${ConnSql}

${ORACLE_BIN}/sqlplus -s /nolog @${ConnSql} > /dev/null

rm $ConnSql 2>/dev/null

if [ -z "`grep 'GLOBAL_NAME' ${SQL_LOG}`" ]; then
rm ${SQL_LOG}
echo "failed"
exit
else
rm ${SQL_LOG}
echo "ok"
fi