==================
General
==================
Bash script that takes 3 parameters, and returns 1 if connection was bad or zero if connection was good.
input:
- user
- password
- connection string
output
number 1/0
0 - OK
1 - Bad
#!/bin/bash
VIPUSER=$1
VIPPASS=$2
DB_INST=$3
#---------------------------------
#functions
#---------------------------------
report_error(){
db_user=$1
echo ==========================================
echo Error!!!
echo User $db_user Connection Check........Failed
echo Connection Error for User $db_user
echo ERROR: ORA-01017: invalid username/password. logon denied
echo Exiting script!
echo ==========================================
exit 1
}
report_success(){
db_user=$1
echo "User $db_user Connection Check........Passed"
}
#---------------------------------
#main
#---------------------------------
echo ==========================================
echo Check Connections Start
echo ==========================================
export OUTPUT_FILE=./chk_connections.log
rm -f $OUTPUT_FILE 2>/dev/null
touch $OUTPUT_FILE
echo "Check Connection for: ${VIPUSER}"
sqlplus -s ${VIPUSER}/${VIPPASS}@${DB_INST} >> $OUTPUT_FILE << EOD
set serveroutput on
set heading off linesize 130 pagesize 1000 feedback off
SELECT 'Connection is OK for '||USER FROM DUAL;
EOD
#----------------------------
# Analyze Connection Results
#----------------------------
#echo "OUTPUT_FILE=$OUTPUT_FILE"
#cat $OUTPUT_FILE
connection_ok=`grep "Connection is OK for" $OUTPUT_FILE | grep -iw ${VIPUSER} | wc -l`
if [[ $connection_ok != 1 ]];then
report_error ${VIPUSER}
ret_status=1
else
report_success ${VIPUSER}
ret_status=0
fi
rm -f $OUTPUT_FILE
echo ==========================================
echo Check Connections Finish
echo ==========================================
exit $ret_status
