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

NZE-28785: parameter does not exist

1 Answers  


ORA-25138: %s initialization parameter has been made obsolete

1 Answers  


ORA-19568: a device is already allocated to this session

1 Answers  


QSM-01048: join back level(s) not present (string)

1 Answers  


ORA-23410: materialized view "string"."string" is already in a refresh group

1 Answers  






ORA-29663: Unable to find a method that matches one or more of the functions

1 Answers  


ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

1 Answers  


KUP-04081: field string used in concatenation for column string is not a character type

1 Answers  


RMAN-06193: connected to target database (not started)

3 Answers  


ORA-27204: skgfpqr: sbtpcqueryrestore returned error

1 Answers  


ORA-15124: ASM file name 'string' contains an invalid alias name

1 Answers  


ORA-16623: stale DRC UID sequence number detected

1 Answers  


Categories