EMCA 11.2 Fails with the Error "Database Connection Through Listener Failed. Fix The Error And Run EM Configuration Assistant Again." and "ORA-01017: invalid username/password; logon denied" (Doc ID 1930354.1)

Last updated on JULY 20, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The creation of the DB Control repository fails with "Database connection through listener failed. Fix the error and run EM Configuration Assistant again.":

The file $ORACLE_BASE/cfgtoollogs/emca_.log file shows:

Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: , oracleHome: /u01/app/oracle/product/11.2.0.3/db_1, and user: SYS
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-01017: invalid username/password; logon denied

Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.EMConfig perform
SEVERE: 

Database connection through listener failed. Fix the error and run EM Configuration Assistant again.

Some of the possible reasons may be: 

1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service is not registered with listener. Register the database service. 
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable. 
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=.
6) /etc/hosts does not have correct entry for hostname. 

Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/emca_2014_09_24_09_26_58.log for more details.
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace: 
oracle.sysman.emcp.exception.EMConfigException: 

Database connection through listener failed. Fix the error and run EM Configuration Assistant again.

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