Thanks for all your responses. It was really helpful as always. Thanks again, Sami On Mon, 13 Dec 2004 19:20:55 -0500, Richard Ji <richard.c.ji@xxxxxxxxx> wrote: > Just failover is doable, instead of using host, port, sid format, you will > have to use the whole TNS connection descriptor and specify > multiple entries in there. You can also do load balancing that way. > -- //www.freelists.org/webpage/oracle-l