My Oracle Support Banner

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 MARCH 31, 2018

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and later
Information 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.