3 Replies Latest reply on Apr 16, 2012 8:31 AM by taimur

    deletion of listener in RAC 10g

    taimur
      Hi all

      i wanted to delete the all existing listeners in RAC 10g three nodes. when i use netca it wil show no listener. but
      crs_stat -t -v show all the three listeners.

      is there any way to delete all these listeners. my RAC version is 10.2.0.1.0.

      as in 11g we have command

      srvctl remove listener but in 10g how can we do that.
        • 1. Re: deletion of listener in RAC 10g
          Ranjith
          taimur wrote:
          Hi all

          i wanted to delete the all existing listeners in RAC 10g three nodes. when i use netca it wil show no listener. but
          crs_stat -t -v show all the three listeners.
          Hi,

          Did u try like this ?

          http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/CLUSTER_23.shtml#Remove%20the%20Listener%20From%20the%20Node%20to%20be%20Deleted

          when i use netca it wil show no listener then did u check all the listeners are active ?

          Thanks,
          Ranjith
          • 2. Re: deletion of listener in RAC 10g
            taimur
            yes i do the steps using netca but the strange thing is netca didnot allow the deletion option as it is grayed.only add new listener is avaliable but when i go to add new lisnter it will give the error

            a listener with the same name already exist.

            as i have shutdown the database and nodeapps on all nodes.my crs_stat -t -v is as fallow.it will show the registerd listener.

            [oracle@rac3 admin]$ crs_stat -t -v
            Name Type R/RA F/FT Target State Host
            ----------------------------------------------------------------------
            ora....L1.inst application 0/5 0/0 OFFLINE OFFLINE
            ora....L2.inst application 0/5 0/0 OFFLINE OFFLINE
            ora....L3.inst application 0/5 0/0 OFFLINE OFFLINE
            ora....CL1.srv application 0/1 0/0 OFFLINE OFFLINE
            ora....TEST.cs application 0/1 0/1 ONLINE UNKNOWN rac1
            ora.ORCL.db application 0/1 0/1 OFFLINE OFFLINE
            ora....C1.inst application 0/5 0/0 OFFLINE OFFLINE
            ora....C2.inst application 0/5 0/0 OFFLINE OFFLINE
            ora....C3.inst application 0/5 0/0 OFFLINE OFFLINE
            ora....AC1.srv application 0/0 0/0 OFFLINE OFFLINE
            ora....TEST.cs application 0/0 0/1 OFFLINE OFFLINE
            ora.RAC.db application 0/1 0/1 OFFLINE OFFLINE
            ora....C1.lsnr application 0/5 0/0 OFFLINE OFFLINE
            ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE
            ora.rac1.ons application 0/3 0/0 OFFLINE OFFLINE
            ora.rac1.vip application 0/0 0/0 OFFLINE OFFLINE
            ora....C2.lsnr application 0/5 0/0 OFFLINE OFFLINE
            ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE
            ora.rac2.ons application 0/3 0/0 OFFLINE OFFLINE
            ora.rac2.vip application 0/0 0/0 OFFLINE OFFLINE
            ora....C1.lsnr application 0/5 0/0 OFFLINE OFFLINE
            ora....C3.lsnr application 0/5 0/0 OFFLINE OFFLINE
            ora.rac3.gsd application 0/5 0/0 OFFLINE OFFLINE
            ora.rac3.ons application 0/3 0/0 OFFLINE OFFLINE
            ora.rac3.vip application 0/0 0/0 OFFLINE OFFLINE
            • 3. Re: deletion of listener in RAC 10g
              taimur
              my problem is solved as


              i manually unregister the resources of all listeners as

              $crs_unregister ora.rac1.LISTENER_RAC1.lsnr
              $crs_unregister ora.rac2.LISTENER_RAC2.lsnr
              $ crs_unregister ora.rac3.LISTENER_RAC3.lsnr

              after unregistring and start netca this time when i am adding listener to all three nodes it goes fine without any error.and RAC is working fine now.

              thanks for support.