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

QSM-01131: query has ONLY_MULTIMV_REWRITE hint

1 Answers  


ORA-13110: cannot drop topology with associated topo_geometry tables

1 Answers  


ORA-19550: cannot use backup/restore functions while using dispatcher

1 Answers  


ORA-19647: non-zero LEVEL cannot be specified when INCREMENTAL is FALSE

1 Answers  


ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers  






ORA-18004: outline already exists

1 Answers  


RMAN-08097: channel string: starting validation of archive log backupset

1 Answers  


NID-00420: Change of database name and ID failed during validation - database is intact.

1 Answers  


RMAN-06160: no backup pieces found for backup set key: number

1 Answers  


QSM-02148: many to many subquery joins require 9.0 compatibility or higher

1 Answers  


PLS-00122: %s as separator is allowed only with specific built-in functions

1 Answers  


ORA-00339: archived log does not contain any redo

1 Answers  


Categories