EM 12c, EM 13c: Troubleshooting the Dataguard Standby Database Instance with Down Status in Enterprise Manager 12c and 13c
(Doc ID 2000383.1)
Last updated on AUGUST 20, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and laterInformation in this document applies to any platform.
Purpose
shown here are some of the factors which can cause the standby database to appear with Down status in Enterprise Manager (EM) Cloud Control.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Troubleshooting Steps |
| 1) Check that the standby database is monitored using the SYSDBA role and that Test Connection function works |
| If Test Connection fails, check that the correct SYSDBA password is known for the standby. |
| a) Check that the user has sysdba rights. |
| b) Check that the database initialization parameter "remote_login_passwordfile" is set to EXCLUSIVE |
| c) Check that the password file exists |
| d) See if the password is case sensitive |
| 2) If the Test Connection using SYSDBA role Works (but database is showing as Down) |
| Check the real time results of the Response metric (this metric is responsible for calculating the database status). |
| Find out what status the agent has determined for the Response Metric |
| a) Run the Response metric manually |
| b) run the clearstate command for this particular metric |
| c) If the above doesn't help |
| References |