My Oracle Support Banner

EM 12c 13c:OEM Install Fails At OMSCA Configuration Step With Error "ORA-12504, TNS:listener was not given the SID in CONNECT_DATA" (Doc ID 2649436.1)

Last updated on AUGUST 31, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Issue :

When attempting to install the OMS is failing with the below error in the omsca configuration file.

omsca_<timestamp>.log
==================

Caused by: com.oracle.cie.domain.script.ScriptException: 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

 

Cause

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
Symptoms
Cause
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.