askMLabs

Borner

November 17, 2010 at 10:41 AM

Thank you so much for this HowTo. That saved a lot of time, because adding an SCAN Listener is different from adding an typical cluster ressource (crsct add res ora.scan2.vip... will not work)

Thanks. :-)

learnwithme11g

December 14, 2010 at 11:24 AM

Thanks you too for your comment and feedback.

Thanks
SRI

Emmanuel

February 16, 2011 at 9:14 AM

hi,

Thanks a lot, works perfectly !

Regards,

Emmanuel

Syccy

February 23, 2011 at 8:42 PM

Thank you very much for this blog which helped me a lot!

Shahab

February 28, 2011 at 9:42 PM

I have the same issue where only one LISTENER_SCAN is configured. However, when i try to connect via sqlplus @SCAN-NAME it never connects. My $ORACLE_HOME/network/admin/tnsnames.ora is basically the same as your example above. /u01/home/11.2.0/grid/bin/srvctl modify scan -n SCAN-name
still only returns LISTENER_SCAN1. The only difference i noticed was that when you did
srvctl config scan
SCAN name: rac-scan, Network: 1/133.22.38.0/255.255.255.0/eth2
SCAN VIP name: scan1, IP: /rac-scan.example.com/133.22.67.192
I got SCAN VIP name: scan1, IP: // instead of /
Any ideas on what is wrong?

learnwithme11g

March 1, 2011 at 1:04 PM

Give me the output of following commands :
host rac-scan
nslookup rac-scan

SQL> conn test/test@ => What is the error messg you are getting.

Steve McGoona

March 1, 2011 at 1:52 PM

I have similar issue, but after running the "srvctl modify scan", I see no change.
The config scan still shows only one IP.
# /home/app/Clusterware/11.2.0.1/grid/bin/srvctl modify scan -n geodbscan2
# /home/app/Clusterware/11.2.0.1/grid/bin/srvctl config scan
SCAN name: geodbscan2, Network: 1/10.0.0.0/255.255.0.0/eth0
SCAN VIP name: scan1, IP: /10.0.10.67/10.0.10.67

Any ideas?

learnwithme11g

March 1, 2011 at 1:57 PM

The scan name should be correctly configured. It should be resolved to 3 IPs. Pls provide me the information requested above.

Steve McGoona

March 1, 2011 at 2:14 PM

# nslookup geodbscan2
Server: 10.0.2.126
Address: 10.0.2.126#53

Name: geodbscan2.example.com
Address: 10.0.10.69
Name: geodbscan2.example.com
Address: 10.0.10.67
Name: geodbscan2.example.com
Address: 10.0.10.68

learnwithme11g

March 1, 2011 at 2:37 PM

Pls execute the following steps and provide me the two trace files.
=========
script trace1.log
export SRVM_TRACE=TRUE
srvctl modify scan -n geodbscan2
exit

strace -aef -o trace2.log srvctl modify scan -n geodbscan2
==========

Thanks
SRI

Steve McGoona

March 1, 2011 at 2:43 PM

Problem has been resolved.
Issue was in /etc/nsswitch.conf
Line
hosts: files nis dns
changed to
hosts: files dns
Then rerun modify command and everything ok after that.

learnwithme11g

March 1, 2011 at 2:51 PM

Thats good. Thank you for reading this article.

Ivan

March 1, 2011 at 7:25 PM

Thanks my fried, you save my life!

grianggrai

August 18, 2011 at 5:00 AM

thank you

Admin

September 6, 2011 at 1:09 PM

good article ;) you solve my problem. I was only have one scan ip, now I have 3 scan ip. Thanks a lot

learnwithme11g

September 7, 2011 at 7:25 AM

Thank you. :-)

Pravin

September 17, 2011 at 5:56 AM

Hi SRI,

server1:xyzadm 102> srvctl config scan
SCAN name: cscan.xyz.local, Network: 1/cc.xxx.yy.0/255.255.240.0/eth0
SCAN VIP name: scan1, IP: /cscan.xyz.local/cc.xxx.yy.57
SCAN VIP name: scan2, IP: /cscan.xyz.local/cc.xxx.yy.56
SCAN VIP name: scan3, IP: /cscan.xyz.local/cc.xxx.yy.58
server1:xyzadm 103> srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
server1:xyzadm 104>
server1:xyzadm 76> srvctl status service -d XYZ
Service XYZ_D01 is running on instance(s) XYZ001
Service XYZ_D02 is running on instance(s) XYZ002
server1:xyzadm 77>
with above details and I also tested the nslokup or ping 3 times and IP's round robin is configured correctly. But not able to connect to the database using scan listener. How can I test connection to Database using scan listener?

learnwithme11g

September 28, 2011 at 3:14 PM

Hi Pravin,
Please provide me following details :

set lines 120
set pages 200
column name format a20 tru
column value format a40 wra
select inst_id, name, value
from gv$parameter
where name in ('service_names','local_listener','remote_listener',
'db_name','db_domain','instance_name')
order by 1,2,3;

ps -ef | grep -i tns ( on each rac node)

srvctl status scan_listener -i ( For all scan listeners)

Thanks
SRI

Mohamed Abuthahir.S

November 29, 2011 at 12:47 PM

hi,
i mentioned 3 scan ip 172.16.101.201/202/203 in /etc/hosts file is it correct or we need to configure DNS. Please clear me. I dont know much about os related configuration.

by,
Thahir.

learnwithme11g

December 6, 2011 at 5:33 AM

Hi Thahir,
DNS configuration is required to resolve host-ip configuration. We can achieve the same thing by specifying the entries in /etc/hosts file.
Thanks
SRI

Adrian

February 13, 2012 at 11:39 AM

the howto is good.
one remark: the below commands onwards should be run as grid and not root
from
[root@rac01 network-scripts]# /u01/home/11.2.0/grid/bin/srvctl start scan_listener
to
[grid@rac01 network-scripts]# /u01/home/11.2.0/grid/bin/srvctl start scan_listener

Basically this is covered in How to Modify SCAN Setting or SCAN Listener Port after Installation (Doc ID 972500.1), for those having MOS accounts

learnwithme11g

February 14, 2012 at 9:22 AM

Thank you Adrian

vivien

July 23, 2012 at 3:59 PM

THANKSSSSSSSSSSSSSSSS !!!
IT HELP ME ALOT !!!!
YOUR GOD BLESS YOU EVERY DAY!!!!!!

Gautham

December 21, 2012 at 11:20 AM

Hi Sir,

When you type "srvctl modify scan -n rac-scan" . oracle will automatically configures scan-vip with scan name. How will oracle come to know that 193 and 194 scan ips should be configured to this scan name(rac-scan).

Srikrishna Murthy Annam

January 3, 2013 at 1:12 PM

Hi Gautham, Before issuing this command, your need to configure your scan name to be resolved for 3 IPs. It can be either at the DNS level or at the /etc/hosts file level ( local configurations). When you issue this command, it checks the scan name and if it is resolved to 3 IPs, it will configure scan name to these 3 IPs.