On Tue, Mar 20, 2001 at 04:55:31PM -0000, [EMAIL PROTECTED] wrote:
> From:             [EMAIL PROTECTED]
> Operating system: Redhat 6.1 Linux
> PHP version:      4.0.4pl1
> PHP Bug Type:     OCI8 related
> Bug description:  OCIPLogon flaky after restart Oracle
> ./configure' '--prefix=/var/php' '--with-config-file-path=/var/php' 
>                                           '--enable-sigchild' 
>'--with-apache=../apache_1.3.14' '--with-ftp' '--with-xml'
>                                           '--with-mcrypt=/var/libmcrypt' 
>'--with-oci8=/u01/app/oracle/product/8.1.6' '--with-mysql=/var/mysql'
> When using OCIPLogon for persistent connections, I'm noticing that after restarting 
>Oracle, that my PHP application starts getting Oracle errors(ORA-03113 and 
>ORA-03114).  This can be fixed by restarting the webserver after restarting Oracle.  
>I also notice that changing my Oracle connections from OCIPLogon to OCILogon fixes 
>the problem - after making that change I get no errors after restarting Oracle, and I 
>*don't* have to restart the webserver.
> The OCI8 interface must have a bug, right?  I shouldn't have to restart the 
>webserver after restarting Oracle just because I'm using persistent connections, 
>should I?

    plz try the latest 4.0.5RC - we have made some changes - and
    mayby your problem is solved with it. -but- my expierience is
    (and i'm the author of the oci8 interface) that the oci libs
    become unstable once you hard-closed some open connections.

    you could also comment in some code in do_connect (search for
    XXX and oci_ping) which checks if the connection is alive
    _before_ returning it to the script.


PHP Development 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]

Reply via email to