On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,529 Users
  • 2,269,755 Discussions
  • 7,916,772 Comments

Discussions

QUESTIONS ABOUT SCAN-LISTENER

Jhil
Jhil Member Posts: 3,182 Bronze Trophy
edited Jan 26, 2018 2:51PM in Real Application Clusters

Dear RAC Experts ,

1) Why scan listener information is NOT appeared when i am using 'lsnrctl status' ?

2) Is that expected behavior or something wrong ?

3)  Without DNS , is it possible to add one more SCAN_LISTENER on any one of the node in a cluster ?

[[email protected] ~]# srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac1

[[email protected] ~]# srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac1

[[email protected] ~]# crsctl status resource -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.OCRVD.dg

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.RECO.dg

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.asm

               ONLINE  ONLINE       rac1                     Started            

               ONLINE  ONLINE       rac2                     Started            

ora.eons

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.gsd

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.net1.network

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.ons

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

ora.registry.acfs

               ONLINE  ONLINE       rac1                                        

               ONLINE  ONLINE       rac2                                        

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                       

ora.crms.db

      1        ONLINE  ONLINE       rac1                     Open               

      2        ONLINE  ONLINE       rac2                     Open               

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1        ONLINE  ONLINE       rac2                                        

ora.samdb.db

      1        ONLINE  ONLINE       rac2                     Open               

ora.scan1.vip

      1        ONLINE  ONLINE       rac1                                       

ora.tesco.db

      1        ONLINE  ONLINE       rac1                     Open 

>> as  'oracle' user

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-JAN-2018 04:04:33

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                22-JAN-2018 01:53:57

Uptime                    0 days 2 hr. 10 min. 37 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/product/11.2.0/grid_home/network/admin/listener.ora

Listener Log File         /u01/app/grid/diag/tnslsnr/RAC1/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.212.40)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.212.70)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "crms" has 1 instance(s).

  Instance "crms1", status READY, has 1 handler(s) for this service...

Service "crmsXDB" has 1 instance(s).

  Instance "crms1", status READY, has 1 handler(s) for this service...

Service "tesco" has 1 instance(s).

  Instance "tesco", status READY, has 1 handler(s) for this service...

Service "tescoXDB" has 1 instance(s).

  Instance "tesco", status READY, has 1 handler(s) for this service...

The command completed successfully

Jhil

Best Answers

  • Jhil
    Jhil Member Posts: 3,182 Bronze Trophy
    edited Jan 22, 2018 12:15PM Answer ✓

    Hi Markus,

    >> I executed following command as 'grid' user, but  previously i executed as 'oracle' user

    [[email protected] ~]$ lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 23-JAN-2018 04:26:28

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

    STATUS of the LISTENER

    ------------------------

    Alias                     LISTENER_SCAN1

    Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production

    Start Date                23-JAN-2018 04:04:06

    Uptime                    0 days 0 hr. 22 min. 22 sec

    Trace Level               off

    Security                  ON: Local OS Authentication

    SNMP                      OFF

    Listener Parameter File   /u01/product/11.2.0/grid/network/admin/listener.ora

    Listener Log File         /u01/product/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml

    Listening Endpoints Summary...

      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.115)(PORT=1521)))

    Services Summary...

    Service "cisco.com" has 1 instance(s).

      Instance "cisco1", status READY, has 1 handler(s) for this service...

    Service "ciscoXDB.com" has 1 instance(s).

      Instance "cisco1", status READY, has 1 handler(s) for this service...

    The command completed successfully

    >> I am executing same command as 'oracle' user

    [[email protected] ~]$ lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 23-JAN-2018 04:33:49

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

    TNS-01101: Could not find service name LISTENER_SCAN1

    REF_LINK :  https://oraclehandson.wordpress.com/2010/05/21/oracle-11gr2-scan-configuration/

    >> How to add one more scan listener , if i do NOT use DNS

    https://www.orskl.com/how-to-add-a-new-scan-listener-in-oracle-11gr2-rac-setup/

    Just i referred and NOT tested.

    Thanks

«1

Answers

  • Dude!
    Dude! [email protected]Member Posts: 22,830 Black Diamond
    edited Jan 21, 2018 1:04PM

    You don't have SCAN configured properly. Even in a 2 node cluster, the recommendation is to have 3 SCAN listeners. So whether your cluster consists of 20 or 2 nodes, you should configure 3 SCAN listeners. If you have a 2 node cluster, then one node runs 2 SCAN listeners.

    If you do not have a DNS server, you can add entries for each SCAN server in /etc/hosts on each node.

    I suggest you review http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf

  • Jhil
    Jhil Member Posts: 3,182 Bronze Trophy
    edited Jan 21, 2018 9:28PM

    Hi Dude,

    Some confusions on your statement.

    @ Dude wroteYou don't have SCAN configured properly. 

    1) Where i  made mistake ?

    As we know, without DNS, there is only 1 scan Listener.

    In my case , only scan listener is running.

    >> I am expecting answers for my following questions  too

    2) Why scan listener information is NOT appeared when i am using 'lsnrctl status' ?

    3) Is that expected behavior or something wrong ?

    4)  Without DNS , is it possible to add one more SCAN_LISTENER on any one of the node in a cluster ?

    Thanks

  • Dude!
    Dude! [email protected]Member Posts: 22,830 Black Diamond
    edited Jan 22, 2018 3:13AM

    The srvctl status scan_listener command in our description should print all available SCAN listeners. It only shows 1 scan listener, hence my assumption your configuration is wrong. As I said, you can also use /etc/hosts on each node instead of a DNS server. Do you understand the difference between DNS and /etc/hosts?

    Jhil
  • Jhil
    Jhil Member Posts: 3,182 Bronze Trophy
    edited Jan 22, 2018 7:26AM

    Hi Dude,

    I configured RAC on my LAPTOP.

    I am using /etc/hosts instead of DNS because i am NOT a UNIX ADMIN but  an Oracle DBA.

    # srvctl status scan_listener

    SCAN Listener LISTENER_SCAN1 is enabled

    SCAN listener LISTENER_SCAN1 is running on node rac1

    >> command as oracle user

    $ lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-JAN-2018 23:22:39

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

    TNS-01101: Could not find service name LISTENER_SCAN1

    Do you understand the difference between DNS and /etc/hosts?

    DNS           -  Converts IP to NAME and NAME to IP

    /etc/hosts   - Normally server name and IP address entries are added here to avoid looping .

  • Jhil
    Jhil Member Posts: 3,182 Bronze Trophy
    edited Jan 22, 2018 7:28AM
    Hemant K Chitale wrote:Your lsnrctl commands are against the listener with the default name "LISTENER".The SCAN listener is running under another name "LISTENER_SCAN1".At the lsnrctl command prompt run "SET CURRENT_LISTENER LISTENER_SCAN1" and then run "STATUS"or at the OS command prompt run "lsnrctl status LISTENER_SCAN1"Hemant K Chitale

    [[email protected] ~]$ lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-JAN-2018 23:22:39

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

    TNS-01101: Could not find service name LISTENER_SCAN1

    1) What was wrong ?

    2) Could you please post some sample output for scan Listener ?

  • Markus Flechtner
    Markus Flechtner GermanyMember Posts: 503 Bronze Trophy
    edited Jan 22, 2018 11:40AM

    Hi,

    did you check the other node?

    Perhaps the SCAN IP is up on the other node and the SCAN listener runs theres

    ==> please run

    srvctl status scan_listener

    ==> this will tell you on which node the SCAN listener is running and then

    run

    lsnrctl status LISTENER_SCAN1 on that node.

    As long as your SCAN name has only one IP address assigned you will not be able to add additional SCAN listeners.

    HTH

    Markus

  • Jhil
    Jhil Member Posts: 3,182 Bronze Trophy
    edited Jan 22, 2018 12:15PM Answer ✓

    Hi Markus,

    >> I executed following command as 'grid' user, but  previously i executed as 'oracle' user

    [[email protected] ~]$ lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 23-JAN-2018 04:26:28

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

    STATUS of the LISTENER

    ------------------------

    Alias                     LISTENER_SCAN1

    Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production

    Start Date                23-JAN-2018 04:04:06

    Uptime                    0 days 0 hr. 22 min. 22 sec

    Trace Level               off

    Security                  ON: Local OS Authentication

    SNMP                      OFF

    Listener Parameter File   /u01/product/11.2.0/grid/network/admin/listener.ora

    Listener Log File         /u01/product/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml

    Listening Endpoints Summary...

      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.115)(PORT=1521)))

    Services Summary...

    Service "cisco.com" has 1 instance(s).

      Instance "cisco1", status READY, has 1 handler(s) for this service...

    Service "ciscoXDB.com" has 1 instance(s).

      Instance "cisco1", status READY, has 1 handler(s) for this service...

    The command completed successfully

    >> I am executing same command as 'oracle' user

    [[email protected] ~]$ lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 23-JAN-2018 04:33:49

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

    TNS-01101: Could not find service name LISTENER_SCAN1

    REF_LINK :  https://oraclehandson.wordpress.com/2010/05/21/oracle-11gr2-scan-configuration/

    >> How to add one more scan listener , if i do NOT use DNS

    https://www.orskl.com/how-to-add-a-new-scan-listener-in-oracle-11gr2-rac-setup/

    Just i referred and NOT tested.

    Thanks

  • Hemant K Chitale
    Hemant K Chitale Oracle DBA OCP OCE SingaporeMember Posts: 15,759 Blue Diamond
    edited Jan 22, 2018 8:56PM

    The SCAN listener runs from the grid account and grid ORACLE_HOME,  not the rdbms oracle account and ORACLE_HOME

    Hemant K Chitale

  • Jhil
    Jhil Member Posts: 3,182 Bronze Trophy
    edited Jan 23, 2018 6:14AM

    Yes, i got it.

    The following links talks about adding one more scan listener, if we do not use DNS setup.

    https://www.orskl.com/how-to-add-a-new-scan-listener-in-oracle-11gr2-rac-setup/

    I meant to say .. i am using /etc/hosts file and NOT using DNS

    in this case, its possible to add more than 1 scan listener ..

This discussion has been closed.