4 Replies Latest reply: Jun 7, 2013 11:46 AM by onedbguru RSS

    11 G Scan listener problem

    1002082
      Hi,

      Suddenly the Oracle 11g r2 RAC scan listener was changed to intermediate state in our envrionment.
      How can we change state from intermediate to online state?

      please find the details as below,

      OS : HP Unix B.11.31
      DB Version: 11.2.0.3.0

      ora.LISTENER_SCAN1.lsnr
      1 ONLINE INTERMEDIATE Node2 CHECK TIMED OUT
      ora.LISTENER_SCAN2.lsnr
      1 ONLINE INTERMEDIATE Node1 CHECK TIMED OUT
      ora.LISTENER_SCAN3.lsnr
      1 ONLINE INTERMEDIATE Node1 CHECK TIMED OUT
      ora.LISTENER.lsnr
      ONLINE INTERMEDIATE Node1 CHECK TIMED OUT
      ONLINE ONLINE Node2

      If you need further information, kindly let me know.

      Thanks.
      Kumar
        • 1. Re: 11 G Scan listener problem
          1002082
          can any one one please do needful..
          • 2. Re: 11 G Scan listener problem
            1002082
            Hi,

            when i put
            crsctl status it is showing as below

            $ crsctl status resource ora.LISTENER_SCAN1.lsnr
            NAME=ora.LISTENER_SCAN1.lsnr
            TYPE=ora.scan_listener.type
            TARGET=ONLINE
            STATE=INTERMEDIATE on node02

            can any one please do need ful....
            • 3. Re: 11 G Scan listener problem
              1002082
              why what happend ...no one will not replied to this forum...


              please do need ful
              • 4. Re: 11 G Scan listener problem
                onedbguru
                First, this is NOT the place to get "urgent" help. If you have a down system, contact Oracle Support.

                follow the scan document http://www.lmgtfy.com/?q=oracle+scan+pdf

                what is the output of the following -obfuscate any host names by substituting node1... node2... etc..?

                srvctl status scan
                srvctl status scan_listener
                srvctl status listener

                on EACH node:
                sqlplus / as sysdba
                show parameter listener -- this will show local and remote listener.

                If you nslookup <your-scan-address> do you get 3 IP addresses returned?

                Comment out the <your-scan-address> from the /etc/hosts file
                make sure ALL public and public-vip addresses are in both /etc/hosts AND DNS.