EMCA 11g Fails With Error "ORA-01017: invalid username/password; logon denied" and "invalid username/password; For DBSNMP or SYSMAN User" (Doc ID 741530.1)

Last updated on DECEMBER 15, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Creating DBConsole using EMCA commands fails while entering DBSNMP  or SYSMAN password.

Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user:


The EMCA command loops on sysman or dbsnmp password.

emca_YYYY_MM_DD_HH_MI_SS.log file shows below error message

Aug 5, 2008 1:38:34 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: ORA-01017: invalid username/password; logon denied

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01017: invalid username/password; logon denied

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1500)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1741)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2707)
....

Later in the logfile you see
Aug 5, 2008 1:38:34 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Listener is not up. Start the Listener and run EM Configuration Assistant again .
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2714)


# The dbsnmp/sysman user is using the default database profile
# Able to connect to the database from the dbsnmp user ( sqlplus dbsnmp/<password> suceeds )
# No password verification function.

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