Oracle DataGuard Monitor

Monitors the status of the Oracle Data Guard cluster

General

Executable	Oracle DataGuard Monitor.exe
Connection method	ODP.NET
Ports	1521
Lookup files	itesys.oracledataguardmonitor.dbmode.ovl itesys.oracledataguardmonitor.dbprotectionmode.ovl itesys.oracledataguardmonitor.dbrecoverymode.ovl itesys.oracledataguardmonitor.dbrunonprimary.ovl itesys.oracledataguardmonitor.dbstatus.ovl itesys.oracledataguardmonitor.dbsyncstatus.ovl itesys.oracledataguardmonitor.dbtype.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
StandbyHost	<hostname>:<port>	empty	Standby database connection details. Provide the host name and port

Channels

Channel name	Description	Lookup file
Running On Primary	Shows if the DB is running on the primary location OK: yes Warning: no
DataGuard Errors	Displays the amount of errors with severity of error or fatal.
<standby DB> - Status	Displays the status of the standby database OK: valid Warning: inactive Warning: deferred Warning: bad param Warning: alternave Error: error Error: disabled Error: full
<standby DB> - Type	Displays the type of the standby database OK: Local OK: Physical
<standby DB> - Database Mode	Displays the configured database mode of the standby database OK: Started OK: Mounted OK: Mounted Standby OK: Open OK: Open read-only
<standby DB> - Recovery Mode	Displays the configured recovery mode of the standby database OK: Idle OK: Managed OK: Managed with query OK: Managed real time apply OK: Managed real time apply with query OK: Logical real time apply OK: Logical apply
<standby DB> - Protection Mode	Displays the protection mode of the standby database OK: Maximum Protection OK: Maximum Availability OK: Resynchronisation OK: Maximum Performance Warning: Unprotected
<standby DB> - Synchronization Status	Displays the synchronization status of the standby database OK: Ok OK: Check Configuration Warning: Check Standby Redo Log Warning: Check Network Warning: Destination Has a Gap Warning: Not Available
<standby DB> - Transferred Logs Gap	Number of logs which haven’t been transferred to standby database
<standby DB> - Applied Logs Gap	Number of logs which haven’t been applied to standby database

Important notes

warning

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

Troubleshooting

Symptom	Possible solution
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'; Example result: SAPSR3DB
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; Example result: LOCAL LISTENER (ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)) SERVICE NAME OR1

Changelog

Version	Changes
2023.09	Initial release