topic Re: HP-UX 11i - PHP - OCI - Oracle 9R2 in Operating System - Linux

HP-UX 11i - PHP - OCI - Oracle 9R2

hantolini — Thu, 23 Nov 2006 12:51:34 GMT

Hi everyone,

I have the following instalation:

HP-UX 11i, Apache 2.0.58, PHP 5.0.4, I think is the latest hpws_apache bundle from HP. Connection to the Oracle database are being made by OCI. Oracle release is 9.2.0.6.

The problem is that PHP is not closing sessions to the database. We are not doing persistents connections, so a oci_connect is issued every time data is being needed from the database.
After some time, Oracle crash because session limit is reached.

We tried to force oci_close, but sessions still there.

Anyone go throught something similiar?...
Any ideas?... abug perhaps?

Thanks in advance.

Hugo Antolini

Re: HP-UX 11i - PHP - OCI - Oracle 9R2

Steven E. Protter — Thu, 23 Nov 2006 16:19:59 GMT

Shalom Hugo,

It does sound like a bug and poor quality control and you should report it.

Do make sure that your system is properly patched and that there is no corruption in the depot installation with swverify \*

SEP

Re: HP-UX 11i - PHP - OCI - Oracle 9R2

Yogeeraj_1 — Fri, 24 Nov 2006 08:01:07 GMT

hi Hugo!

I don't think this is an Oracle problem. Most probably a PHP problem which is building up persistent connections across time.

I recall having encountered a similar problem long time ago.

Please check on metalink about this issue.

In the meanwhile, if i find something i will update this thread.

good luck!

kind regards
yogeeraj

Re: HP-UX 11i - PHP - OCI - Oracle 9R2

Yogeeraj_1 — Sat, 25 Nov 2006 01:33:44 GMT

hi again!

This is what i found:

Bug #22674 Unexpected build-up of persistent connections

Fix
There is still no fix for the problem but there are 2 possible workarounds

WORKAROUND 1
==================
use OCINLogon instead of OCILogon

WORKAROUND 2
==================
to limit the life of the apache process modify the following parameter in file httpd.conf :
MaxRequestsPerChild 100

hope this helps!

kind regards
yogeeraj