#6243 [Csd->NoF]: OCILogon intermittently fails to connect to an oracle database server.

ID: 6243 Updated by: tony2001@php.net Reported By: mphillip at commnav dot com -Status: Closed +Status: No Feedback -Bug Type: Oracle related +Bug Type: OCI8 related PHP Version: 4.0.0 Previous Comments: ------------------------------------------------------------------------ [2000-12-15 19:48:35] sniper@php.net No feedback. ------------------------------------------------------------------------ [2000-11-14 04:56:01] kir@php.net Please check with the latest version of PHP. ------------------------------------------------------------------------ [2000-08-18 13:57:06] 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=6243&edit=1