EM 12c, EM 13c: How to set the monitoring credentials for the database in Enterprise Manager Cloud Control (Doc ID 1929492.1)

Last updated on MAY 06, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Goal

To set the monitoring credentials for a target database in Enterprise Manager (EM) 12c and 13c via the console

Background

The monitoring credentials are the username/password combination which are used by Enterprise Manager to log into the database in order to run sql statements specified by the metric collections.  The 'dbsnmp' user is normally used for the monitoring user.  Sometimes it may be necessary to use a sysdba user for the monitoring user (for example, in the case of data guard/standby database).  See <Note:1534896.1> "How to set the Monitoring Credentials for a Standby Database in Cloud Control" for further details on data guard.

The monitoring credentials are normally specified at discovery time (at the time when the database is first added to EM Cloud Control).  However, it is possible that the dbsnmp password could be subsequently changed on the database, and so becomes out of sync with the credentials set in EM.  When this happens, the database metrics would fail to run and would generate the error "ORA-01017: invalid username/password; logon denied".   It's also possible to see other errors reported such as "ORA-28001: The password has expired" or "ORA-28000: the account is locked"

 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms