Hi Ron, I've some strange effects with connecting to the SERVICE_NAME.
Sometimes (every 4-5 try) I can connect with sqlplus to liprod02... The same with DBI!!! I don't know about it;( Thanks for your help! Greetings from germany... Andre Am Donnerstag, 7. September 2006 18:14 schrieb Reidy, Ron: > Andre, > > Can you tnsping liprod02? Can you connect to liprod02 via SQL*Plus? > > -- > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > -----Original Message----- > From: Andre Heine [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 10:09 AM > To: dbi-users@perl.org > Subject: Oracle TAF with DBD::Oracle??? > > Hello @all, > > can someone help me with my Oracle TAF Problem? > > I'm trying to write an DBI script, that should use Failover (Oracles > TAF). > But I can't connect to the "SERVICE_NAME", when I used the > "INSTANCE_NAME" the > connect works fine. > > Is there a way to use DBI/DBD::Oracle with TAF? > > Thanks for any hints.... > > Greetings from germany > > Andre > > > Won't work: > my $dbh = DBI->connect("dbi:Oracle:LIPROD02",'user','pass', > {RaiseError => 1, AutoCommit => > 1 }) > or die "$DBI::errstr"; > > Works fine: > my $dbh = DBI->connect("dbi:Oracle:LIPROD021",'user','pass', > {RaiseError => 1, AutoCommit => > 1 }) > or die "$DBI::errstr"; > > > ----------------------------------tnsnames.ora-------------------------- > --------------- > > > LIPROD02 = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999)) > (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999)) > (LOAD_BALANCE = yes) > (FAILOVER=on) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = liprod02) > ) > ) > > LIPROD021 = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = 9999)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = liprod02) > (INSTANCE_NAME = liprod021) > ) > ) > > LIPROD022 = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = 9999)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = liprod02) > (INSTANCE_NAME = liprod022) > ) > ) > > This electronic message transmission is a PRIVATE communication which > contains information which may be confidential or privileged. The > information is intended to be for the use of the individual or entity named > above. If you are not the intended recipient, please be aware that any > disclosure, copying, distribution or use of the contents of this > information is prohibited. Please notify the sender of the delivery error > by replying to this message, or notify us by telephone (877-633-2436, ext. > 0), and then delete it from your system.
