2 Replies Latest reply: Nov 4, 2012 2:36 AM by Neo-b RSS

    CRS-5020: Not all endpoints are registered for listener LISTENER

    Neo-b
      Hello All,

      I am using Oracle RAC 11g R2 on AIX 7.1

      I am facing CRS-5020: Not all endpoints are registered for listener LISTENER

      when I run crsctl stat res -t
      I got the below output:
      ora.LISTENER.lsnr
                     ONLINE  INTERMEDIATE rac_1     Not All Endpoints Registered
                     ONLINE  ONLINE       rac_2
      and then:

      crsctl status resource ora.LISTENER.lsnr
      NAME=ora.LISTENER.lsnr
      TYPE=ora.listener.type
      TARGET=ONLINE                              , ONLINE
      STATE=INTERMEDIATE on rac_1, ONLINE on rac_2
      Then I tried to stop and start this listener but still facing the same issue
      crsctl stop resource ora.LISTENER.lsnr
      
      CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac_2'
      CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac_1'
      CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac_1' succeeded
      CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac_2' succeeded
      
      crsctl start resource ora.LISTENER.lsnr
      
      CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac_2'
      CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac_1'
      CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac_2' succeeded
      CRS-5020: Not all endpoints are registered for listener LISTENER
      CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac_1' succeeded
      below are some logs from listener.log where I have this error : TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

      TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
      03-NOV-2012 11:49:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=RAC_2)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)
      ) * status * 0
      03-NOV-2012 11:49:04 * version * 0
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.130.67.21)(PORT=1521)))
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.130.67.25)(PORT=1521)))
      03-NOV-2012 11:49:04 * service_register * LsnrAgt * 0
      03-NOV-2012 11:49:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=RAC_2)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)
      ) * status * 0
      03-NOV-2012 11:49:07 * (CONNECT_DATA=(SID=PREPROD2)(CID=(PROGRAM=perl)(HOST=RAC_2)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.130.67.21)(
      PORT=41912)) * establish * PREPROD2 * 12505
      TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
      Sat Nov 03 11:49:21 2012
      03-NOV-2012 11:49:21 * ping * 0
      03-NOV-2012 11:49:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=RAC_2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=18664729
      6)) * status * 0
      What can I do to fix this issue?

      Regards,