Re: Pls help with Oracle Bug (fwd)

On Wed, 2 Jun 1999, Stig Bakken wrote: > Anything you have seen before? > > - Stig > > ---------- Forwarded message ---------- > Date: Wed, 2 Jun 1999 12:43:08 +0200 > From: Manfred Wuits <manfred@yumyum.at> > To: ssb@guardian.no, mgolden@interport.net, rasmus@lerdorf.on.ca, > Andres.Karajannis@gmd.de > Subject: Pls help with Oracle Bug > > Hi! > I'm writing to all of u, mentioned in the header of the oracle.c > source. > > I would need some help with debugging my installation. > > Description: > > I'm working with PHP since 1998. > I'm running an PHP 3.0.7 Oracle 7.3.2 Combination successfully > for more then 7 months - no problems. > > Now i wanted to mirrror the same system on a new machine, > also php 3.0.7 Oracle7.3.4, it works basically, but not stable: > > Facts: > Oracle7 Server Release > one TCP/IP Listener for Oracle - connected with a dedicated server > > the problem: > > -ora_plogon (and also ora_logon) run stable for about 5 minutes and > then start returning the value 873232 (and no error message), which is an > invalid connection-id, if i want to use it, i get error-messages(of > course). does ora_logon cuase the same problem? that's important information! please double-check and send me the results! tc > > -I looked at the source of oracle.c and found out, that it should > issue some error messages when it cant connect to oracle, but i dont > get any of them. > > -oracle itself is stable > -in the oracle-listener (tnslsnr) log and trace files i get occasional connects > (in the same manner as on my stable system) > > -and here the strange thing: > if i issue a simple reload of the php page using the plogon, > i still get the wrong id. > BUT if i keep pressing Ctrl-R and make a rapid-fire request-flood, > it will come back to life again (connection-id: 1) > if i issue plogon in a loop (no matter how much) from php-code > it will keep the bad-id. > > > My questions: > > -which part of the chain : oracle - listener - oracle-lib - oracle.c - php > returns the wrong id ? > -how can i find out more about the active connections ? > -Or, at least: How could I simulate the behaviour of rapid-fire reload in case of > db-failure ? > > > I want to convince our clients that PHP is a stable and good system, > so it would be good to get this thing up and running soon, I'm losing > my arguments, though I don't think I'm too stupid for this :) > > thanks in advance, (or some telepizza) > > ciao, manfred > > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany