Re: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-21 Thread Leo D. Geoffrion
It worked! I did not need to restart apache this morning in order to get an oracle connection. Michael Caplan wrote: Leo, Please let me know how that works for you. I don't remember the specifics (if we where testing using plogon, nlogon or just logon), but we did try and implement that fix and

Re: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-21 Thread Leo D. Geoffrion
The patch described in 30808 worked fine last night. Leo D. Geoffrion wrote: Turns out that it's covered in bug report 30808. I've applied the edit mentioned there and will see if this solves my problem (have to wait for the next Oracle restart overnight). The discussion there is quite revealing

Re: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-20 Thread Leo D. Geoffrion
Turns out that it's covered in bug report 30808. I've applied the edit mentioned there and will see if this solves my problem (have to wait for the next Oracle restart overnight). The discussion there is quite revealing about the fact that oci8 connections are always persistent even if you do

Re: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-20 Thread Michael Caplan
Hi Leo, We are having the same problem. Check out the bug I filed many months ago http://bugs.php.net/bug.php?id=30808 I can't for the life of me figure out why the bug is suspended, as this seems to be a common issue with Oracle and php5. Perhaps you should also and your comments to the bug

RE: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-20 Thread Michael Caplan
Leo, Please let me know how that works for you. I don't remember the specifics (if we where testing using plogon, nlogon or just logon), but we did try and implement that fix and it didn't work for us. Thanks, Michael -Original Message- From: Leo D. Geoffrion [mailto:[EMAIL

[PHP-DB] Losing the ability to connect to Oracle database

2005-04-19 Thread Leo D. Geoffrion
I recently upgraded to PHP5 and now have a curious Oracle problem. The PHP scripts query the database fine. Then overnight, the database shuts down for backup and restarts. The next day, PHP can no longer connect to the database until I restart Apache. Then, it's happy until Oracle restarts

Re: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-19 Thread Christopher Jones
Leo D. Geoffrion wrote: I recently upgraded to PHP5 and now have a curious Oracle problem. The PHP scripts query the database fine. Then overnight, the database shuts down for backup and restarts. The next day, PHP can no longer connect to the database until I restart Apache. Then, it's happy