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

Lookup values

Values, states and texts defined in the lookup files of this sensor.

Lookup file: itesys.oracledataguardmonitor.dbmode.ovl

Value	State	Description
0	OK	Started
1	OK	Mounted
2	OK	Mounted Standby
3	OK	Open
4	OK	Open read-only

Lookup file: itesys.oracledataguardmonitor.dbprotectionmode.ovl

Value	State	Description
0	OK	Maximum Protection
1	OK	Maximum Availability
2	OK	Resynchronization
3	OK	Maximum Performance
4	Warning	Unprotected

Lookup file: itesys.oracledataguardmonitor.dbrecoverymode.ovl

Value	State	Description
0	OK	Idle
1	OK	Managed
2	OK	Managed with query
3	OK	Managed real time apply
4	OK	Managed real time apply with query
5	OK	Logical real time apply
6	OK	Logical apply

Lookup file: itesys.oracledataguardmonitor.dbrunonprimary.ovl

Value	State	Description
0	OK	Yes
1	Warning	No

Lookup file: itesys.oracledataguardmonitor.dbstatus.ovl

Value	State	Description
0	OK	Valid
1	Warning	Inactive
2	Warning	Deferred
3	Error	Error
4	Error	Disabled
5	Warning	Bad Param
6	Warning	Alternate
7	Error	Full

Lookup file: itesys.oracledataguardmonitor.dbsyncstatus.ovl

Value	State	Description
0	OK	Check Configuration
1	Warning	Check Standby Redo Log
2	Warning	Check Network
3	Warning	Destination Has a Gap
4	OK	OK
5	Warning	Not available

Lookup file: itesys.oracledataguardmonitor.dbtype.ovl

Value	State	Description
0	OK	Local
1	OK	Physical

Important notes

warning

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

Troubleshooting

Error Code	Error Message	Possible Solution
[SCN-098-000]	The following parameters has not been provided: <parameters> Please read the sensor documentation for further information!	Specify the listed parameters in the profile or in the sensor-specific parameters.
[SCN-098-051]	No Oracle Data Guard is configured.	The database has no Data Guard configuration. Check if the sensor is pointed to the correct database.
[SCN-098-151]	Could not connect to the Oracle database: <message>	The connection to the primary database failed. Check the parameters Host, DBPort, DBName, DBUsername and DBPassword.
[SCN-098-152]	Could not connect to the Oracle standby host, parameter has no value.	Specify the standby host in the parameter StandbyHost.
[SCN-098-153]	Could not connect to the Oracle database: <message>	The connection to the standby database failed. Check the parameter StandbyHost and that the standby database is reachable with the same credentials.
-	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