#30122 [NEW]: ORA-02396 error even though there is a call to ocilogoff

From: atebbe at utk dot edu Operating system: Suse Professional 9.1 PHP version: 5.0.1 PHP Bug Type: OCI8 related Bug description: ORA-02396 error even though there is a call to ocilogoff Description: ------------ Using Apache 2 to connect to a remote Oracle 9 database. PHP was built on an AMD64 machine with both OCI8 and ORA functions using the Oracle 9 libraries. When a PHP page is loaded , it calls ocilogon at the top, generates the page, then calls ocilogoff at the bottom. When the page sites for a while, then is refreshed, the following message is produced: Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-02396: exceeded maximum idle time, please connect again in /srv/www/htdocs/ccbioinfo/bioteams/htdocs/oracle.inc.php on line 38 Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-01012: not logged on in /srv/www/htdocs/ccbioinfo/bioteams/htdocs/oracle.inc.php on line 55 Errors: ORA-02396: exceeded maximum idle time, please connect again Resource id #9 This occurs consistently when letting the page site for a while before reloading it. -- Edit bug report at http://bugs.php.net/?id=30122&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30122&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30122&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30122&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30122&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30122&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30122&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30122&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30122&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30122&r=support Expected behavior: http://bugs.php.net/fix.php?id=30122&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30122&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30122&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30122&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30122&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30122&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30122&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30122&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30122&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30122&r=mysqlcfg