Hi Sanjay You should be able to change your host ip to the vip ip for the service associate with the database you are connecting to and the sid the that service. You would in theory have then failover for your script, it wont matter which instance of your cluster is up. Cheers ________________________________ From: Sanjay Mishra [mailto:smishra_97@xxxxxxxxx] Sent: Thursday, 5 April 2007 02:55 AM To: oracle-l@xxxxxxxxxxxxx Subject: Perl DBI connection with RAC environment Hi I had single instance Oracle 8i Database earlier and now new environment is created with Oracle 10g RAC. There are several perl program been used to perform some application and I appreciate if somebody can guide as how to make changes in string Existing String is like unless ($san_db = DBI->connect("dbi:Oracle:host=192.168.111.111;sid=sandb", "scott", "tiger", {LongReadLen => 8000, AutoCommit => 0})) { ... I have two RAC node sandb1 and sandb2 Thanks Sanjay ________________________________ The fish are biting. Get more visitors <http://us.rd.yahoo.com/evt=49679/*http://searchmarketing.yahoo.com/arp/ sponsoredsearch_v2.php?o=US2140&cmp=Yahoo&ctv=Q107Tagline&s=Y&s2=EM&b=50 > on your site using Yahoo! Search Marketing. <http://us.rd.yahoo.com/evt=49679/*http://searchmarketing.yahoo.com/arp/ sponsoredsearch_v2.php?o=US2140&cmp=Yahoo&ctv=Q107Tagline&s=Y&s2=EM&b=50 >