My Oracle Support Banner

EM 12c: DBSNMP Session Generating "ORA-01017: invalid username/password; logon denied" Everyday Around the Same Time (Doc ID 2639068.1)

Last updated on FEBRUARY 20, 2020

Applies to:

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

Symptoms

EM 12c

Everyday around the same time, DBSNMP Session is generating an error: ORA-01017: invalid username/password; logon denied

Example:

SELECT username,userhost,OS_USERNAME,TERMINAL,OS_PROCESS,to_char(timestamp,'yyyy/mm/dd,hh24:mi'),returncode
FROM dba_audit_session
WHERE RETURNCODE IN (1017, 28000) and
to_char(timestamp,'YYYY-MM-DD HH24:MI:SS') >= '2020-02-06 00:00:00' and
to_char(timestamp,'YYYY-MM-DD HH24:MI:SS') < '2020-02-06 23:59:00'
ORDER BY to_char(timestamp,'yyyy/mm/dd,hh24:mi');

USERNAME          USERHOST      OS_USERNAM TERMINAL OS_PROCESS                                 TO_CHAR(TIMESTAM       RETURNCODE
--------------- --------------- ----------     ------------------------------ -------------------- ----------------       ----------
DBSNMP         <AgentHostName>        oracle                   5701970                                         2020/02/06,22:54         1017

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


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