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

ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


ORA-24758: not attached to the requested transaction

1 Answers  


ORA-01941: SEQUENCE keyword expected

1 Answers  


ORA-19673: error during proxy copy of file string

1 Answers  


ORA-07286: sksagdi: cannot obtain device information.

1 Answers  






ORA-00263: there are no logs that need archiving for thread string

1 Answers  


RMAN-06409: LIKE clause in LIST BACKUP OF ARCHIVELOG is not supported

1 Answers  


LFI-01000: Unable to write line to file.

1 Answers  


ORA-28134: object cannot have fine-grained access control policy

1 Answers  


ORA-31428: no publication contains all the specified columns

1 Answers  


ORA-00101: invalid specification for system parameter DISPATCHERS

1 Answers  


TNS-00224: No more connections available

1 Answers  


Categories