1 Reply Latest reply: Oct 17, 2013 11:34 PM by gottikere RSS

    lcoal listener not registering database (RAC)

    sunilkumar

      Dear Experts,

       

      Oracle 11gR2(Windows 2008R2)

       

      local listener is running from crs home, but it is not registering instance (even after bounce and loca listener parameter settings)

      Please note that this is default listener from CRS home.

      While checking resources I found:

       

      ora.DG_ARCHIVE.dg
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.DG_DATA.dg
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.DG_FLASHBACK.dg
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.DG_OCR_VOTE.dg
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.DG_RECO1.dg
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.DG_RECO2.dg
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.LISTENER.lsnr
                     ONLINE  OFFLINE      apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.asm
                     ONLINE  ONLINE       apsdb001                 Started
                     ONLINE  ONLINE       apsdb002                 Started
      ora.gsd
                     OFFLINE OFFLINE      apsdb001
                     OFFLINE OFFLINE      apsdb002
      ora.net1.network
                     ONLINE  OFFLINE      apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.ons
                     ONLINE  OFFLINE      apsdb001
                     ONLINE  ONLINE       apsdb002
      ora.registry.acfs
                     ONLINE  ONLINE       apsdb001
                     ONLINE  ONLINE       apsdb002
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.LISTENER_SCAN1.lsnr
            1        ONLINE  ONLINE       apsdb002
      ora.LISTENER_SCAN2.lsnr
            1        ONLINE  ONLINE       apsdb002
      ora.LISTENER_SCAN3.lsnr
            1        ONLINE  ONLINE       apsdb002
      ora.apsdb001.vip
            1        ONLINE  INTERMEDIATE apsdb002                 FAILED OVER
      ora.apsdb002.vip
            1        ONLINE  ONLINE       apsdb002
      ora.atsfmsdb.db
            1        ONLINE  ONLINE       apsdb001                 Open
            2        ONLINE  ONLINE       apsdb002                 Open
      ora.cvu
            1        ONLINE  ONLINE       apsdb002
      ora.fmsalert.db
            1        ONLINE  ONLINE       apsdb001                 Open
            2        ONLINE  ONLINE       apsdb002                 Open
      ora.oc4j
            1        ONLINE  ONLINE       apsdb001
      ora.scan1.vip
            1        ONLINE  ONLINE       apsdb002
      ora.scan2.vip
            1        ONLINE  ONLINE       apsdb002
      ora.scan3.vip
            1        ONLINE  ONLINE       apsdb002

       

       

      We have have given local_listener parameter to VIP. Issue node is node aspdb001, all the user connections are going to node2, kindly provide your experts suggestion on that.

       

      Regards

      SK