Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

0 Answers  


NNL-00302: Server restarting

1 Answers  


DRG-52108: failed to delete knowledge base user extension

1 Answers  


TNS-04009: %-25s | number

1 Answers  


ORA-27415: repeat interval must start with the FREQ= clause

1 Answers  






AMD-00141: parameter string of "string" not valid starting around "string"

1 Answers  


ORA-16561: Cannot remove an active instance.

1 Answers  


ORA-07701: sksatln: internal exception: output buffer too small

1 Answers  


ORA-01485: compile bind length different from execute bind length

1 Answers  


PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 Answers  


ORA-07208: sfwfb: failed to flush dirty buffers to disk.

1 Answers  


DRG-11129: the rule table is empty

1 Answers  






Categories