Shell Programming and Scripting

#!/usr/bin/bash
. /etc/profile.local
. /usr/local/lib/job_functions
. /infa_shared/infadev_d2/ShellScripts/xxx/bin/set_env
export foldername='m'
export wfname='s'
flag='N' #value used to test if DB connection is sucessfull, default is no
uid=bbb #userid for the Database
pwd=111 #password for Database
hostname=yyy #Hostname of the Database
while [ ! -f /user/shiv/flag.trg ] #while loop,loop untill flag is set to Y
do
  sqlplus -s /nolog <<ENDSQL
  connect bbb/111@yyy
  WHENEVER SQLERROR EXIT SQL.SQLCODE
  WHENEVER OSERROR EXIT 10
  EXIT;
  ENDSQL
  if [ $? -eq 0 ]
  then
    echo 'connected OK'
    . /infa_shared/infadev_d2/ShellScripts/xxx/bin/execute_workflow $foldername $wfname
    touch /user/shiv/flag.trg #Set the flag to Y to exit the loop as the workflow is complete
    chmod 777 /user/shiv/flag.trg
  else
    echo 'connection FAIL'
    sleep 10 #Sleep for 10 secs and again loop through
  fi
done
rm /user/shiv/flag.trg

-bash-3.00$ DB_Connection
ERROR:
ORA-01017: invalid username/password; logon denied

connected OK
-bash-3.00$

while [ ! -f /user/shiv/flag.trg ] #while loop,loop untill flag is set to Y
do
  sqlplus -s /nolog <<ENDSQL
  connect bbb/111@yyy
  WHENEVER SQLERROR EXIT SQL.SQLCODE
  WHENEVER OSERROR EXIT 10
  EXIT;
ENDSQL

...
while [ ! -f /user/shiv/flag.trg ] #while loop,loop untill flag is set to Y
do
  sqlplus -s /nolog <<ENDSQL
  WHENEVER SQLERROR EXIT SQL.SQLCODE
  WHENEVER OSERROR EXIT 10
  connect bbb/111@yyy
  EXIT;
ENDSQL
...