LOGIN_STATUS=`sqlplus -s /nolog <<SQLEND
connect ${UserName}/${PassWord}
set pagesize 1000 line 1000 feedback off verify off heading off echo off
spool /ednadtu3/u01/pipe/naveed/test/database/d1.txt
select sysdate from dual;
spool off;
exit;
SQLEND`

echo ${LOGIN_STATUS} |grep "ORA-" >> /dev/null

LOGIN_STATUS=$?

if (( $LOGIN_STATUS ))
then
     echo "Connected"
else
     echo "Problem connecting"
fi