Records in this category
How do I monitor an Oracle database server?
You can monitor an Oracle Installation from our Monitor server if you install Oracle Instant Client and use the plugin check_oracle.pl.
check_oracle.pl is designed in co-operation with an Oracle DBA and focuses on automating common DBA-tasks.
check_oracle.pl depends on Oracle Instant Client and a user with sufficient access to the databases you want to monitor. The plugin can monitor:
- database availability (tnsping)
- login or dummy login
- cache hit ratio
- tablespace usage
- datafile usage
- total number of datafiles
- available extents per table or tablespace
- log archiving enabled or not
- user defined query, match for string or numeric value
- broken transactions
- failed transactions
- transactions in the deferred error queue
- invalid transactions
The plugin supports placing authentication credentials in an auth-file and can handle hostname as input instead of using a .ora-file for SID-lookups. Further information is available in our how-to "check_oracle with Oracle Instant Client".
- Which database is used internally by the system?
- Which web server is used internally by the system?
- Where are custom scripts stored?
- Is it possible to have root access on the server?
- What support is available for MySQL (locks, db fill-rate, load)?
- What support is available to monitor Microsoft Active Directory, AD?
- Is support available for monitoring IBM Servers X336, X335, X330, X306, X305?
- Is it possible to monitor SNMP-traps?
- Is there any sort of logging monitoring? What can really be done without LogServer?
- What support is there for monitoring Windows Event logs?
6223/17%Last update: 2012-05-21 15:37
Author: Support Team
You cannot comment on this entry