Jon Foreman wrote:
Does anyone have any suggestions for the following problem:
I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle
database. Periodically, PHP is unable to connect to the database. When this
problem occurs, I am able to connect to the database from the webserver
without any problem using SQLPlus. I've also run tcpdump on my database
server and I see no incoming requests from the problem web server when I run
a PHP page that queries the database.
A graceful restart of apache, or simple 'apachectl restart' do not fix the
problem. I have to manually stop and start the Apache process and the
problem goes away (for a while at least).
We are using persistent database connections, but non-persistent ociconnect
calls also fail. The number of DB connections is unlimited in the php.ini
config. Also, my DB server has plenty of capacity to accommodate many more
Are you getting any errors? Are the failing connections to the same or
different database users? What sorts of load is Apache under? What
platform? What kinds of statements are being run (is anything blocking
threads/connections etc)? Are you using the "oci8" or "oracle" calls (do
both have the problem)?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php