This discussion is archived
4 Replies Latest reply: Dec 11, 2012 10:19 AM by user2538196 RSS

RAC SCAN listener

user2538196 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points