php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6243 OCILogon intermittently fails to connect to an oracle database server.
Submitted: 2000-08-18 13:57 UTC Modified: 2006-07-17 08:38 UTC
From: mphillip at commnav dot com Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 4.0.0 OS:
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
32 - 25 = ?
Subscribe to this entry?

 
 [2000-08-18 13:57 UTC] mphillip at commnav dot com
From both Linux 2.2.16 and Solaris 2.6 running apache 1.3.12 and php 4.0.0.   Oracle client libs on both web servers version 8.0.5.  Oracle server version 8.1.5.  Sometimes it will work with no problems for several weeks, then I get the following.  It only happens about half the time.  All servers have low workloads and the network is not all that busy.

Script:

<?
echo "Testing Oracle Connection...<br><br>\n";

putenv("ORACLE_SID=ASID");
putenv("ORACLE_HOME=/usr/local/oracle/product/8.0.5");

OCIInternalDebug(1);

$conn = OCILogon('uid','password','connstr');

echo "<br><br>Done.<br><br>\n";

?>



When it works:

Testing Oracle Connection...

OCIDebug: _oci_open_server new conn=0 dname=xxxx
OCIDebug: _oci_open_session new sess=2 user=xxxx
OCIDebug: oci_do_connect: id=3


Done.

OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci



When it doesn't work:

Testing Oracle Connection...

OCIDebug: _oci_open_server: FAILURE -> CLEANUP called
OCIDebug: START _oci_close_server: detaching conn=0 dbname=xxxx
OCIDebug: oci_do_connect: FAILURE -> CLEANUP called
OCIDebug: START _oci_conn_list_dtor: id=0
OCIDebug: END _oci_conn_list_dtor: id=0


Done.

OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-11-14 04:56 UTC] kir@php.net
Please check with the latest version of PHP.
 [2000-12-15 19:48 UTC] sniper@php.net
No feedback.
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Tue Oct 19 22:03:37 2021 UTC