Actually, we run Apache/Oracle 8.1.6/mod PHP4 on Unix boxes here and we also have problems with Oracle maintaining persistent connections. PHP does not maintain a persistent connection to Oracle no matter what. It will insist on creating a new resource id for each discrete call to OCI8 - the obvous result is that you will have many open connections until Oracle carks and u get a "TNS cannot resolve service name error".
The one thing I haven't tried yet, but theoretically should work is to maintain the db resource as a session variable across the application. But that's kludging a "persistent" connection really.... Really, is this a tuning problem in Apache, or Oracle, or something in PHP? Ignatius ----- Original Message ----- From: "Robin Bolton" <[EMAIL PROTECTED]> To: "'Asendorf, John'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 6:55 PM Subject: RE: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon Windows 2000 Server > <reply all - grin> > > John, might I suggest that if you are converting a database from oracle > you may want to consider a database that may more closely matches your > previous system. > > You may be familiar with a Borland InterBase, well they have an open > source descendant named 'Firebird'. > > You can check it out at: http://firebird.sourceforge.net/ > > And all of the PR material can be found at http://www.interbase.com, > anything that InterBase has, Firebird has (and more). > > I'd suggest you give it a quick run through, it's very easy to set up, > and there are several free, quite good gui interfaces. > > And, to top it all off... PHP 4 has full support of InterBase 6.0: > http://www.php.net/manual/en/ref.ibase.php > > > > -----Original Message----- > > From: Asendorf, John [mailto:[EMAIL PROTECTED]] > > Sent: December 6, 2001 10:42 > > To: Jozsef Szilagyi; [EMAIL PROTECTED] > > Subject: RE: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon > > Windows 2000 Server > > > > The main reason is because you're probably NOT getting a persistent > > connection with IIS. I've been fighting with this problem of Oracle > for > > so > > long that I finally gave up on it. I started on IIS4 but couldn't > keep > > the > > server from breaking down after a couple of hours after the first > login > > while using the ISAPI module. There are no persistent connections as > CGI > > (obviously)... then I switched to Apache and had the same problem > you're > > describing. The only way I was able to "fix" it was to increase the > > timeout > > on the Oracle side. But, it still doesn't keep the persistent > connection > > open very well. > > > > SO, I've ported the entire thing over to MySQL (luckily the databases > > aren't > > too big (5 tables, 3 tiny ones and 2 big ones (40,000 and 120,000 > records > > each).... and will be making the transfer the first of the year. > > > > I tried a million different things. What I would mostly suggest is to > use > > the latest php 4.0.8-dev from www.php4win.com and see if some of the > > changes > > Thies has been working on make a difference... he has made a number > of > > changes trying to combat the Oracle on Windows nightmare but I don't > think > > they are included in the 4.0.6 release, and whether or not they'll > work I > > don't know. > > > > Good luck, please let me know if you have any, > > > > John > > > > --------------------- > > John Asendorf - [EMAIL PROTECTED] > > Web Applications Developer > > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > > Licking County, Ohio, USA > > 740-349-3631 > > Nullum magnum ingenium sine mixtura dementiae fuit > > > > > > > -----Original Message----- > > > From: Jozsef Szilagyi [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, December 06, 2001 12:18 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon > > > Windows 2000 Server > > > > > > > > > Hello ! > > > > > > I have a strange problem, with the combination of configuration on > the > > > subject. > > > When want to use permanent connection to Oracle (OCIPlogon) the > > > oracle sessions never end, and quiclky raise the 50 limit of Oracle > > > procesess. > > > > > > BUT when I use on the same machine, with the same PHP, Oracle, > > > and the same php scripts, only i change the webserver from Apache to > > > IIS 5.0, the problem dissapeared. The IIS only open a very > > > low number of > > > connection > > > and the connection time (for the second request) is much much > > > small than > > > the same thing under Apache. > > > > > > Now my question is, where is the problem ? > > > Why with IIS is ok, and with Apache not ? > > > > > > SzJ. > > > > > > > > > > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > > > [EMAIL PROTECTED] > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
