Solaris

 
count=0
while [ $count -lt 3 ]; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
DBMS_OUTPUT.put_line('Connected to db');
EOF
conn_code=$?
if [ $conn_code != 0 ];then
count=`expr $count + 1`
else
break
fi
done
if [ $count = 2 ];then
logfn "Database connectivity is not working fine....check the username/password"
exit 0;
fi
logfn "Database connectivity is working fine"

 
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-C <v>] [-L] [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_identifier>] | / | /NOLOG
      <start>  ::= @<URL>|<filename>[.<ext>] [<parameter> ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-C" sets SQL*Plus compatibility version <v>
        "-L" attempts log on just once
        "-M <o>" uses HTML markup options <o>
        "-R <n>" uses restricted mode <n>
        "-S" uses silent mode

echo trying to connect to dbSID with user: $username and password $password
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
DBMS_OUTPUT.put_line('Connected to db');
EOF

#!/bin/ksh

export logfile=t.log

count=0
while [ $count -lt 3 ]; do

     sqlplus -s $usrname/$password <<-EOF >> $logfile
     WHENEVER OSERROR EXIT 9;
     WHENEVER SQLERROR EXIT SQL.SQLCODE;
     SET SERVEROUT ON SIZE 1000000
     DECLARE
     BEGIN
     DBMS_OUTPUT.ENABLE(1000000);
     DBMS_OUTPUT.put_line('Connected to db');
     END;
/
EOF

 conn_code=$?
 if [ $conn_code -ne 0 ]; then
    count=`expr $count + 1`
 else
    break
 fi
done
if [ $count -eq 2 ]; then
  logfn "Database connectivity is not working fine....check the username/password"
  exit 0;
fi
logfn "Database connectivity is working fine"

PRO[MPT] [text]