Enterprise Manager Cloud Control Agent DBSNMP User shows Failed Login Attempt at Regular Intervals (Doc ID 1484748.1)

Last updated on DECEMBER 18, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The 'DBMSNP' user shows a failed login attempt with ORA-1017 in the database audit trail at regular intervals.  For example, the same time every night.  In the database the 'DBSNMP' user's password is set correctly for the database which is monitored via Cloud Control.  This can be checked from:-

 

Database Home Page/Expand 'Oracle Database' menu (underneath database name on home page)

Target Setup/Monitoring Configuration

Click on "Test Connection"

Shows "The connection test was successful"

The invalid login attempt will also be recorded when issuing the command "run discovery now" from:

When auditing is enabled on the database, the audit trail can be queried using:-

 

 

Cause

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