Shell Programming and Scripting

 
 
for DB in 1 2 3 
do

(sqlplus -s ${USERNAME}/${PASSWORD}@${DB}  << EOF
whenever sqlerror exit  255 rollback;
WHENEVER SQLERROR EXIT SQL.SQLCODE ;
quit;
EOF
)
if [ $? -eq 0 ]
then
echo " connectivity for ${DB} is OK"
else
echo " Connection failed for ${DB} "
fi
sleep 1
done

Out=`sqlplus -s ${USERNAME}/${PASSWORD}@${DB} << EOF
set echo off head off feed off pagesize 0 trimspool on linesize 1000
select 'OK' from dual;
exit;
EOF`

if [ "$Out" = "OK" ]
then
        echo "Connectivity OK"
else
        echo "Connectivity FAILED"
fi

 
for DB in 1 2 3 4 5
do
var=`sqlplus -s ${USERNAME}/${PASSWORD}@${dbname} << EOF
set echo off;
set head off;
set feedback off;
set pagesize 0;
set trimspool on ;
select 'OK'  from dual;
exit;
EOF`
if [ "$var" = "OK" ]
then
echo " connectivity for $dbname is OK.............."
else
echo " Connection for $dbname is FAILED............... "
fi

 
connectivity for DB1 is OK..............