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

RMAN-12001: could not open channel string

1 Answers  


ORA-08236: smsget: cannot share subcube with listener

1 Answers  


PCC-02401: Host variable arrays of this type are currently not supported

1 Answers  


ORA-02751: osnfsmmap: cannot map shared memory file

1 Answers  


ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

1 Answers  






ORA-39103: Timeout before worker process string finished initialization. Worker error:

1 Answers  


ORA-08320: scnget: Call to scnget before scnset or scnfnd.

1 Answers  


ORA-12097: changes in the master tables during refresh, try refresh again

1 Answers  


ORA-06780: TLI Driver: recv error code failed

1 Answers  


IMG-00801: cannot extract height and width

1 Answers  


IMP-00002: failed to open string for read

1 Answers  


ORA-30445: workload queries not found

1 Answers  






Categories