|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #59896 Apache craches
Submitted: 2011-08-18 05:23 UTC Modified: 2011-08-22 18:46 UTC
From: Assigned:
Status: Not a bug Package: oci8 (PECL)
PHP Version: 5.2.9 OS: Linux SUSE10 SP3
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
New email:
PHP Version: OS:


 [2011-08-18 05:23 UTC]

I'm reporting this bug not to get a fix but more to let other people know about the issue and the workaround.

I used PHP 5.2.9/oci8 1.3.5 (not possible to set an earlier version :() with $ORACLE_HOME to 10g client's libraries.
After the database upgrade from 10g to 11gR2, it worked fine until a crash append (core dump with apache). The matter was a new 11g functionality: password expiration!

As soon as I mentioned the new $ORACLE_HOME to 11gR2 client's library, I get this PHP Warning error:

Warning: oci_connect() [function.oci-connect]: OCI_SUCCESS_WITH_INFO: ORA-28002: the password will expire within 6 days

BTW, thx for this extension that works pretty well. (even if I don't know why DRCP doesn't work with RAC... surely an Oracle issue more than this driver !)


Reproduce code:
$co = oci_connect('user', 'pwd', 'db');

Expected result:
// with 11g $ORACLE_HOME
Warning: oci_connect() [function.oci-connect]: OCI_SUCCESS_WITH_INFO: ORA-28002: the password will expire within 6 days

Actual result:
// with 10g $ORACLE_HOME => ORA-28002 is not supported => httpd goes into a core dump


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2011-08-22 18:46 UTC] christopher dot jones at oracle dot com
Thanks for taking the time to document this.

Also see
 [2011-11-24 15:16 UTC] asimileac at gmail dot com
Hello, I too had this problem. But I didn't see any info in php logs, I only had application crashes of Apache server. I too was using an account with password that will expire. I was expecting some warning or an error, but only crashes. I was using version 1.4.1 of php_oci8.dll

My config:
Windows 2003 with SP2
Apache 2.2.11
PHP 5.2.9 + some extensions

I resolved problem with this steps:
1. Downloaded zip package of the php 5.2.9 TS -
2. Extracted and copied php_oci8.dll to my php extension dir.
3. Followed instructions from here for setting Common Oracle Environment Variables - added to my Environment variables LD_LIBRARY_PATH and TNS_ADMIN.
4. Restarted Apache. Called oci_connect. Everything is working. And now I see in php log info about that user defined in oci_connect has password that will expire within XX days.
 [2011-11-24 15:23 UTC] asimileac at gmail dot com
Sorry, I forgot to write version of Oracle - I'm working with Oracle 10g2 and Oracle client has version 10g2
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Wed Sep 28 06:05:53 2022 UTC