Re: [phplib] R: [phplib] PHPLib with oracle From: Mikhail Avrekh (ami <email protected>)
Date: 12/23/00

Yes, I had the same problem... I think it has to do with "persistent
connections" which PHPLIB establishes. Using OCIlogon instead of OCIplogon
might help.

I had another problem of the same nature for which I never found an
adequate solution: my connections to Oracle go through a firewall, and it
always cuts them off overnight due to inactivity. In the morning, apache
is confused, because there is no longer a connection in place although it
still thinks there is one. Neither OCIlogon nor Apache's KeepAlive seem to
help. Does anyone have any suggestions ?

M.

On Fri, 22 Dec 2000 Francesco.Marsan <email protected> wrote:

> Hi,
>
> I have noticed the same behaviour. We restart Oracle every night, and we
> have to restart Apache accordingly, to make it work. Don't know exactly why
> this happens. I suspect it has to do with the fact that Apahe keeps a
> certain number of Oracle sessions permanently active, and if you shut down
> Oracle it gets confused.
>
> HTH
> Francesco
>
>
> -----Messaggio originale-----
> Da: Kenneth Siu [mailto:kenneth <email protected>]
> Inviato: venerd́ 22 dicembre 2000 2.52
> A: Phplib
> Oggetto: [phplib] PHPLib with oracle
>
>
> Hi,
>
> I am using db_oci8.inc with PHPLib-7.2c. The Oracle7.3 server is on a remote
> machine. The library works well normally. Except I found that after I've
> rebooted the Oracle server, I have to restart apache accordingly to make it
> work again. Does anyone know why and how to solve this problem?
>
> -Ken
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>