My Oracle Support Banner

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 later
Information 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


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