Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
QUESTIONS ABOUT SCAN-LISTENER
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
Best Answers
-
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
-
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
Answers
-
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
-
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
-
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
-
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?
-
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 .
-
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 ?
-
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
-
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
-
The SCAN listener runs from the grid account and grid ORACLE_HOME, not the rdbms oracle account and ORACLE_HOME
Hemant K Chitale
-
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 ..
