How to fix the Oracle error TNS-01154: SID detected in old format that is no longer supported?

In this post, you’ll learn more about the Oracle ErrorTNS-01154: SID detected in old format that is no longer supported with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error TNS-01154: SID detected in old format that is no longer supported

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

How to fix the Error TNS-01154: SID detected in old format that is no longer supported ?

You can fix this error in Oracle by following the below steps

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