Oracle Monitor

Monitors the backups and tablespaces of an Oracle database

General

Executable	Oracle_Monitor.exe
Connection method	ODP.NET
Ports	1521
Lookup files	itesys.oraclemonitor.lastbackupsap.ovl itesys.oraclemonitor.lastcheckdb.ovl

Default parameters

Parameter name	Possible values	Default	Description
Host	<ip> | <hostname>	empty	Hostname or IP of the target system. If you use a virtual hostname on your SAP servers, please use also the virtual host to connect.
DBName	string	empty	Name of the database
DBUsername	string	empty	Database user
DBPassword	string	empty	Password of the database user

Sensor-specific parameters

Parameter name	Possible values	Default	Description
Days	number | 0 - n	10	Past days for which the backup is to be checked
SAP_Schemaowner	string | &lt;username&gt;	DBUsername	SAP DB Schema Owner, if <DBUsername> parameter is not the owner
IsSAP	true | false	true	Defines whether the backup should be checked via SAP or not
IncrBackupsUsed	no | yes	no	To monitor the status of incremental backups

Channels

Channel name	Description	Lookup file
Successful Backups	Number of successful backups in the past <days>
Warning Backups	Number of backups with status "Warning" in the past <days>
Running Backups	Number of backups with status "Running" in the past <days>
Error Backups	Number of backups with status "Error" in the past <days>
Last Backup	Status of the last data backup. OK: successful OK: running Warning: no backups Warning: undefined status Error: failed	itesys.oraclemonitor.lastbackupsap.ovl
Successful Checks	Number of successful checks in the past <days>
Warning Checks	Number of checks with status "Warning" in the past <days>
Running Checks	Number of checks with status "Running" in the past <days>
Error Checks	Number of checks with status "Error" in the past <days>
Last Check	Status of the last check. OK: successful OK: warning OK: running Warning: no CheckDB Warning: error	itesys.oraclemonitor.lastcheckdb.ovl
<TABLESPACE> - % free	Free space in the tablespace <TABLESPACE>
<TABLESPACE> - Total size	Total size of tablespace <TABLESPACE>
Successful Incr Backups	Number of successful incremental backups in the past <days>
Warning Incr Backups	Number of incremental backups with status "Warning" in the past <days>
Running Incr Backups	Number of incremental backups with status "Running" in the past <days>
Error Incr Backups	Number of incremental backups with status "Error" in the past <days>
Last Incr Backup	Status of the last incremental backup. OK: successful OK: running Warning: no backups Warning: undefined status Error: failed	itesys.oraclemonitor.lastbackupsap.ovl

Important notes

warning

Please check the channel limits in PRTG if they fit for your alerting.

Troubleshooting

Symptom	Possible solution
Error message Table &lt;SAPSchemaOwner&gt;.sdbah not present or user &lt;DBUsername&gt; has insufficient privileges!	Check if <DBUsername> is the SAP schema owner Check if <DBUsername> has SELECT privilege on SAP table sdbah

FAQ

Question	Answer
Does the channel <TABLESPACE> - % free show the filling degree of the current tablespace size or of the maximum tablespace size?	The channel <TABLESPACE> - % free shows the filling degree of the maximum tablespace size. This is because if Autoextend is activated on the data files and the increment size is small, the value of the channel would always be near to 100%.
How can I check what the name of the schema owner is?	When you schedule the DB backups via SAP (BR tools), you can run the following SQL statement (e.g. via sqlplus or in SAP). select owner from dba_tables where table_name = 'SDBAH';
How can I figure out which port number the Oracle DB is using?	You can run the following SQL statement (e.g. via sqlplus or in SAP). select * from v$listener_network;

Changelog

Version	Changes
2024.07	Sometimes wrong values were shown when using specific region settings
2023.09	The total size of tablespaces was empty when size is 0
2022.12	No error occurs anymore if tablespace is not in space metrics table
2021.03	You don't get "insufficient privileges" errors anymore when a tablespace is empty (e.g. for PSAPUNDO). Added new parameter “IncrBackupsUsed” Added new channels for checking the status of incremental backups "… Incr Backup(s) "
1.4.0.4	Optimized query for tablespace sizes to prevent error that some tablespaces will not show up in special cases
1.4.0.1	Rebuild for new signature of AddChannel method
1.4.0.0	Build for installer 1.4.0
1.3.7.1	Fixed output in case of no backup / checkDB. Adjusted ovl files accordingly
1.3.7.0	Removed error outputs by error attribute and added limits instead Added channels Last Backup and Last Check with lookup files Changed table dba_segments to dba_free_space to get free tablespace bytes due to performance
1.3.6.1	Correction of SQL statement for collecting tables space information
1.3.6.0	First stable release