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 09, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.4.0 and laterInformation 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> "EM 13c, EM 12c : 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
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
Goal |
Background |
Solution |
References |