#30127 [NEW]: lost oracle connection. need restart apache.

From: andreys at uniqinfo dot ru Operating system: Windows 2000 SP4 PHP version: 5.0.1 PHP Bug Type: OCI8 related Bug description: lost oracle connection. need restart apache. Description: ------------ Periodically, there is a mistake at which it is impossible to establish connection with Oracle. [client 192.168.111.99] PHP Warning: oci_new_connect() [<a href='function.oci-new-connect'>functi on.oci-new-connect</a>]: OCISessionBegin: ORA-24327: need explicit attach before authenticating a user\n in D:\\Apache\\htdocs\\D.php on line 7 After restart Apache the problem for a while disappears. Reproduce code: --------------- <?php $id = $_GET['s']; $user_agent = $_SERVER['HTTP_USER_AGENT']; $dbcon = oci_new_connect('XXXXX', 'XXXXXX', 'XXX'); if (!$dbcon) { error_log('Oracle database not available!'); exit; } -- Edit bug report at http://bugs.php.net/?id=30127&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30127&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30127&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30127&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30127&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30127&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30127&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30127&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30127&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30127&r=support Expected behavior: http://bugs.php.net/fix.php?id=30127&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30127&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30127&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30127&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30127&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30127&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30127&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30127&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30127&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30127&r=mysqlcfg