• 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 /
  • Dynatrace /
  • Dynatrace Open Q&A /
avatar image
Question by Yann B. · Oct 07, 2019 at 08:12 AM · database process groups aix

Monitoring Oracle Database as a process on AIX

Good morning everyone,

I'm looking for details about the way the Oneagent for AIX is monitoring istances of Oracle Db as processes.

When I install Oneagent many Oracle DB processes are discovered as in the image below:


On the HOST-A where Oneagent was installed I do have one istance of an Oracle DB (dw2); but the same agent is discovering another Oracle DB istance (dw1) that I know it isn't on HOST-A.

As a matter of fact when I ps on the system this is the result:

[HOST-A@oracle /home/oracle]>ps -ef |grep pmon

oracle 12845310 1 0 00:59:56 - 0:02 ora_pmon_dw2

But oneagent is reading the presence of dw1:

(that I know is on another host [HOST-B]) as command ps shows:

[HOST-B@oracle /home/oracle]>ps -ef |grep pmon

oracle 29425886 1 0 Oct 01 - 0:13 ora_pmon_dw1

My question are:

-how oneagent is monitoring this Oracle Database istances?

-what command does it use for monitoring these processes?

-as in my case: can it be wrong to see a particular process that is not present on my Host?

Thank you for your time


istancedb.png (41.4 KiB)
dw1.png (47.1 KiB)
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.

1 Reply

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

Answer by Sebastian K. · Oct 07, 2019 at 09:22 AM

Databases are monitored transactionally only from application endpoint (ADO.NET, JDBC etc). Installing agent on Oracle host will give you only metrics related to host and process performance (without oracle specific metrics).

Here you have info about ActiveGate plugins that is responsible for collecting technology specific metrics related to oracle:

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/analysis/database-insights/

Sebastian

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 Yann B. · Oct 07, 2019 at 10:46 AM 0
Share

Thank you Sebastian,

in my case I installed the agent on the Oracle Host but I'm wondering how it collect data for Oracle processes since in my case it doesn't seem to do the job properly.

As an example I posted the fact that the agent is descovering a DB process named dw1 on the HOST-A but if I do ps -ef |grep pmon I'm only "grepping" ora_pmon_dw2.

So I need more insight to understand how oneagent is taking this data (See my questions above)

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

30 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

How can I configure a Dynatrace plugin without using the Dynatrace UI?

Dynatrace for WebMethods 10.1

Not able to detect Process on AIX host

Capture the database ActiveConnectionsCurrentCount for WebLogic datasources

How can we disable getting database statements?

Forum Tags

mobile monitoring dotnet iis chat kubernetes servicenow amazon web services feedback mysql mainframe application rules rest api cassandra dashboard oneagent sdk cmc application monitoring openkit smartscape request attributes monitoring developer community user tagging log monitoring services ufo activegate auto-detection high five award uem webserver usql iib test automation license ios news migration management zones ibm mq web services notifications sso host monitoring knowledge sharing reports browser monitors java hybris sap vmware maintenance window user action naming javascript appmon ai availability tipstricks automation extensions diagnostic tools session replay permissions search davis assistant auto-update faq documentation problem detection http monitors easytravel apdex network docker tags and metadata cloud foundry google cloud platform synthetic monitoring process groups account usability dynatrace saas gui paas openshift key user actions administration production user actions postgresql synthetic locations upgrade oneagent security Dynatrace Managed user management python technologies mongodb openstack user session monitoring continuous delivery citrix configuration alerting performance monitoring NGINX action naming linux nam installation error reporting database mission control apache mobileapp RUM php azure purepath davis scripting aix nodejs android
  • 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