ORA-12504: TNS: listener

Question

185 views11/04/2023Oracle Database

0

Ezana886 08/04/2023 0 Comments

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

Write your answer.

score 0 · Answer 1 · 2023-04-11T17:24:14+00:00

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.