Skip to Main Content

Database Software

QUESTIONS ABOUT SCAN-LISTENER

JhilJan 21 2018 — edited Jan 26 2018

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 ?

[root@RAC1 ~]# srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac1

[root@RAC1 ~]# srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac1

[root@RAC1 ~]# 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

This post has been answered by Jhil on Jan 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2018
Added on Jan 21 2018
12 comments
1,037 views