Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

TNS-01192

Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA

Cause

SID description in LISTENER.ORA had an error in it.


Action

Make sure the lines of code in LISTENER.ORA containing SID_DESC or SID begin with SID_LIST_<listener_name> on the left side of the equation. For example, SID_LIST_LISTENER =(SID_LIST=(SID_DESC=(SID_NAME=sid)(ORACLE_HOME=<oracle_home>)))