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


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



ORA-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 ?    1 Yes 6 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

1 Answers   CGI,


LFI-01517: open() failed(OSD return value = string).

1 Answers  


ORA-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


ORA-30748: column string already enabled to store objects of type string.string

1 Answers  


ORA-25461: rule set not specified

1 Answers  






ORA-12019: master table is a synonym to a remote object

1 Answers  


IMG-00518: invalid value for height or width

1 Answers  


ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.

1 Answers  


NZE-29042: Read buffer is not empty.

1 Answers  


ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

1 Answers  


RMAN-06177: restore not done; all files readonly, offline, or already restored

1 Answers  


ORA-23328: mview base table "string"."string" differs from master table "string"."string"

1 Answers  


Categories