4 Replies Latest reply: Mar 23, 2013 9:29 AM by user12025125 RSS

    SCAN is not working

    user12025125
      Hello,

      I need asssistance to fix SCAN listener issue. Cluster and database is working fine. i am able to make connection if i use VIP addresses in my connect string whereas it doesn't work if i define SCAN name. Please help me to figure out the problem.

      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> srvctl config scan_listener
      SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
      SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
      SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> srvctl status scan_listener
      SCAN Listener LISTENER_SCAN1 is enabled
      SCAN listener LISTENER_SCAN1 is running on node us97udb021amprb
      SCAN Listener LISTENER_SCAN2 is enabled
      SCAN listener LISTENER_SCAN2 is running on node us97udb020amprb
      SCAN Listener LISTENER_SCAN3 is enabled
      SCAN listener LISTENER_SCAN3 is running on node us97udb020amprb
      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> srvctl config scan
      SCAN name: cluster1a-scan, Network: 1/159.202.76.0/255.255.255.0/eth4
      SCAN VIP name: scan1, IP: /cluster1a-scan/159.202.76.98
      SCAN VIP name: scan2, IP: /cluster1a-scan/159.202.76.99
      SCAN VIP name: scan3, IP: /cluster1a-scan/159.202.76.100
      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> srvctl status scan
      SCAN VIP scan1 is enabled
      SCAN VIP scan1 is running on node us97udb021amprb
      SCAN VIP scan2 is enabled
      SCAN VIP scan2 is running on node us97udb020amprb
      SCAN VIP scan3 is enabled
      SCAN VIP scan3 is running on node us97udb020amprb
      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> srvctl config listener
      Name: LISTENER
      Network: 1, Owner: oracle
      Home: <CRS home>
      End points: TCP:1521
      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> srvctl status listener
      Listener LISTENER is enabled
      Listener LISTENER is running on node(s): us97udb020amprb,us97udb021amprb


      --First Node

      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> cat listener.ora
      LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
      LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
      LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
      LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

      --Second Node

      US97UDB021AMPRB:[POEODSS2] /usr/app/grid/network/admin -> cat listener.ora
      LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
      LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

      SQL> show parameter listener

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      listener_networks string
      local_listener string (DESCRIPTION=(ADDRESS=(PROTOCO
      L=IPC)(KEY=LISTENER)))
      remote_listener string cluster1a-scan:1521

      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> nslookup cluster1a-scan
      Server: 159.202.76.74
      Address: 159.202.76.74#53

      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.99
      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.100
      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.98

      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> nslookup cluster1a-scan
      Server: 159.202.76.74
      Address: 159.202.76.74#53

      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.100
      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.98
      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.99

      US97UDB020AMPRB:[POEODSS1] /usr/app/grid/network/admin -> nslookup cluster1a-scan
      Server: 159.202.76.74
      Address: 159.202.76.74#53

      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.98
      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.99
      Name: cluster1a-scan.i.ameriprise.com
      Address: 159.202.76.100


      Tns Entry

      POEODSS =
      (DESCRIPTION =
      (SDU = 32767)
      (SEND_BUF_SIZE = 65536)
      (RECV_BUF_SIZE = 65536)
      (LOAD_BALANCE = yes)
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cluster1a-scan.i.ameriprise.com)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVER = dedicated)
      (SERVICE_NAME = POEODSS)
      )
      )

      TEST =
      (DESCRIPTION =
      (SDU = 32767)
      (SEND_BUF_SIZE = 65536)
      (RECV_BUF_SIZE = 65536)
      (LOAD_BALANCE = yes)
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = US97UDB020AMPRB-vip.i.ameriprise.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = US97UDB021AMPRB-vip.i.ameriprise.com)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVER = dedicated)
      (SERVICE_NAME = POEODSS)
      )
      )

      --First node

      US97UDB020AMPRB:[+ASM1] /usr/app/grid/network/admin -> lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-MAR-2013 15:18:54

      Copyright (c) 1991, 2011, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
      Start Date 18-MAR-2013 15:00:51
      Uptime 0 days 0 hr. 18 min. 3 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /usr/app/grid/network/admin/listener.ora
      Listener Log File /usr/app/oracle/diag/tnslsnr/US97UDB020AMPRB/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=159.202.76.92)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=159.202.76.67)(PORT=1521)))
      Services Summary...
      Service "+ASM" has 1 instance(s).
      Instance "+ASM1", status READY, has 1 handler(s) for this service...
      Service "POEODSS" has 1 instance(s).
      Instance "POEODSS1", status READY, has 1 handler(s) for this service...
      Service "POEODSSXDB" has 1 instance(s).
      Instance "POEODSS1", status READY, has 1 handler(s) for this service...
      The command completed successfully

      --Second Node

      US97UDB021AMPRB:[+ASM2] /usr/app/grid/network/admin -> lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-MAR-2013 15:19:27

      Copyright (c) 1991, 2011, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
      Start Date 18-MAR-2013 15:05:12
      Uptime 0 days 0 hr. 14 min. 14 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /usr/app/grid/network/admin/listener.ora
      Listener Log File /usr/app/oracle/diag/tnslsnr/US97UDB021AMPRB/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=159.202.76.68)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=159.202.76.93)(PORT=1521)))
      Services Summary...
      Service "+ASM" has 1 instance(s).
      Instance "+ASM2", status READY, has 1 handler(s) for this service...
      Service "POEODSS" has 1 instance(s).
      Instance "POEODSS2", status READY, has 1 handler(s) for this service...
      Service "POEODSSXDB" has 1 instance(s).
      Instance "POEODSS2", status READY, has 1 handler(s) for this service...
      The command completed successfully


      Regards,
      Pankaj
        • 1. Re: SCAN is not working
          user12025125
          Forgot to add the error.

          SQL> conn afidba/*******@poeodss
          ERROR:
          ORA-12520: TNS:listener could not find available handler for requested type of server
          • 2. Re: SCAN is not working
            Levi Pereira
            Hi,

            Can you ping all VIPs HOSTNAME "FQDN" (not IP) from client host?

            Also you can try it:
            http://levipereira.wordpress.com/2011/05/03/configuring-client-to-use-scan-11-2-0/

            Edited by: Levi Pereira on Mar 18, 2013 5:05 PM
            • 3. Re: SCAN is not working
              606331
              can you please post cat /etc/hosts output....

              hope you might have configure SCAN VIP addresses with hosts file IP....i hope..please check once......Oracle strongly recommends that you do not configure SCAN VIP addresses in the hosts file. But if you use the hosts file to resolve SCAN name, you can have only one SCAN IP address..........

              please refer below notes....for more..info...

              11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained [ID 887522.1

              http://docs.oracle.com/cd/E11882_01/network.112/e10836/trouble.htm#CEGJGEEC
              http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.pdf

              Edited by: dbc001 on Mar 23, 2013 7:19 PM

              Edited by: dbc001 on Mar 23, 2013 7:22 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
              • 4. Re: SCAN is not working
                user12025125
                Thanks everyone, SCAN is working fine after removing entries from /etc/hosts file followed by restarting all services.

                Thanks & Regards,
                Pankaj