Original Message:
Sent: Mar 20, 2023 12:46 PM
From: Garin Walsh
Subject: Oracle Monitor
Those two items are parts of different products
You are looking for this:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/oracle-oracle-database-monitoring.html
for Oracle Server monitoring
Original Message:
Sent: Mar 20, 2023 10:30 AM
From: Paulo Pires
Subject: Oracle Monitor
What is the differente between these two monitoring tools, do I need both?
Oracle Database Monitoring
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/implementing-agents/infrastructure-agent/oracle-database-monitoring.html
Oracle RDBMS Services Monitor
https://techdocs.broadcom.com/us/en/symantec-security-software/endpoint-security-and-management/data-center-security-(dcs)/6-9/policies-v127947621-d3608e175970/oracle-rdbms-services-monitor-v127972428-d3608e196943.html
Thanks
Paulo
Original Message:
Sent: Mar 16, 2023 12:26 PM
From: Garin Walsh
Subject: Oracle Monitor
Well that depends....
At a very high level, there's the "oracle" probe which monitors the oracle server kind of from the perspective of an administrator.
You have the processes probe (and/or ntservices) where you can monitor the existence and resource usage of the various Oracle processes
You have the logmon probe where you can monitor the oracle logs for particular events
You have the CDM probe where you can monitor dis space used by Oracle
You have the jdbc_response probe where you can issue SQL against the Oracle server to query it
And back to logmon, you can use logmon to execute "scripts" so anything you could type at the command prompt could potentially become a source of data.
We mainly use jdbc_response and logmon monitoring log files to capture the events we care about.
And taking a step further back, based on a guess at the source of your question, there are two ways to approach "monitoring"- try to capture everything and then pick the interesting things out of it later or look at your historic issue and configure monitoring specifically to detect those historic issues.
Neither approach is better but if you are just starting out, and based on my personal experience, I would suggest that you want to go the route of trying to detect the handful of issues you historically see repeating. That makes the learning curve much shallower than the "configure everything at once" approach. It also helps driving acceptance because you can easily do the dog and pony show where you have the uncluttered presentation of "see, UIM detected this one issue".
Original Message:
Sent: Mar 16, 2023 11:39 AM
From: Paulo Pires
Subject: Oracle Monitor
Thank you Stephen Danseglio
Hi Garin Walsh
So, what I should use to monitor my oracle databases?
Thanks
Paulo
Original Message:
Sent: Mar 16, 2023 11:31 AM
From: Garin Walsh
Subject: Oracle Monitor
Just to follow on to Stephen Danseglio's comment, the oracle_logmon probe isn't a probe, it's a set of watchers intended to be used by logmon. They are ancient and even 10 years ago, well out of date.
It is worth looking at to see what was done but not especially useful today. And even as a starting point, there's the question about whether it's better to spend the time creating new or correcting the old. When We looked at this content, we decided to write new based on existing knowledge of what was relevant rather than trying to capture all.
Original Message:
Sent: Mar 16, 2023 10:58 AM
From: Stephen Danseglio
Subject: Oracle Monitor
Hi Paulo,
You can always download packages from support.nimsoft.com.
http://support.nimsoft.com/Default.aspx?center=felles/archive&state=ALL
http://support.nimsoft.com/Files/Archive/00078/oracle_logmon-1_02.zip
Note that the oracle_logmon probe hasnt been updated since 2003. Im not sure how valuable this will be for you...
Steve
------------------------------
Support Engineer
Broadcom
US
Original Message:
Sent: Mar 16, 2023 10:44 AM
From: Paulo Pires
Subject: Oracle Monitor
Dear Community,
For Oracle monitor, there's the two main probles:
CA UIM for Oracle probe
- https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/implementing-agents/infrastructure-agent/oracle-database-monitoring.html
- http://support.nimsoft.com/unsecure/archive.aspx?id=36
CA UIM Oracle-logmon probe
- Do you know the links for this one? Broadcom and Nimsoft?
Thanks
Paulo