My Oracle Support Banner

EM 13C : Installation Fails During OMS Configuration With Error ORA-12504, TNS:listener was not given the SID in CONNECT_DATA (Doc ID 2893819.1)

Last updated on SEPTEMBER 05, 2022

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 to 13.5.0.0.0 [Release 13c]
Information in this document applies to any platform.

Goal

 Enterprise Manager 13.X Cloud Control Installation fails during the OMS Configuration with the following error:

/OMS_HOME/cfgtoollogs/omsca/omsca_<timestamp>.log

Aug 23, 2022 9:14:59 PM oracle.sysman.omsca.util.CoreOMSConfigAssistantUtil execCommand
INFO: error messages of the command :
SEVERE: Exception: during EM deployment with template
Name of Exception: com.oracle.cie.domain.script.jython.WLSTException
Code of Exception: com.oracle.cie.domain.script.jython.WLSTException: Error updating domain:
64254: Error occurred in "OWSM Processing" phase execution
64254: Encountered error: oracle.mds.exception.MDSRuntimeException: MDS-00003: error connecting to the database
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

64254: Check log for more detail.
null
<traceback object at 2>
com.oracle.cie.domain.script.jython.WLSTException: Error updating domain:
64254: Error occurred in "OWSM Processing" phase execution
64254: Encountered error: oracle.mds.exception.MDSRuntimeException: MDS-00003: error connecting to the database
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

64254: Check log for more detail.
null
at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:3085) 

 $ lsnrctl status

Service "<DB>" has 1 instance(s).
Instance "<DB>", status READY, has 1 handler(s) for this service...
Service "<DB>" has 1 instance(s).
Instance "<DB>", status READY, has 1 handler(s) for this service...
The command completed successfully 

 

Solution

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
Goal
Solution
References


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