you could move to a database that supports hot backups. postgresql perhaps ?
> -Original Message-
> From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
> Sent: 10 July 2001 10:40
> To: Taylor, Stewart
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Oracle 8i + non perstistant database connections
> remaining open.
>
>
> On Tue, Jul 10, 2001 at 09:32:32AM +0100, Taylor, Stewart wrote:
> > Hello,
> >
> >
> > I'm using
> > OCI8 Revision 1.96
> > Oracle Version 8.1
> > Apache Apache/1.3.11
> > Redhat Linux 6.2
> > php 4.0.2
> >
> > I am connecting to my database using a non-persistant
> connection (ocilogin).
> > My applications run with no problems during the day.
> However, at the end
> > of the day there is about 20 database connections still
> open. This has
> > caused a problem because when the database is shutdown to
> backup (overnight)
> > and then restarted apache still retains the 20 connections.
> This means
> > that when users begin using the applications again in the
> morning apache
> > starts reusing the old connections plus creating some new
> ones and causes
> > users to be intermittently logged out/refused access/random
> query failures
> > etc.. The error messages logged when this happens are below:
> > PHP Warning: failed to rollback outstanding transactions!:
> ORA-01012: not
> > logged on
> > PHP Warning: failed to rollback outstanding transactions!:
> > ORA-24324:service handle not initialized
> >
> > A quick fix to this problem is to shutdown apache when the
> backup is run so
> > all the connections are dropped/
> >
> > Hovever, should these connections be remaining open in the
> first place? Has
> > anyone got any ideas?
>
> if you only use ocilogon and _not_ ociplogon the connection
> will be closed at request and, and apache/php will not keep
> then open - believe me!
>
> please triple check your setup and report back!
>
> tc
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
