I'm sorry. Here's the error I get:
ORA-01034: ORACLE not available (DBD ERROR:
OCISessionBegin)
--- Mark Vandenbroeck <[EMAIL PROTECTED]>
wrote:
> Paul,
>
> It might help if you gave us the error message(s).
>
> Mark
>
> ----- Original Message -----
> From: "Paul Tjapkes" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, February 19, 2001 11:59 AM
> Subject: DBD::Oracle persistent connection
>
>
> > 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/
> >
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
