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

DRG-50804: failed to exec cursor

1 Answers  


ORA-16523: Operation requires the client to connect to instance "string".

1 Answers  


ORA-25008: no implicit conversion to LOB datatype in instead-of trigger

1 Answers  


DRG-10595: ALTER INDEX string failed

1 Answers  


ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

1 Answers  


ORA-00310: archived log contains sequence string; sequence string required

1 Answers  


LSX-00238: invalid Nmtoken "~S"

1 Answers  


ORA-06807: TLI Driver: could not open ethernet device driver file

1 Answers  


ORA-16008: indeterminate control file checkpoint

1 Answers  


ORA-13281: failure in execution of SQL statement to retrieve WKT

1 Answers  


ORA-09988: error while detaching SGA

1 Answers  


LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers  


Categories