Something wrong with my scan configuration (RAC 11g R2)
jkosticMar 17 2013 — edited Mar 19 2013Hello,
I have a 5 nodes cluster: clujko
Here is my crsctl status res -t ouput
LOCAL RESOURCES
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.FRA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.ORADATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.REDO.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ONLINE ONLINE node3 Started
ONLINE ONLINE node4 Started
ONLINE ONLINE node5 Started
ora.eons
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
OFFLINE OFFLINE node3
OFFLINE OFFLINE node4
OFFLINE OFFLINE node5
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ONLINE ONLINE node3
ONLINE ONLINE node4
ONLINE ONLINE node5
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node5
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node3
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.node3.vip
1 ONLINE ONLINE node3
ora.node4.vip
1 ONLINE ONLINE node4
ora.node5.vip
1 ONLINE ONLINE node5
ora.oc4j
1 OFFLINE OFFLINE
ora.pmu.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
3 ONLINE ONLINE node3 Open
ora.scan1.vip
1 ONLINE ONLINE node5
ora.scan2.vip
1 ONLINE ONLINE node3
ora.scan3.vip
1 ONLINE ONLINE node2
Here is my scan configuration:
[root@node1 ~]# srvctl config scan
SCAN name: clujko-scan, Network: 1/192.168.1.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /clujko-scan.jkolicorne.fr/192.168.1.75
SCAN VIP name: scan2, IP: /clujko-scan.jkolicorne.fr/192.168.1.73
SCAN VIP name: scan3, IP: /clujko-scan/192.168.1.74
[root@node1 ~]# 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
[root@node1 ~]# srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node node5
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node node3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node node2
DNS resolutions
[root@node1 ~]# nslookup clujko-scan
Server: 192.168.1.130
Address: 192.168.1.130#53
Name: clujko-scan.jkolicorne.fr
Address: 192.168.1.73
Name: clujko-scan.jkolicorne.fr
Address: 192.168.1.74
Name: clujko-scan.jkolicorne.fr
Address: 192.168.1.75
[root@node1 ~]# nslookup node1-vip
Server: 192.168.1.130
Address: 192.168.1.130#53
Name: node1-vip.jkolicorne.fr
Address: 192.168.1.41
[root@node1 ~]# nslookup node2-vip
Server: 192.168.1.130
Address: 192.168.1.130#53
Name: node2-vip.jkolicorne.fr
Address: 192.168.1.43
[root@node1 ~]# nslookup node3-vip
Server: 192.168.1.130
Address: 192.168.1.130#53
Name: node3-vip.jkolicorne.fr
Address: 192.168.1.45
[root@node1 ~]# nslookup node4-vip
Server: 192.168.1.130
Address: 192.168.1.130#53
Name: node4-vip.jkolicorne.fr
Address: 192.168.1.47
[root@node1 ~]# nslookup node5-vip
Server: 192.168.1.130
Address: 192.168.1.130#53
Name: node5-vip.jkolicorne.fr
Address: 192.168.1.49
Local listeners on each instance are:
alter system set local_listener ='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip.jkolicorne.fr)(PORT=1521))))' sid='PMU_1';
alter system set local_listener ='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip.jkolicorne.fr)(PORT=1521))))' sid='PMU_2';
alter system set local_listener ='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node3-vip.jkolicorne.fr)(PORT=1521))))' sid='PMU_3';
alter system set local_listener ='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node4-vip.jkolicorne.fr)(PORT=1521))))' sid='PMU_4';
alter system set local_listener ='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node5-vip.jkolicorne.fr)(PORT=1521))))' sid='PMU_5';
I can connect using node1-vip, node2-vip and node3-vip because the instance is actualy running on those 3 nodes bu I can not connect to node4-vip and node5-vip which is normal.
But I cannot connect using clujko-scan.jkolicorne.fr
It should be verry simple to resolve but I need a different view on the problem :-)
Thanks for your help
jko