Re: oci8 cannot connect after restarting DB

Michael, After rereading your post again, i realise you mentioned it's happening with non-persistent connections also. That puzzles me. Perhaps we are talking about multiple bugs here. In general, I have not found PHP5 and oci8 to be very stable, and would not recommend moving anything production to use PHP5 just yet. Regardsd, John "John Lim" <jlim@natsoft.com.my> wrote in message news:20041118072559.26084.qmail@pb1.pair.com... > 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 >> >>