Shell Programming and Scripting

#!/bin/bash

# values
USER=username
PASS=password
SIDORA=sid
LOG=/var/log/$SIDORA.log
DATUM=date
#Login to the DB
sqlplus -s /nolog <<EOF > tmpfile.log
connect $USER/$PASS@$SIDORA

select 1 from dual;

EOF

errorCode=$(head -2 tmpfile.log | awk '{ print $1 }' | grep 1)
# checks if the last operation (sqlplus) was completed successfully or not
if [ $errorCode != 1 ];

then
$DATUM >> $LOG
fi

#
# Using <<-EOF allows you to TAB (can not be spaces)
# the EOF over for code alignment, if necessary.
#
DB_STATUS=$(sqlplus -s /nolog <<-EOF
   connect $USER/$PWD@$DB

   set pages 0 trimout on trimspool on
   set echo off termout off sqlprompt ''

   select 1 from dual;

   exit

EOF)

EXIT_CODE=$?

if [[ "${EXIT_CODE}" -ne 0 ]] && [[ "${DB_STATUS}" -ne 1 ]]; then
   echo "Error mesage" >> ${LOG}
fi