3 Replies Latest reply: Apr 16, 2012 8:08 AM by ora-00600 RSS

    SCAN_LISTENER

    ora-00600
      Hello team, recently I have changed scan configuration, from 1 /etc/hosts address to 3 DNS addresses but as you can see in the next output when I started the scan_listener it only show 1 listener instead of 3 listeners corresponding to the 3 scan addresses.

      ### Check DNS can resolve 3 ip addresses
      [grid@hpnodo1a ~]$ nslookup hprac1
      Server: 172.17.35.91
      Address: 172.17.35.91#53

      Name: hprac1.hplab.local
      Address: 192.168.0.25
      Name: hprac1.hplab.local
      Address: 192.168.0.27
      Name: hprac1.hplab.local
      Address: 192.168.0.28

      ### Actual configuration of SCAN (only 1 address)
      [grid@hpnodo1a ~]$ srvctl config scan
      SCAN name: hprac1, Network: 1/192.168.0.0/255.255.255.0/eth0
      SCAN VIP name: scan1, IP: /hprac1.hplab.local/192.168.0.25

      ### Stop SCAN_LISTENER and SCAN
      [grid@hpnodo1a ~]$ srvctl stop scan_listener
      [grid@hpnodo1a ~]$ srvctl stop scan
      [grid@hpnodo1a ~]$ srvctl status scan
      SCAN VIP scan1 is enabled
      SCAN VIP scan1 is not running
      [grid@hpnodo1a ~]$ srvctl status scan_listener
      SCAN Listener LISTENER_SCAN1 is enabled
      SCAN listener LISTENER_SCAN1 is not running

      ### Change SCAN configuration
      [grid@hpnodo1a ~]$ srvctl modify scan -n hprac1.hplab.local
      PRCN-2018 : Current user grid is not a privileged user
      [grid@hpnodo1a ~]$ su - root
      Password:
      [root@hpnodo1a ~]# . crs_env.sh
      /u01/app/11.2.0/grid
      +ASM1
      [root@hpnodo1a ~]# srvctl modify scan -n hprac1.hplab.local

      ### Show new SCAN configuration
      [root@hpnodo1a ~]# srvctl config scan
      SCAN name: hprac1.hplab.local, Network: 1/192.168.0.0/255.255.255.0/eth0
      SCAN VIP name: scan1, IP: /hprac1.hplab.local/192.168.0.27
      SCAN VIP name: scan2, IP: /hprac1.hplab.local/192.168.0.28
      SCAN VIP name: scan3, IP: /hprac1.hplab.local/192.168.0.25

      ### Start SCAN and SCAN_LISTENER
      [root@hpnodo1a ~]# srvctl start scan
      [root@hpnodo1a ~]# srvctl start scan_listener
      [root@hpnodo1a ~]# crs_stat -t
      Name Type Target State Host
      ------------------------------------------------------------
      ora.CRS.dg ora....up.type ONLINE ONLINE hpnodo1a
      ora.DATA.dg ora....up.type ONLINE ONLINE hpnodo1a
      ora....ER.lsnr ora....er.type ONLINE ONLINE hpnodo1a
      ora....N1.lsnr ora....er.type ONLINE ONLINE hpnodo1b
      ora.asm ora.asm.type ONLINE ONLINE hpnodo1a
      ora.cenco.db ora....se.type ONLINE ONLINE hpnodo1a
      ora.eons ora.eons.type ONLINE ONLINE hpnodo1a
      ora.gsd ora.gsd.type OFFLINE OFFLINE
      ora....SM1.asm application ONLINE ONLINE hpnodo1a
      ora....1A.lsnr application ONLINE ONLINE hpnodo1a
      ora....o1a.gsd application OFFLINE OFFLINE
      ora....o1a.ons application ONLINE ONLINE hpnodo1a
      ora....o1a.vip ora....t1.type ONLINE ONLINE hpnodo1a
      ora....SM2.asm application ONLINE ONLINE hpnodo1b
      ora....1B.lsnr application ONLINE ONLINE hpnodo1b
      ora....o1b.gsd application OFFLINE OFFLINE
      ora....o1b.ons application ONLINE ONLINE hpnodo1b
      ora....o1b.vip ora....t1.type ONLINE ONLINE hpnodo1b
      ora....network ora....rk.type ONLINE ONLINE hpnodo1a
      ora.oc4j ora.oc4j.type OFFLINE OFFLINE
      ora.ons ora.ons.type ONLINE ONLINE hpnodo1a
      ora....ry.acfs ora....fs.type ONLINE ONLINE hpnodo1a
      ora.scan1.vip ora....ip.type ONLINE ONLINE hpnodo1b
      ora.scan2.vip ora....ip.type ONLINE ONLINE hpnodo1b
      ora.scan3.vip ora....ip.type ONLINE ONLINE hpnodo1a


      As you can see there are 3 scan.vip but only one SCAN.lsnr service. I understand that it should one scan.lsnr per scan.vip. Can anybody clearify this for me?

      Thanks in advance,
        • 1. Re: SCAN_LISTENER
          onedbguru
          I put this in another thread that was having a similar issue:

          nslookup some-scan-name ##nslookup looks at DNS excusively - ping resolves from /etc/hosts first.

          xxx.xxx.xxx.xx1 some-scan-name
          xxx.xxx.xxx.xx2 some-scan-name
          xxx.xxx.xxx.xx3 some-scan-name

          srvctl status scan
          SCAN1 on hostxyz

          edit /etc/hosts and COMMENT OUT all of the scan addresses

          srvctl stop scan_listener
          srvctl sop scan
          srvctl modify scan -n some-scan-name <<-- this fixes and updates the SCAN/SCAN_LISTENER
          srvctl start scan

          srvctl status scan
          SCAN1 enabled on hostxyy
          SCAN2 enabled on hostxyy
          SCAN1 enabled on hostxyz

          srvctl start scan_listener

          srvctl status scan
          SCAN1_LISTENER1 running on hostxyy
          SCAN2_LISTENER2 running on hostxyy
          SCAN3_LISTENER3 running on hostxyz
          • 2. Re: SCAN_LISTENER
            ora-00600
            Thanks for your response. I double checked /etc/hosts on both nodes, and I already commented any line regarding public, vip and scan addresses (all the addresses that i want to resolve through DNS):

            # Do not remove the following line, or various programs
            # that require network functionality will fail.
            127.0.0.1 hpnodo1b localhost.localdomain localhost
            ::1 localhost6.localdomain6 localhost6
            # Public hostnames (public network eth0)
            #192.168.0.10 hpnodo1a # RAC node 1
            #192.168.0.20 hpnodo1b # RAC node 2

            # Private hostnames (Interconnect eth1)
            172.17.35.92 hpnodo1a-priv # RAC node 1
            172.17.35.93 hpnodo1b-priv # RAC node 2

            # Virtual IP (public Virtual Internet Protocol (VIP))
            #192.168.0.11 hpnodo1a-vip # RAC node 1
            #192.168.0.21 hpnodo1b-vip # RAC node 2

            #SCAN
            #192.168.0.25 hprac1

            I redo all the change procedure again with same results:

            [root@hpnodo1a ~]# nslookup hprac1
            Server: 172.17.35.91
            Address: 172.17.35.91#53

            Name: hprac1.hplab.local
            Address: 192.168.0.28
            Name: hprac1.hplab.local
            Address: 192.168.0.25
            Name: hprac1.hplab.local
            Address: 192.168.0.27

            [root@hpnodo1a ~]# srvctl config scan
            SCAN name: hprac1, Network: 1/192.168.0.0/255.255.255.0/eth0
            SCAN VIP name: scan1, IP: /hprac1.hplab.local/192.168.0.27
            SCAN VIP name: scan2, IP: /hprac1.hplab.local/192.168.0.28
            SCAN VIP name: scan3, IP: /hprac1.hplab.local/192.168.0.25

            [root@hpnodo1a ~]# srvctl status scan
            SCAN VIP scan1 is enabled
            SCAN VIP scan1 is running on node hpnodo1b
            SCAN VIP scan2 is enabled
            SCAN VIP scan2 is running on node hpnodo1b
            SCAN VIP scan3 is enabled
            SCAN VIP scan3 is running on node hpnodo1a

            [root@hpnodo1a ~]# srvctl status scan_listener
            SCAN Listener LISTENER_SCAN1 is enabled
            SCAN listener LISTENER_SCAN1 is running on node hpnodo1b

            [root@hpnodo1a ~]# srvctl stop scan_listener
            [root@hpnodo1a ~]# srvctl stop scan
            [root@hpnodo1a ~]# srvctl modify scan -n hprac1
            [root@hpnodo1a ~]# srvctl start scan
            [root@hpnodo1a ~]# srvctl start scan_listener

            [root@hpnodo1a ~]# srvctl status scan_listener
            SCAN Listener LISTENER_SCAN1 is enabled
            SCAN listener LISTENER_SCAN1 is running on node hpnodo1b

            [root@hpnodo1a ~]# srvctl status scan
            SCAN VIP scan1 is enabled
            SCAN VIP scan1 is running on node hpnodo1b
            SCAN VIP scan2 is enabled
            SCAN VIP scan2 is running on node hpnodo1a
            SCAN VIP scan3 is enabled
            SCAN VIP scan3 is running on node hpnodo1a


            Any ideas? Thanks!
            • 3. Re: SCAN_LISTENER
              ora-00600
              Some oracle documentation said that root.sh script is the responsible to create the scan_listener. It is possible that the issue is because when i ran the root.sh there was only 1 scan address (the one that was defined on /etc/hosts file)?

              It is possible to run this script again?

              Thanks for any help.