Skeeve has asked for the wisdom of the Perl Monks concerning the following question:
Is there a way to specify more than one host in a DBI connection string?
use DBI; $dbh=DBI->connect("dbi:Oracle:host=host1.my.do.main;sid=MYDB","me","se +cret");
As I didn't find anything in the documentation, I looked into the source, but couldn't understand it. Maybe someone here knows?
The reason behind this is, that I usually connect by just using the SID. Unfortunately something is wrong with the perl installation on the machine and DBI::connect dumps core (segmentation fault) as soon as I don't supply a host. Usually if I connect with just the SID, it should find a host from tnsnames.ora. I thought, a workaround would be to give all the hosts in the connect string.
s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
+.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e
|
---|
Back to
Seekers of Perl Wisdom