Re: oci8 cannot connect after restarting DB

Hi This is because you are using persistent connections, which are left dangling and do not restart after the database restarts. Apparently you can hack your tnsnames.ora or oci8 extension. See http://bugs.php.net/bug.php?id=15390 and http://bugs.php.net/bug.php?id=30808 Regards, John "Michael Caplan" <michael.caplan@lechateau.ca> wrote in message news:A722EED83069D611AED200508B8B0D9106348C4E@EXCHANGE... > 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 > >