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


TNS-01154: SID detected in old format that is no longer
supported



TNS-01154: SID detected in old format that is no longer supported..

Answer / guest

Cause: One of the SIDs was specified in an obsolete format.

Action: Check LISTENER.ORA for a line of the form: <sid> =
(SID=(ORACLE_HOME=<oracle_home>)) OR <sid> =
(SID_DESC=(ORACLE_HOME=<oracle_home>)) The above format is
no longer supported and SID_LIST_<listener_name> format
described in the Oracle9i Net Services Reference Guide
should be used. For example, SID_LIST_LISTENER =
(SID_LIST=(SID_DESC=(SID_NAME=<sid>)(ORACLE_HOME=<oracle_home>)))

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13040: failed to subdivide tile

1 Answers  


RMAN-06096: SWITCH required for newname of datafile string to take effect

1 Answers  


TNS-00019: INTCTL: error initializing the national language interface

1 Answers  


ORA-00132: syntax error or unresolved network name 'string'

1 Answers  


NZE-29003: SSL transport detected mismatched server certificate.

1 Answers  






ORA-31015: Attempted to insert entry without name

1 Answers  


SQL*Loader-00914: Error locking table string in exclusive mode.

1 Answers  


QSM-02006: subquery in FROM list

1 Answers  


NNO-00053: duplicate domain description for domain "string"

1 Answers  


ORA-13295: geometry objects are in different coordinate systems

1 Answers  


SQL-02143: Target object has not been properly allocated

1 Answers  


KUP-03019: directory object not specified in LOBFILE clause for field string

1 Answers  


Categories