#30127 [Fbk->Opn]: lost oracle connection. need restart apache.
| From: | andreys at uniqinfo dot ru | Date: | Fri, 17 Sep 2004 14:17:49 +0000 |
| Subject: | #30127 [Fbk->Opn]: lost oracle connection. need restart apache. | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-66348@lists.php.net to get a copy of this message | ||
ID: 30127
User updated by: andreys at uniqinfo dot ru
Reported By: andreys at uniqinfo dot ru
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Windows 2000 SP4
PHP Version: 5.0.1
New Comment:
It not an output. We use Apache 2.X because at us dual-processor
system. Apache 2.X just for this purpose it is intended.
Work through the CLI interface in console will considerably reduce
productivity of a server.
Previous Comments:
------------------------------------------------------------------------
[2004-09-17 10:46:06] tony2001@php.net
Please, try with Apache 1.3.x first (or using PHP CLI interface in
console).
------------------------------------------------------------------------
[2004-09-17 10:32:34] andreys at uniqinfo dot ru
Oracle Server EE with client 8.1.7.4
Apache 2.0.50
Windows 2000 Pro SP4
------------------------------------------------------------------------
[2004-09-17 10:24:36] tony2001@php.net
What's your Oracle, Apache, Oracle Client version?
What OS do you use?
------------------------------------------------------------------------
[2004-09-17 09:37:04] andreys at uniqinfo dot ru
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 this bug report at http://bugs.php.net/?id=30127&edit=1