©OraInternals<wbr> Riyaj Shamsudeen<br>
SCAN,VIP,HAIP,etc.<br>
By<br>
Riyaj Shamsudeen<br>
Blog:<wbr>
orainternals.wordpress.com<wbr><br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
2<br>
Who am I?<br>
19 years using Oracle products/DBA<br>
OakTable<wbr> member<br>
Oracle ACE Director<br>
Certified DBA versions 7.0,7.3,8,8i,9i<br>
&10g<br>
Specializes in RAC, performance tuning,<br>
Internals and E-business suite<br>
Chief DBA with OraInternals<br>
Co-author of few books.<br>
Email: <a href="mailto:rshamsud@orainternals.com">rshamsud@orainternals.com</a><br>
Blog : orainternals.wordpress.com<wbr><br>
Web: <a href="http://www.orainternals.com/">www.orainternals.com</a><br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
3<br>
Outline<br>
VIP<br>
SCAN<br>
HAIP<br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
4<br>
VIP<br>
Virtual IP address<br>
An IP address not statically linked to just one node or
interface.<br>
Provides a mechanism for faster failovers.<br>
Each node must have one Virtual IP
address.<wbr><br>
All primary VIPs of<wbr> a cluster must be in the
same subnet.<br>
However, second (or more) network is possible.<br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
5<br>
ifconfig<br>
$ / sbin/ifconfig<wbr> -a<br>
…<br>
e1000g0:1:<br>
flags=1040843<br>
D,IPv4><wbr> mtu<wbr> 1500
index 2 inet 172.16.140.151 netmask<br>
ffff0000 broadcast 172.16.255.255<br>
...<br>
Notice :1 in the interface name.<br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
6<br>
Listener<br>
$ lsnrctl status listener<br>
LSNRCTL for Solaris: Version 11.2.0.2.0 - Production<br>
on 18-FEB-2012 15:31:27<br>
…<br>
Listening Endpoints Summary…<wbr><br>
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY =LISTENER))<br>
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)<br>
(HOST=172.16.140.151)(PORT=1521)))<br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
7<br>
Connect string<br>
just_vips=<br><wbr>(description=<br><wbr><wbr> (load_balance=off)<br><wbr><wbr>
(address=(protocol=tcp)(host=172.16.140.151)(port=1521))<br><wbr><wbr>
(address=(protocol=tcp)(host=172.16.140.152)(port=1521))<br><wbr> ( connect_data=<br><wbr><wbr><wbr><wbr>
( service_name=racdb)<br><wbr><wbr> )<br><wbr>)<br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
8<br>
Connect timeout<br>
truss -d -E -vall sqlplus <a href="mailto:rs@just_vips">rs@just_vips</a><br>
...<br>
3.0730<wbr> 0.0002 connect(9, 0x00539F10, 16,
SOV_DEFAULT)<wbr> Err#150<br>
EINPROGRESS<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
AF_INET<wbr> name = 172.16.140.151<wbr>
port = 1521<br>
3.0731<wbr> 0.0000
brk(0x00540D90)<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
= 0<br>
3.0732<wbr> 0.0000
brk(0x00544D90)<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
= 0<br>
pollsys(0xFFFFFD7FFFDEFC60, 1, 0xFFFFFD7FFFDEFB40,
0x00000000)<br>
(sleeping...)<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
fd=9<wbr> ev=POLLOUT rev=0xFFFFFFFF<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
timeout: 60.000000000 sec<br>
63.0735<wbr> 0.0000
pollsys(0xFFFFFD7FFFDEFC60,1,0xFFFFFD7FFFDEFB40,<br>
0x00000000)= 0<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
fd=9<wbr> ev=POLLOUT rev=0<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
timeout: 60.000000000 sec<br>
63.0740<wbr> 0.0001
close(9)<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br>
©OraInternals<wbr> Riyaj Shamsudeen<wbr>
9<br>
VIP failed over<br>
0.0799<wbr><wbr> so_socket(PF_INET,
SOCK_STREAM, IPPROTO_IP, "", SOV_DEFAULT) = 9<br>
0.0800<wbr> ioctl(9, FIONBIO,
0xFFFFFD7FFFDEF9D8)<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
= 0<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
write 4 bytes<br>
0.0801<wbr> connect(9, 0x0053BDF0, 16, SOV_DEFAULT)
Err#146<wbr> ECONNREFUSED<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr>
AF_INET<wbr> name =
172.16.140.151<wbr><wbr> port =
1521<br>
0.0802<wbr>
close(9)<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>