php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #41637 Fast connects cause tests to fail
Submitted: 2007-06-08 17:12 UTC Modified: 2007-06-11 20:21 UTC
From: david at acz dot org Assigned: sixd (profile)
Status: Not a bug Package: OCI8 related
PHP Version: 5.2.3 OS: SuSE Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2007-06-08 17:12 UTC] david at acz dot org 
Description:
------------
Connecting quickly to Oracle can cause ORA-12516 (TNS:listener could not find available handler with matching protocol stack).  This happens for me when running the tests against Oracle XE.

Sleeping for 0.25 seconds before connecting fixes it.

--- ext/oci8/tests/connect.inc  12 Dec 2006 13:00:01 -0000
+++ ext/oci8/tests/connect.inc  8 Jun 2007 17:06:26 -0000
@@ -15,2 +15,3 @@

+    usleep(250000);
     if (!empty($dbase)) {

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-06-11 20:21 UTC] sixd@php.net 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php


This is discussed in the most recent Underground PHP & Oracle Manual in the section "Configuring the Database for Testing" (page 175 of release 1.4 of the PDF).  The better solution is to configure the database to handle the load by increasing the value of Oracle's init.ora parameter called "processes".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun May 05 15:01:33 2024 UTC