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

From: Date: Fri, 17 Sep 2004 04:42:29 +0000
Subject: #30122 [Opn->Fbk]: ORA-02396 error even though there is a call to ocilogoff
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-66326@lists.php.net to get a copy of this message 
 ID:               30122
 Updated by:       tony2001@php.net
 Reported By:      atebbe at utk dot edu
-Status:           Open
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: Suse Professional 9.1
 PHP Version:      5.0.1
 New Comment:

Try to set appropriate idle timeout first. It looks like a problem of
your (mis)configuration.


Previous Comments:
------------------------------------------------------------------------

[2004-09-16 20:03:48] atebbe at utk dot edu

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 this bug report at http://bugs.php.net/?id=30122&edit=1

Thread (9 messages)

« previous php.bugs (#66326) next »