EMCA fails with ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (Doc ID 1341749.1)

Last updated on JULY 21, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 18-Feb-2014

Symptoms


DBConsole 11.2.0.2 configuration failed with the following error:

CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl (SQLEngine.java: 1655)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql (SQLEngine.java: 1903)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl (ParamsManager.java: 3230)
at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount (EMReposConfig.java: 1001)
at oracle.sysman.emcp.EMReposConfig.invoke (EMReposConfig.java: 346)
at oracle.sysman.emcp.EMReposConfig.invoke (EMReposConfig.java: 158)
at oracle.sysman.emcp.EMConfig.perform (EMConfig.java: 253)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA (EMConfigAssistant.java: 590)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration (EMConfigAssistant.java: 1453)
at oracle.sysman.emcp.EMConfigAssistant.statusMain (EMConfigAssistant.java: 574)
at oracle.sysman.emcp.EMConfigAssistant.main (EMConfigAssistant.java: 522)
07/21/2011 15:19:00 oracle.sysman.emcp.EMConfig perform
SEVERE: The listener is not started, or the database service is not registered with it. Start the listener, register the database service, and run the EM configuration wizard 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