©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>
SCAN,VIP,HAIP,etc.
最新推荐文章于 2024-08-20 13:24:05 发布