#30122 [Fbk->Opn]: ORA-02396 error even though there is a call to ocilogoff
ID: 30122
User updated by: atebbe at utk dot edu
Reported By: atebbe at utk dot edu
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Suse Professional 9.1
PHP Version: 5.0.1
New Comment:
Our timeout is set to 30 for the Oracle database. I still don't
understand though why the connection is not being closed by PHP at the
end of the page. It is as though a persistent connection is opened,
even though I am not using that function within PHP. Is there any way
to force PHP to terminate this connection, so that when a page is
reloaded or a new page is viewed, it will open a new connection to
Oracle?
Previous Comments:
------------------------------------------------------------------------
[2004-09-29 08:29:39] tony2001@php.net
Could you plz tell me what's the value of the IDLE_TIME variable? You
should be able to get it with "select * from dba_profiles".
------------------------------------------------------------------------
[2004-09-29 02:23:00] atebbe at utk dot edu
This issue still has not been resolved and should remain categorized as
Open. It is my understanding that ocilogoff does not even need to be
called, and PHP should disconnect from Oracle at the end of the page,
but it does not seem to do so....
------------------------------------------------------------------------
[2004-09-28 23:18:33] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
------------------------------------------------------------------------
[2004-09-17 06:42:27] tony2001@php.net
Try to set appropriate idle timeout first. It looks like a problem of
your (mis)configuration.
------------------------------------------------------------------------
[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)