Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Saturday, February 28, 2015

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!

No comments:

Post a Comment

Thanks for you valuable comments !