An Oracle database can be started in several different states, but READ WRITE is the most common. To ensure the database remains in a READ WRITE state, you can create a custom alert within DPA to detect any other status using the attached query. This query will return 0 (false) if the status is READ WRITE and 1 for any other status and alert you.
To create the alert, create a Custom SQL Alert - Single Numeric Return and paste in this query. You can use 1 as your Min threshold for the High status and assign a contact or contact group to get notified.
