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

[hantolini]

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

[Steven E. Protter]

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

[Yogeeraj_1]

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

[Yogeeraj_1]

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