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

While starting listener getting error 

ora12c@Server1 admin]$ lsnrctl start LISTENER

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-AUG-2017 11:11:45

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /rdbms/app/12.1.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /rdbms/app/12.1.0/grid/network/admin/listener.ora
Log messages written to /rdbms/app/12.1.0/grid_base/diag/tnslsnr/Server1 /listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1 .vsnl.co.in)(PORT=1527)))
TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA

Listener failed to start. See the error message(s) above...

Solution :

If you look into log.xml file , you get to know below message

<msg time='2017-08-03T11:11:45.885+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='Server1 .vsnl.co.in'
 host_addr='x.x.x.x'>
 <txt>TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA
 </txt>
</msg>
<msg time='2017-08-03T11:11:45.885+05:30' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='Server1 .vsnl.co.in'
 host_addr='x.x.x.x'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1 .vsnl.co.in)(PORT=1527)))
 </txt>
</msg>

set asm profile and edit in listener.ora file.

VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Server..co.in)(PORT = 1527))
    )
  )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET



Thats it :)





No comments:

Post a Comment