What is the cause and solution for Oracle error ORA-12504: TNS: listener was not given the SID in CONNECT_DATA?
Amen Answered question 11/04/2023
Cause:
The SID was missing from the CONNECT_DATA.
Solution:
Check that the connect descriptor corresponding to
the service name in TNSNAMES.ORA has an SID component in the
CONNECT_DATA.
Amen Answered question 11/04/2023