• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by John D. · Oct 11, 2012 at 08:01 PM · production

Production Oracle Issue- Can the Oracle Plugin Help?

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

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

2 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by John D. · Feb 08, 2013 at 06:36 PM

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

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Rick B. · Feb 08, 2013 at 07:49 PM 0
Share

https://apmcommunity.compuware.com/community/display/DL/Oracle+Monitor+Plugin

avatar image

Answer by Asad A. · Oct 24, 2012 at 10:33 PM

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.

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image John D. · Oct 25, 2012 at 12:10 AM 0
Share

Asad,

Hi. Thank you very much for the detailed reply. I would love to use the sql command plugin. Additionally, I will explore the generic execution plugin.

thanks

John

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Related Questions

Measurement consumption increase after Synthetic Test Integration for Dynatrace Application Monitoring: change 5 minutes interval?

Performance overhead of enabling bind value capturing and increase the SQL capture length

Internal web requests tracking

Extended Email Plugin stopped sending email suddenly

Where I can review outbound requests from server

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A