Hi Nigel Thanks for the response your blog is crystal clear. regards Hrishy --- On Wed, 1/7/09, Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx> wrote: From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx> Subject: Re: RAC interview question To: hrishys@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Date: Wednesday, 1 July, 2009, 1:30 PM Hrishy I blogged about something similar for JDBC thin client connections - see http://preferisco.blogspot.com/2006/04/micro-partitioning-pooled-sessions-in.html The client tnsnames settings are very similar. Regards Nigel 2009/7/1 hrishy <hrishys@xxxxxxxxxxx> Hi I was searching for some RAC interview question on the net and came across this interesting question. http://forums.oracle.com/forums/thread.jspa?threadID=359799 Question: Configure your client TNS so that it connects to PROD3 first then PROD2 and both fails then to prod1. (There will be lot of glitches on the network). I must say i am stumped by this question does anybody know how to go about doing this ? regards Hrishy