My Oracle Support Banner

Troubleshooting the EMCA Error "ORA-12514" "Listener is not up. Start the Listener and run EM Configuration Assistant again" When Creating or Dropping DBConsole (Doc ID 368591.1)

Last updated on MARCH 12, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 12-Feb-2014

Purpose

When using Enterprise Manager Configuration Assistant (EMCA) to configure or drop DBConsole, sometimes the following errors can be seen in the emca_<timestamp>.log file


Aug 22, 2008 6:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2008 6:41:23 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
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 notcurrently know of service requested in connect descriptor

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1771)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2707)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:368)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:221)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:534)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1214)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:518)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:467)
Aug 22, 2008 6:41:23 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /apps/ora11g/cfgtoollogs/emca/ORADB11G/emca_2008_08_22_06_40_44.log for
more details.
Aug 22, 2008 6:41:23 AM 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.checkListenerStatusFor



Could not connect to
SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTO =TCP)(HOST
=hostname.domain.com)(PORT=9404)))(CONNECT_DATA=(SERVICE_NAME=servicename.domain))):
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor (DBD ERROR: OCIServerAttach)


The error indicates that the service_name which the EMCA is trying to use, is not found with the listener. There are several possible causes for the error message ORA-12514.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
References

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