I have a script that needs to be connected to Oracle
all the time. Everything works fine until Oracle goes
down for a cold backup.
My code looks something like this:
# Start of script
$dbh = DBI->Connect("dbi:Oracle:$db",$un,$pw);
# Within a large loop
unless ($dbh->ping) {
$dbh->disconnect;
undef $dbh;
sleep(1800);
$dbh = DBI->Connect("dbi:Oracle:$db",$un,$pw);
}
The problem is that the connect will continue to fail,
even when Oracle is back up. The only way to
reconnect is to restart the script. And ideas?
TIA
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
