[quote name='Silence..Please' timestamp='1324405668' post='1301171135']

[img]http://i872.photobucket.com/albums/ab288/sajja01/cry-o.gif[/img] pillalu budhiga sadhuvkuntuu unte .. vuncle coming and disturbing us
[/quote]

agreed

SCAN IP's are nothing but 3 different IP's registered in the DNS under the same subnet where the physical Ip's will fall.....RAC lo prati node ki single physical IP, single private IP and single VIP undevi till 10g........and VIP's are more efficient for failover than the physical IP's but since each node has only 1 VIP they introduced the concept of SCAN where the onnecton string can connect through the registered 3 scan IP's in a round robin fashion...........indulo advantage entante, tns entry only only 1 VIP for each node entry cheyyochu, if because of some issue aa IP work cheyyakunte then we have to again change the tns entry to use physical IP....ade scan IP use cheste tns entry lo...each time whenever a connection is established, it will in a round robin fashion using the 3 scan IP's........so aa SCAN ip lo okka IP ki network problem unna migatha 2 IP's tho connect avvochu and this is automatic and no need to change the TNS entry file......


edi SCAN IP use....naaku thelisi

[quote name='Silence..Please' timestamp='1324405763' post='1301171137']

storage ki anavasaram ga kharchu chesthaaru anta ba .. pedha companies lo .. because market lo cheap ga dhorikina kuda .. same storage ni preferred vendors nunchi ekkuva ki kontuu untaru anta .. pedha scams nadusthuu untaay anta

andhu k additional storage kaavaalante.. budget approve avvadhu .. chaala cost authundi ani
[/quote]

induloo kuda scams aaa

[quote name='PMR aka OM' timestamp='1324405746' post='1301171136']

[b]EMC RAC konesaara[/b].. maaku storage acquire chesukunna kaani, EMC team maintain chestadi motham anni serverski Network lo NAS ni , inka disk meeda vachey SAN assignement ni antha..

Akakda SAN ki edho LUNs ani vinnnu,,


[color=#000000][font=sans-serif][size=3]In [/size][/font][/color][url="http://en.wikipedia.org/wiki/Computer_storage"]computer storage[/url][color=#000000][font=sans-serif][size=3], a [/size][/font][/color][b]logical unit number[/b][color=#000000][font=sans-serif][size=3] or [/size][/font][/color][b]LUN[/b][color=#000000][font=sans-serif][size=3] is a number used to identify a [/size][/font][/color][b]logical unit??[/b]
[b]aa sizes fixed chesi , evadiki entha kaavali anukunna, [/b][b]multiples of this fixed LUN loney request pettali antunnaru now a days..[/b]
[/quote]

RAC anedhi Oracle product reddy garu .. EMC ante adhi storage kadha

[quote name='k2s' timestamp='1324405595' post='1301171133']
adi antha meeru sooskovali....maa load balancer pani...aa request ekkada nunchi vachindi.... adi genuine user aa.... bot aa ,...... ??? aney soothamu..... oka visitor ID ichi.... inko poo ani.... meeku famfuthamu...... aa okka request can take down ur whole DB....

aa requests serving thresholds meeru fettukovali....
[/quote]

yeah edho threshold setting change anukunta.. kaani DB antha scene ledhuley , Adhui ekkado EDMZ3 lo untundhi..

akkakdiki touch cheyyali antey Magadheera Cherry gaani lekka fighting sestaaru maa App/Web servers enthati .. BOTU galllu acihina kaani..


okka BOT kaadu , 100 mandhi 100 rakalaBOTS tho vvachina kaani ,, maa Apache & Weblogic vatini

maa vindaravindaa DB server ni touch cheyyanivvvaamu...

[quote name='CheGuevara' timestamp='1324405820' post='1301171140']
SCAN IP's are nothing but 3 different IP's registered in the DNS under the same subnet where the physical Ip's will fall.....RAC lo prati node ki single physical IP, single private IP and single VIP undevi till 10g........and VIP's are more efficient for failover than the physical IP's but since each node has only 1 VIP they introduced the concept of SCAN where the onnecton string can connect through the registered 3 scan IP's in a round robin fashion...........indulo advantage entante, tns entry only only 1 VIP for each node entry cheyyochu, if because of some issue aa IP work cheyyakunte then we have to again change the tns entry to use physical IP....ade scan IP use cheste tns entry lo...each time whenever a connection is established, it will in a round robin fashion using the 3 scan IP's........so aa SCAN ip lo okka IP ki network problem unna migatha 2 IP's tho connect avvochu and this is automatic and no need to change the TNS entry file......


edi SCAN IP use....naaku thelisi
[/quote]

baa tns entry ante enti ?
ekkada untundhi ?

[quote name='Silence..Please' timestamp='1324405668' post='1301171135']

[img]http://i872.photobucket.com/albums/ab288/sajja01/cry-o.gif[/img] pillalu budhiga sadhuvkuntuu unte .. vuncle coming and disturbing us
[/quote]

[img]http://i872.photobucket.com/albums/ab288/sajja01/cry-o.gif[/img]

[quote name='CheGuevara' timestamp='1324405820' post='1301171140']
SCAN IP's are nothing but 3 different IP's registered in the DNS under the same subnet where the physical Ip's will fall.....
[color=#008000][b]RAC lo prati node ki single physical IP, single private IP and single VIP undevi till 10g........and VIP's are more efficient for failover than the physical IP's[/b][/color] but since each node has only 1 VIP they introduced the concept of SCAN where the onnecton string can connect through the registered 3 scan IP's in a round robin fashion..........

.indulo advantage entante, tns entry only only 1 VIP for each node entry cheyyochu, if because of some issue aa IP work cheyyakunte then we have to again change the tns entry to use physical IP...[color=#800000][b].ade scan IP use cheste tns entry lo...[/b][/color]each time whenever a connection is established, it will in a round robin fashion using the 3 scan IP's.......
[color=#ff0000][b].so aa SCAN ip lo okka IP ki network problem unna migatha 2 IP's tho connect avvochu and this is automatic and no need to change the TNS entry file......[/b][/color]


edi SCAN IP use....naaku thelisi
[/quote]

[quote name='PMR aka OM' timestamp='1324405896' post='1301171147']

yeah edho threshold setting change anukunta.. kaani DB antha scene ledhuley , Adhui ekkado EDMZ3 lo untundhi..

akkakdiki touch cheyyali antey Magadheera Cherry gaani lekka fighting sestaaru maa App/Web servers enthati .. BOTU galllu acihina kaani..


okka BOT kaadu , 100 mandhi 100 rakalaBOTS tho vvachina kaani ,, maa Apache & Weblogic vatini

maa vindaravindaa DB server ni touch cheyyanivvvaamu...
[/quote]

[quote name='Silence..Please' timestamp='1324405878' post='1301171144']

RAC anedhi Oracle product reddy garu .. EMC ante adhi storage kadha
[/quote]

RAC antey idhedho [color=#000000][font=sans-serif][size=3]In [/size][/font][/color][url="http://en.wikipedia.org/wiki/Database"]database[/url][color=#000000][font=sans-serif][size=3] [/size][/font][/color][url="http://en.wikipedia.org/wiki/Computing"]computing[/url][color=#000000][font=sans-serif][size=3], [/size][/font][/color][b]Oracle Real Application Clusters (RAC)[/b][color=#000000][font=sans-serif][size=3] .. adhi kada..[/size][/font][/color]

H[font="sans-serif"][size="2"][color="#000000"]mmm, kaani RACK antey malla different anukuntaa mari... aKKAda RACK antey oka section of all servers/disks and some other components ala anukunna ippati varaku..[/color][/size][/font]

[quote name='CheGuevara' timestamp='1324405820' post='1301171140']
SCAN IP's are nothing but 3 different IP's registered in the DNS under the same subnet where the physical Ip's will fall.....RAC lo prati node ki single physical IP, single private IP and single VIP undevi till 10g........and VIP's are more efficient for failover than the physical IP's but since each node has only 1 VIP they introduced the concept of SCAN where the onnecton string can connect through the registered 3 scan IP's in a round robin fashion...........indulo advantage entante, tns entry only only 1 VIP for each node entry cheyyochu, if because of some issue aa IP work cheyyakunte then we have to again change the tns entry to use physical IP....ade scan IP use cheste tns entry lo...each time whenever a connection is established, it will in a round robin fashion using the 3 scan IP's........so aa SCAN ip lo okka IP ki network problem unna migatha 2 IP's tho connect avvochu and this is automatic and no need to change the TNS entry file......


edi SCAN IP use....naaku thelisi
[/quote]

ok .. so instead 1 Physical IP .. scan IP use chesthe .. u will have 3 IP's ?

but still .. VIP kanna scan IP epudu use authundhi ? physical IP fail ainapudu .. VIP use chesi other nodes ki connect authundi kadha ?

[quote name='Silence..Please' timestamp='1324406197' post='1301171156']

ok .. so instead 1 Physical IP .. scan IP use chesthe .. u will have 3 IP's ?

but still .. VIP kanna scan IP epudu use authundhi ? physical IP fail ainapudu .. VIP use chesi other nodes ki connect authundi kadha ?
[/quote]
silence....
eey evvadraa akkada.... veedu edo edo sepi....naaku ochina 2 mukka ni..... confuse sethunnadu ...kotha doubts tho .....

[quote name='k2s' timestamp='1324406292' post='1301171159']
silence....
eey evvadraa akkada.... veedu edo edo sepi....naaku ochina 2 mukka ni..... confuse sethunnadu ...kotha doubts tho .....
[/quote]

naku scan IP ante asalu idea ledu ba

[quote name='Silence..Please' timestamp='1324406409' post='1301171162']

naku scan IP ante asalu idea ledu ba
[/quote]

malli inko doubt ....... maaku telusa..... memu ikada edo corner lo kusoni... nerchukuntam kada.....

SCAN in the Oracle RAC<<<

Why ?? what ? How???


ikkada undi>>>


[url="http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf"]http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf[/url]




USING OPTION 1 - DEFINE THE SCAN IN YOUR CORPORATE DNS
If you choose Option 1, you must ask your network administrator to create a single name that resolves to 3 IP
addresses using a round-robin algorithm. Three IP addresses are recommended considering load balancing and high
availability requirements regardless of the number of servers in the cluster. The IP addresses must be on the same
subnet as your public network in the cluster. The name must be 15 characters or less in length, not including the
domain, and must be resolvable without the domain suffix (for example: “sales1-scan’ must be resolvable as opposed
to “scan1-scan.example.com”). The IPs must not be assigned to a network interface (on the cluster), since Oracle
Clusterware will take care of it.
Figure 2: Sample DNS entry for SCAN
You can check the SCAN configuration in DNS using “nslookup”. If your DNS is set up to provide round-robin
access to the IPs resolved by the SCAN entry, then run the “nslookup” command at least twice to see the round-robin
algorithm work. The result should be that each time, the “nslookup” would return a set of 3 IPs in a different order.
EZconnet sqlplus system/manager@sales1-scan:1521/oltp
JDBC connect jdbc:oracle:thin:@sales1-scan:1521/oltp
sales1-scan.example.com IN A 133.22.67.194
IN A 133.22.67.193
IN A 133.22.67.192