4 Replies Latest reply: Dec 11, 2012 12:19 PM by user2538196 RSS

    RAC SCAN listener

    user2538196
      Hi - SCAN listener is configured and all other instances are connecting to SQL plus using scan listener.But one instance is connecting to sqlplus if you use scan listener connect string.

      $lsnrctl status LISTENER_SCAN1 is NOT showing the instances even though the intialization parameter is mentioned.

      remote_listener string et01-scan:1521

      tnsping is working fine.The problem is with sqlplus@govtd_scan

      How to add the instnace names to scan listener?

      Thanks in advance.
        • 1. Re: RAC SCAN listener
          onedbguru
          user2538196 wrote:
          Hi - SCAN listener is configured and all other instances are connecting to SQL plus using scan listener.But one instance is connecting to sqlplus if you use scan listener connect string.

          $lsnrctl status LISTENER_SCAN1 is NOT showing the instances even though the intialization parameter is mentioned.

          remote_listener string et01-scan:1521

          tnsping is working fine.The problem is with sqlplus@govtd_scan

          How to add the instnace names to scan listener?

          Thanks in advance.
          Give us the output from:

          srvctl status scan
          srvctl status scan_listener
          srvctl status listener

          what is the definition for govtd_scan?

          what is the results of
          sqlplus user/pass@\"et01-scan:1521/servicename\" <<EOF
          select * from v$instance;
          show parameter services
          exit;
          EOF

          use the appropriate values for username, password and the correct service name (database name)

          Do this repeatedly and you should connect to a different instance each time.

          If not, then google search for: oracle scan pdf and make sure you actually configured it correctly.
          • 2. Re: RAC SCAN listener
            user2538196
            Hi - Thanks for your reply.Here you go....

            srvctl status scan
            SCAN VIP scan1 is enabled
            SCAN VIP scan1 is running on node et01db02
            SCAN VIP scan2 is enabled
            SCAN VIP scan2 is running on node et01db01
            SCAN VIP scan3 is enabled
            SCAN VIP scan3 is running on node et01db01
            srvctl status scan_listener
            SCAN Listener LISTENER_SCAN1 is enabled
            SCAN listener LISTENER_SCAN1 is running on node et01db02
            SCAN Listener LISTENER_SCAN2 is enabled
            SCAN listener LISTENER_SCAN2 is running on node et01db01
            SCAN Listener LISTENER_SCAN3 is enabled
            SCAN listener LISTENER_SCAN3 is running on node et01db01
            srvctl status listener
            Listener LISTENER is enabled
            Listener LISTENER is running on node(s): et01db01,et01db02
            Listener LISTENER_SDBA is enabled
            Listener LISTENER_SDBA is running on node(s): et01db01,et01db02
            Listener LISTENER_SFUN is enabled
            Listener LISTENER_SFUN is running on node(s): et01db01,et01db02
            Listener LISTENER_SSAN is enabled
            Listener LISTENER_SSAN is running on node(s): et01db01,et01db02
            Listener LISTENER_STST is enabled
            Listener LISTENER_STST is running on node(s): et01db01,et01db02
            sqlplus apps@\"et01-scan:1521/stst\"

            SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 7 09:25:57 2012

            Copyright (c) 1982, 2010, Oracle. All rights reserved.

            Enter password:
            ERROR:
            ORA-12514: TNS:listener does not currently know of service requested in connect
            descriptor

            SQL> select * from v$instance;

            INSTANCE_NUMBER INSTANCE_NAME
            --------------- ----------------
            HOST_NAME
            ----------------------------------------------------------------
            VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
            ----------------- --------- ------------ --- ---------- ------- ---------------
            LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
            ---------- --- ----------------- ------------------ --------- ---
            1 stst1
            et01db01.rtd-denver.com
            11.2.0.2.0 28-NOV-12 OPEN YES 1 STOPPED
            ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO


            SQL> show parameter services
            -- No result


            $tnsping stst_scan

            TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 07-DEC-2012 09:26:39

            Copyright (c) 1997, 2010, Oracle. All rights reserved.

            Used parameter files:
            /u01/app/oraerp/product/11.2.0/stst/network/admin/stst1_et01db01/sqlnet_ifile.ora


            Used TNSNAMES adapter to resolve the alias
            Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=et01-scan.rtd-denver.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=stst) (INSTANCE_NAME=stst1)))
            OK (0 msec)


            sqlplus apps@stst_scan

            SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 7 09:33:27 2012

            Copyright (c) 1982, 2010, Oracle. All rights reserved.

            Enter password:
            ERROR:
            ORA-12514: TNS:listener does not currently know of service requested in connect
            descriptor

            tnsnames.ora entry....

            stst_scan =
            (DESCRIPTION=
            (ADDRESS=(PROTOCOL=tcp)(HOST=et01-scan.rtd-denver.com)(PORT=1521))
            (CONNECT_DATA=
            (SERVICE_NAME=stst)
            (INSTANCE_NAME=stst1)
            )
            )
            • 3. Re: RAC SCAN listener
              Victor Armbrust
              Ok. Lets just recapitulate:

              SCAN is not the LISTENER itself. SCAN is just the service that connect to listener. So you can try:
              lsnrctl status <listener_name> (LISTENER is the default name)

              Or

              ps -ef|grep tns

              You can also take a look on your listener.ora file ($GRID_HOME/network/admin)

              You are trying to connect only to instance1 (stst1) but the error is related to SERVICE_NAME, so whats your service_name configuration on instance1? (stst1)


              show parameter service_name


              Please, just keep in mind that TNSPING would not connect to the instance/db you want to, it just try the LISTENER connection on port 1521


              Victor
              • 4. Re: RAC SCAN listener
                user2538196
                SQL> show parameter service_name

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                service_names string SYS$APPLSYS.WF_CONTROL.STST.RT
                D-DENVER.COM
                stst1@et01db01 stst1_et01db01 $ ps -ef|grep tns
                oraerp 327 1 0 Sep28 ? 00:20:57 /u01/app/oraerp/product/11.2.0/sprj/bin/tnslsnr listener_sprj -inherit
                oragrid 1880 1 0 Dec06 ? 00:00:05 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
                oraerp 6347 1 0 Nov19 ? 00:03:03 /u01/app/oraerp/product/11.2.0/dbhome_sdba/bin/tnslsnr LISTENER_SDBA -inherit
                oraerp 11480 7862 0 11:19 pts/0 00:00:00 grep tns
                oraerp 11731 1 0 Nov29 ? 00:02:44 /u01/app/oraerp/product/11.2.0/stst/bin/tnslsnr LISTENER_STST -inherit
                oragrid 13311 1 0 Sep27 ? 00:40:36 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
                oraerp 13636 1 0 Sep27 ? 00:23:11 /u01/app/oraerp/product/11.2.0/ssan/bin/tnslsnr LISTENER_SSAN -inherit
                oraerp 15560 1 0 09:38 ? 00:00:00 /u01/app/oraerp/product/11.2.0/strn/bin/tnslsnr LISTENER_STRN -inherit
                oraerp 17765 1 0 Oct19 ? 00:04:42 /u01/app/oraerp/product/11.2.0/sfun/bin/tnslsnr LISTENER_SFUN -inherit
                oraerp 20188 1 0 Nov28 ? 00:01:53 /u01/app/oraerp/product/11.2.0/stst/bin/tnslsnr LISTENER_STST -inherit
                oragrid 30865 1 0 Dec07 ? 00:03:27 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
                oraerp 31047 1 0 Oct22 ? 00:02:29 /u01/app/oraerp/product/11.2.0/spay/bin/tnslsnr LISTENER_SPAY -inherit
                oraerp 31463 1 0 Oct02 ? 00:14:37 /u01/app/oraerp/product/11.2.0/sdev/bin/tnslsnr listener_sdev -inherit