Hi John, Just saw your blog today on Andi's PHP5 / Oracle article. One of the two bugs you sited in your previous email was one that I opened (http://bugs.php.net/bug.php?id=30808) I'm not sure what the case is with the 4.3.x line, but my hunch this issue is 'bigger' than PHP5. More troubling is tony2001 response to my bug report (we don't want to turn on the noted fix, but will implement something workable with PDO). I'm anxious to hear his reply to my follow-up: it makes no sense to me that oracle users will have to settle for broken logon functions (with the fix sitting commented in the current code) or abandond the oci8 library all together for PDO when it hits the streets (which will be some time). Best, Michael -----Original Message----- From: John Lim [mailto:jlim@xxxxxxxxxxxxxx] Sent: Thursday, November 18, 2004 3:42 AM To: php-db@xxxxxxxxxxxxx Subject: 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@xxxxxxxxxxxxxx> wrote in message news:20041118072559.26084.qmail@xxxxxxxxxxxxxxx > 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@xxxxxxxxxxxx> wrote in message > news:A722EED83069D611AED200508B8B0D9106348C4E@xxxxxxxxxxx >> 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 >> >> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
