ID: 9876
Comment by: gid at gifpaste dot net
Reported By: merrill at missioncriticallinux dot com
Status: Closed
Bug Type: OCI8 related
Operating System: Redhat 6.1 Linux
PHP Version: 4.0.4pl1
New Comment:
I've noticed this as well using cgi mode to run a daemon written in
php. My daemon runs 24/7. If the database goes down when my daemon is
running, sometimes it's able to reconnect, other times it isn't.
Calling OCINLogon() instead of OCILogon() helps, but not always,
sometimes it simply refuses to reconnect until I restart my daemon.
Not a big deal, since our production database rarely goes down, but I
thought I'd mention it. I'll post more info here if I get it.
php 4.3.4, oracle 9.2.0.4.0
Previous Comments:
------------------------------------------------------------------------
[2003-11-18 05:03:05] aferaud at buyingpack dot com
PHP 4.3.3 (Linux) - Oracle 8.1.7 (Win2000)
I've have the same problem, and it still persists with non-persistent
connection...
Is there a solution somewhere ??
------------------------------------------------------------------------
[2002-04-08 22:53:07] bmironov at jonview dot com
Hello,
I have same problem under
RedHat 6.1 / 7.2
Oracle 7.3.4 / 8.1.5
PHP 4.1.2 (--with-oci8)
Apache 1.3.23
I have to restart whole webserver after Database restart. I would like
to use OCIPLogon because of performance issue for very small SELECT's.
------------------------------------------------------------------------
[2001-05-04 10:35:58] [EMAIL PROTECTED]
plz try 4.0.5 - if the problem persists please reopen.
------------------------------------------------------------------------
[2001-03-20 11:55:31] merrill at missioncriticallinux dot com
./configure' '--prefix=/var/php' '--with-config-file-path=/var/php'
'--enable-track-vars'
'--enable-sigchild'
'--with-apache=../apache_1.3.14' '--with-ftp' '--with-xml'
'--with-mcrypt=/var/libmcrypt' '--with-pgsql=/var/postgresql'
'--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?
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=9876&edit=1
