EM 13c: DBSNMP Account Getting Locked Frequently
(Doc ID 2613331.1)
Last updated on JULY 05, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
The DBSNMP user account is getting locked frequently in the target databases which are monitored by Enterprise Manager Cloud Control. Because of this, the password needs to be reset often and saved again in 'Monitoring Configuration' again. This will impact the target database monitoring.
$ <Agent_Base>/agent_inst/sysman/log/gcagent.log
2019-11-19 04:28:40,494 [141:66B3F7C0] DEBUG - Execution error:
oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Failed to connect: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.sysman.gcagent.addon.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:949)
at oracle.sysman.gcagent.target.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:433)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.executeQueryDescriptor(ExecuteTask.java:1208)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.runTask(ExecuteTask.java:3012)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.call(ExecuteTask.java:4263)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
em_error=Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host name>)(Port=<port>))(CONNECT_DATA=(SID=<SID>))): ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)
at oracle.sysman.gcagent.addon.fetchlet.osfetchlet.BaseOSFetchlet.getOSMetric(BaseOSFetchlet.java:1041)
at oracle.sysman.gcagent.addon.fetchlet.osfetchlet.BaseOSFetchlet.getMetric(BaseOSFetchlet.java:459)
at oracle.sysman.gcagent.target.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:433)
Cause
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
Symptoms |
Cause |
Solution |
References |