tag:blogger.com,1999:blog-2183932096317222451.post1122139719674251312..comments2024-03-02T13:46:10.263-05:00Comments on askMLabs: How to add SCAN LISTENER in 11gR2askMLabshttp://www.blogger.com/profile/11014598673455416042noreply@blogger.comBlogger25125tag:blogger.com,1999:blog-2183932096317222451.post-87407740596576043112013-01-03T13:12:06.000-05:002013-01-03T13:12:06.000-05:00Hi Gautham, Before issuing this command, your need...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.Srikrishna Murthy Annamnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-53749206616459280612012-12-21T11:20:20.000-05:002012-12-21T11:20:20.000-05:00Hi Sir,When you type "srvctl modify scan -n r...Hi Sir,<br><br>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).Gauthamnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-10620294054459650872012-07-23T15:59:35.000-04:002012-07-23T15:59:35.000-04:00THANKSSSSSSSSSSSSSSSS !!!IT HELP ME ALOT !!!!YOUR ...THANKSSSSSSSSSSSSSSSS !!!<br>IT HELP ME ALOT !!!!<br>YOUR GOD BLESS YOU EVERY DAY!!!!!!viviennoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-38571788439088136532012-02-14T09:22:48.000-05:002012-02-14T09:22:48.000-05:00Thank you AdrianThank you Adrianlearnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-64802937971963183682012-02-13T11:39:46.000-05:002012-02-13T11:39:46.000-05:00the howto is good.one remark: the below commands o...the howto is good.<br>one remark: the below commands onwards should be run as grid and not root<br>from<br>[root@rac01 network-scripts]# /u01/home/11.2.0/grid/bin/srvctl start scan_listener<br>to<br>[grid@rac01 network-scripts]# /u01/home/11.2.0/grid/bin/srvctl start scan_listener<br><br>Basically this is covered in How to Modify SCAN Setting or SCAN Listener Port after Installation (Doc ID 972500.1), for those having MOS accountsAdriannoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-28360956916835281732011-12-06T05:33:40.000-05:002011-12-06T05:33:40.000-05:00Hi Thahir, DNS configuration is required to r...Hi Thahir,<br> DNS configuration is required to resolve host-ip configuration. We can achieve the same thing by specifying the entries in /etc/hosts file. <br>Thanks <br>SRIlearnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-6570756809061313092011-11-29T12:47:37.000-05:002011-11-29T12:47:37.000-05:00hi, i mentioned 3 scan ip 172.16.101.201/202/203...hi,<br> 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.<br><br>by,<br>Thahir.Mohamed Abuthahir.Snoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-29109474783368354202011-09-28T15:14:01.000-04:002011-09-28T15:14:01.000-04:00Hi Pravin, Please provide me following detai...Hi Pravin,<br> Please provide me following details : <br><br> set lines 120<br> set pages 200<br> column name format a20 tru<br> column value format a40 wra<br> select inst_id, name, value <br> from gv$parameter<br> where name in ('service_names','local_listener','remote_listener',<br> 'db_name','db_domain','instance_name')<br> order by 1,2,3;<br> <br> ps -ef | grep -i tns ( on each rac node)<br> <br> srvctl status scan_listener -i ( For all scan listeners)<br><br>Thanks<br>SRIlearnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-558518947877007392011-09-17T05:56:41.000-04:002011-09-17T05:56:41.000-04:00Hi SRI,server1:xyzadm 102> srvctl config scanSC...Hi SRI,<br><br>server1:xyzadm 102> srvctl config scan<br>SCAN name: cscan.xyz.local, Network: 1/cc.xxx.yy.0/255.255.240.0/eth0<br>SCAN VIP name: scan1, IP: /cscan.xyz.local/cc.xxx.yy.57<br>SCAN VIP name: scan2, IP: /cscan.xyz.local/cc.xxx.yy.56<br>SCAN VIP name: scan3, IP: /cscan.xyz.local/cc.xxx.yy.58<br>server1:xyzadm 103> srvctl config scan_listener<br>SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521<br>SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521<br>SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521<br>server1:xyzadm 104><br>server1:xyzadm 76> srvctl status service -d XYZ<br>Service XYZ_D01 is running on instance(s) XYZ001<br>Service XYZ_D02 is running on instance(s) XYZ002<br>server1:xyzadm 77><br>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?Pravinnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-65044543237003583692011-09-07T07:25:07.000-04:002011-09-07T07:25:07.000-04:00Thank you. :-)Thank you. :-)learnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-83953953756276240622011-09-06T13:09:34.000-04:002011-09-06T13:09:34.000-04:00good article ;) you solve my problem. I was only h...good article ;) you solve my problem. I was only have one scan ip, now I have 3 scan ip. Thanks a lotAdminhttp://levicorp.comnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-43493892094779417112011-08-18T05:00:20.000-04:002011-08-18T05:00:20.000-04:00thank youthank yougrianggrainoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-64488412628225328642011-03-01T19:25:56.000-05:002011-03-01T19:25:56.000-05:00Thanks my fried, you save my life!Thanks my fried, you save my life!Ivannoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-55497388517528456942011-03-01T14:51:27.000-05:002011-03-01T14:51:27.000-05:00Thats good. Thank you for reading this article.Thats good. Thank you for reading this article.learnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-75516096505474307792011-03-01T14:43:54.000-05:002011-03-01T14:43:54.000-05:00Problem has been resolved.Issue was in /etc/nsswit...Problem has been resolved.<br>Issue was in /etc/nsswitch.conf<br>Line<br>hosts: files nis dns<br>changed to<br>hosts: files dns<br>Then rerun modify command and everything ok after that.Steve McGoonanoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-66584547933344230642011-03-01T14:37:28.000-05:002011-03-01T14:37:28.000-05:00Pls execute the following steps and provide me the...Pls execute the following steps and provide me the two trace files.<br>=========<br>script trace1.log<br>export SRVM_TRACE=TRUE<br>srvctl modify scan -n geodbscan2<br>exit<br><br>strace -aef -o trace2.log srvctl modify scan -n geodbscan2<br>==========<br><br>Thanks<br>SRIlearnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-69072595541845840762011-03-01T14:14:52.000-05:002011-03-01T14:14:52.000-05:00# nslookup geodbscan2Server: 10.0.2.126Add...# nslookup geodbscan2<br>Server: 10.0.2.126<br>Address: 10.0.2.126#53<br><br>Name: geodbscan2.example.com<br>Address: 10.0.10.69<br>Name: geodbscan2.example.com<br>Address: 10.0.10.67<br>Name: geodbscan2.example.com<br>Address: 10.0.10.68Steve McGoonanoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-80557324227739456262011-03-01T13:57:58.000-05:002011-03-01T13:57:58.000-05:00The scan name should be correctly configured. It s...The scan name should be correctly configured. It should be resolved to 3 IPs. Pls provide me the information requested above.learnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-21402134745690329152011-03-01T13:52:38.000-05:002011-03-01T13:52:38.000-05:00I have similar issue, but after running the "...I have similar issue, but after running the "srvctl modify scan", I see no change.<br>The config scan still shows only one IP.<br># /home/app/Clusterware/11.2.0.1/grid/bin/srvctl modify scan -n geodbscan2<br># /home/app/Clusterware/11.2.0.1/grid/bin/srvctl config scan<br>SCAN name: geodbscan2, Network: 1/10.0.0.0/255.255.0.0/eth0<br>SCAN VIP name: scan1, IP: /10.0.10.67/10.0.10.67<br><br>Any ideas?Steve McGoonanoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-67923301472475231982011-03-01T13:04:13.000-05:002011-03-01T13:04:13.000-05:00Give me the output of following commands :host rac...Give me the output of following commands :<br>host rac-scan<br>nslookup rac-scan<br><br>SQL> conn test/test@ => What is the error messg you are getting.learnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-11753643860928820392011-02-28T21:42:32.000-05:002011-02-28T21:42:32.000-05:00I have the same issue where only one LISTENER_SCAN...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<br>still only returns LISTENER_SCAN1. The only difference i noticed was that when you did <br>srvctl config scan<br>SCAN name: rac-scan, Network: 1/133.22.38.0/255.255.255.0/eth2<br>SCAN VIP name: scan1, IP: /rac-scan.example.com/133.22.67.192<br>I got SCAN VIP name: scan1, IP: // instead of /<br>Any ideas on what is wrong?Shahabnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-82818903895205538082011-02-23T20:42:09.000-05:002011-02-23T20:42:09.000-05:00Thank you very much for this blog which helped me ...Thank you very much for this blog which helped me a lot!Syccynoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-79777842305418149442011-02-16T09:14:32.000-05:002011-02-16T09:14:32.000-05:00hi,Thanks a lot, works perfectly !Regards,Emmanuel...hi,<br><br>Thanks a lot, works perfectly !<br><br>Regards,<br><br>EmmanuelEmmanuelnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-16905548049998739812010-12-14T11:24:22.000-05:002010-12-14T11:24:22.000-05:00Thanks you too for your comment and feedback.Thank...Thanks you too for your comment and feedback.<br><br>Thanks<br>SRIlearnwithme11gnoreply@blogger.comtag:blogger.com,1999:blog-2183932096317222451.post-31039122518571070452010-11-17T10:41:56.000-05:002010-11-17T10:41:56.000-05:00Thank you so much for this HowTo. That saved a lot...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)<br><br>Thanks. :-)Bornernoreply@blogger.com