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

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

Question Posted / guest

1 Answers
6299 Views
I also Faced
E-Mail Answers

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-08003: sequence string.NEXTVAL exceeds internal limits

1 Answers

DRG-10900: out of memory

1 Answers

ORA-28101: policy already exists

1 Answers

ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 Answers

ORA-06747: TLI Driver: error in listen

1 Answers

ORA-09876: TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.

1 Answers

ORA-02202: no more tables permitted in this cluster

1 Answers

NNC-00405: network failure

1 Answers

ORA-25446: duplicate column value for table alias: string, column: string

1 Answers

ORA-26013: List allocated may not be big enough

1 Answers

ORA-27031: mirror resilvering functions not supported

1 Answers

ORA-38472: VARCHAR representation of the data item is too long.

1 Answers

For more Oracle Errors Interview Questions Click Here