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 > >