TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA

Hi,

Sometimes You can get “TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA ” error.

 

Details of error are as follows.

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>)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA

There are parenthesis up against the far left margin in the listener.ora file for a SID_LIST_<listener_name> portion of a listener configuration.  The SID_LIST_<listener_name> that is syntactically incorrect may not be attached to the listener that fails to start.  In other words, the SID_LIST belonging to a different listener configuration can cause the lsnrctl start <listener_name> to fail for any or all listeners in the listener.ora file.

The lsnrctl utility parses the entire file and fails to parse the incorrectly formed SID_LIST.

 

It will be necessary to review the entire listener.ora file for misplaced parenthesis in order to troubleshoot this issue.

Check the entire listener.ora file for parenthesis that are placed up against the far left margin for all the  SID_LIST configurations within the file.

Insert a space, not a TAB, between the far left margin and the opening parenthesis.

 

 

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *