Monitoring Weblogic Datastore Connectivity

If weblogic application deployed seems to have intermittent issue of datastore errors, We can monitor the datastore ping to find the reason for database connectivity failure using below sample script that I used to monitor my database connectivity from the weblogic server.every 5 mins

.  /home/oracle/init_AJITH_wl.sh

while true()

do

java -classpath $WL_HOME/server/lib/weblogic.jar utils.dbping ORACLE_THIN apps ******* ajithpathiyil1.lab.com:1521:ajithpathiyil1 > /tmp/chknet.out

java -classpath $WL_HOME/server/lib/weblogic.jar utils.dbping ORACLE_THIN apps ******* ajithpathiyil1.lab.com:1521:ajithpathiyil1 >> /tmp/chknet.out

grep "**** Success!!! ****" /tmp/chknet.out

if [ $? -ne 0 ] then

cat /tmp/chknet.out | /bin/mail -s "Erec:Issue" ajithpathiyil@gmail.com

fi

sleep 300

done

HAPPY LEARNING!