ID: 30122 Updated by: [EMAIL PROTECTED] 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