8 Replies Latest reply: Feb 12, 2014 1:47 AM by 990991 RSS

    TNS-01155: Incorrectly specified SID_LIST_LISTENER_DB2 parameter in LISTENER.ORA

    990991

      Hi.. i configured listener on standby.. it was working fine... yesterday( next day).. when i was trying to start it.. it was showing below errors.. below pasted the listener file on standby and the two errors i`m facing.... please provide any solution..

       

      Note:The listener and TNS on Primary is working fine...

       

      [oracle@RHEL2 admin]$ lsnrctl start LISTENER_DB2

       

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-FEB-2014 10:57:25

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

      Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

      Log messages written to /home/oracle/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/RHEL2/listener_db2/alert/log.xml

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL2)(PORT=1521)))

      TNS-01155: Incorrectly specified SID_LIST_LISTENER_DB2 parameter in LISTENER.ORA

      NL-00303: syntax error in NV string

       

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

      [oracle@RHEL2 admin]$

      ----------------------------------------------------------------------------

      CHECKED IN LISTENER LOG

       

      [oracle@RHEL2 dbhome_1]$ tail -100 log/diag/tnslsnr/RHEL2/listener_db2/alert/log.xml

       

      <msg time='2014-02-09T11:01:32.407+05:30' org_id='oracle' comp_id='tnslsnr'

      type='UNKNOWN' level='16' host_id='RHEL2'

      host_addr='127.0.0.1'>

      <txt>Listener completed notification to CRS on start

      </txt>

      </msg>

      <msg time='2014-02-09T11:01:32.407+05:30' org_id='oracle' comp_id='tnslsnr'

      type='UNKNOWN' level='16' host_id='RHEL2'

      host_addr='127.0.0.1'>

      <txt>

      TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

      </txt>

      </msg>

      <msg time='2014-02-09T11:01:32.407+05:30' org_id='oracle' comp_id='tnslsnr'

      type='UNKNOWN' level='16' host_id='RHEL2'

      host_addr='127.0.0.1'>

      <txt>TNS-01155: Incorrectly specified SID_LIST_LISTENER_DB2 parameter in LISTENER.ORA

      NL-00303: syntax error in NV string

      </txt>

      </msg>

      <msg time='2014-02-09T11:01:32.409+05:30' org_id='oracle' comp_id='tnslsnr'

      type='UNKNOWN' level='16' host_id='RHEL2'

      host_addr='127.0.0.1'>

      <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL2)(PORT=1521)))

      </txt>

      </msg>

      --------------------------------------------------------------------------------------------------------------------------------

      AND Another Error.. when tried second time to start Listener.. on standby...

      [oracle@RHEL2 admin]$ lsnrctl start LISTENER_DB2

       

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-FEB-2014 10:50:11

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

      Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...

       

      TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

      Log messages written to /home/oracle/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/RHEL2/listener_db2/alert/log.xml

      TNS-01151: Missing listener name, LISTENER_DB2, in LISTENER.ORA

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

      ---------------------------------------------------------------------

      When Checked in Listener Log

       

      [oracle@RHEL2 dbhome_1]$ tail -100 log/diag/tnslsnr/RHEL2/listener_db2/alert/log.xml

       

      <msg time='2014-02-09T10:50:11.180+05:30' org_id='oracle' comp_id='tnslsnr'

      type='UNKNOWN' level='16' host_id='RHEL2'

      host_addr='127.0.0.1'>

      <txt>TNS-01151: Missing listener name, LISTENER_DB2, in LISTENER.ORA

      </txt>

      </msg>

      ----------------------------------------------

      Below is my Listener file on Standy

       

      [oracle@RHEL2 admin]$ cat listener.ora

      LISTENER_DB2 =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS_LIST =

              (ADDRESS = (PROTOCOL = TCP)(HOST = RHEL2)(PORT = 1521))

            )

          )

        )

       

      SID_LIST_LISTENER_DB2 =

        (SID_LIST =

          (SID_DESC =

            (SID_NAME = db2)

      (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)

          )

      )

      [oracle@RHEL2 admin]$

       

      pls give me any clue.. why this listener is nt working...

      Thank u..