From: robertg2 at hope dot ac dot uk Operating system: Solaris 8 PHP version: 5.0.1 PHP Bug Type: OCI8 related Bug description: ORA-24327
Description: ------------ We've recently upgraded to PHP 5.0.0 (and subsequently PHP 5.0.1) and have begun to experience a major issue with the OCI8 connection functions. The database that the web form integrates with goes offline for a while every night and immediately afterwards users receive the following error message - that is, until apache has restarted: Warning: ocinlogon() [function.ocinlogon]: OCISessionBegin: ORA-24327: need explicit attach before authenticating a user I've tried using oci_new_connect, ociconnect and ocinconnect. I've tried specifying the whole of the relevant section of tnsnames.ora as an argument to ocinlogon() as suggested somewhere else - although this DOES work, it does not solve the problem. We are running Oracle 9.2 client and database with PHP on Solaris 8 64bit and this is a LIVE SITE!! :( Reproduce code: --------------- I suggest: - Connect to an oracle database using PHP oci8 functions from within Apache - Knock that database offline - Attempt to connect again using PHP oci8 functions within same instance of apache - Put the database back online - Again, attempt to connect to Oracle database from within apache using OCI8 functions Expected result: ---------------- The following Oracle error should occur on a successful reproduction of the problem: ORA-24327: need explicit attach before authenticating a user -- Edit bug report at http://bugs.php.net/?id=29779&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29779&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29779&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29779&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29779&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29779&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29779&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29779&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29779&r=support Expected behavior: http://bugs.php.net/fix.php?id=29779&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29779&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29779&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29779&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29779&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29779&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29779&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29779&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29779&r=float