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

oracle

TNS-01154: SID detected in old format that is no longer supported
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 Administrator's Guide should be used. For example:

 SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=sid)(ORACLE_ HOME=oracle_home)))

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/