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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2456


ORA-26027: unique index string.string partition string initially in unusable state

5405


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

1874


ORA-26028: index string.string initially in unusable state

2873


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

891






ORA-26082: load of overlapping segments on table string.string is not allowed

1042


ORA-26076: cannot set or reset value after direct path structure is allocated

1060


NZE-28868: Peer certificate chain check failed.

1868


ORA-26094: stream format error: input column overflow

1874


ORA-26095: unprocessed stream data exists

2197


RMAN-05017: no copy of datafile number found to recover

1383


ORA-26084: direct path context already finished

1091


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

1843


ORA-26030: index string.string had string partitions made unusable due to:

1223


ORA-26032: index string.string loading aborted after string keys

1226