We have a production problem related to Oracle that occurs about once a month. We user Oracle RAC. Our DB team tends to make Oracle updates, bring Oracle nodes up and down at will. We normally don't have any warning. Our Middleware Oracle RAC connection configuration is supposed to seamlessly handle these conditions.
However, its not the case.
For instance, last night the Oracle system became unavailable. Many of our automated processes that use Oracle from Java hung. The processes did not stop, but something within the Java to Oracle interaction caused them to "Freeze".
We are looking for a way to detect this problem.
Would the Oracle Plugin help detect this problem?
If not, we notice that our log files stop updating. Is there a plugin that can monitor a specific log file for either a "keyword" or for "inactivity"?
thanks
John
Answer by John D. ·
Asad,
Hi. How can I obtain the Oracle plugin. We could really use it. We got hit with a tablespace issue today in our development environment and everybody blew a gasket.
Thanks
John D'Esposito
Answer by Asad A. ·
John,
There are two options that you can use here. First is to run a plugin that checks the availability of the Oracle instance. Second, to run a plugin that checks the inactivity in your log file.
For the first option, I have written a plugin where you can run any SQL command on a regular basis to check the availability of the Oracle instance.
For the second option, we have generic execution plugin that you can run periodically to check the log files. The way this plugin works is that it will run any system command for you. Hence you have to write a script that would check the activity on the log and let this plugin execute the script.
If you want to try the first option, please let me know and I will send you the DBCheck plugin.
JANUARY 15, 3:00 PM GMT / 10:00 AM ET