oci8 cannot connect after restarting DB
| From: | Michael Caplan | Date: | Tue, 16 Nov 2004 14:07:44 +0000 |
| Subject: | oci8 cannot connect after restarting DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37291@lists.php.net to get a copy of this message | ||
Every evening, for whatever reason, our Oracle db (9.2.0) is restated.
After it is restarted, I am unable to build a connection with Oracle from
PHP untill Apache is restarted.
Whenever I do an ociplogon() or ocilogon() following an Oracle DB restart,
it fails but I am unable to get a description of the error. Restarting
Apache "fixes" the problem.
Has anyone else experianced the same issue? It appears to me that this is a
php oci8 bug. (shouldn't a new connection be built if a persistant
connection fails, and if not using persistant connections, shouldn't this be
a non issue?)
Thanks,
Michael