Oracle Errors Interview Question:

ORA-12504: TNS:listener was not given the SID in CONNECT_DATA?

Submitted by: Administrator

Cause: The SID was missing from the CONNECT_DATA.

Action: Check that the connect descriptor corresponding to
the service name in TNSNAMES.ORA has an SID component in the
CONNECT_DATA.
Submitted by: Administrator