[PHP-DEV] PHP 4.0 Bug #6243 Updated: OCILogon intermittently fails to connect to an oracle database server. From: sniper <email protected>
Date: 12/15/00

ID: 6243
Updated by: sniper
Reported By: mphillip <email protected>
Old-Status: Feedback
Status: Closed
Bug Type: Oracle related
Assigned To:
Comments:

No feedback.

Previous Comments:
---------------------------------------------------------------------------

[2000-11-14 04:56:01] kir <email protected>
Please check with the latest version of PHP.

---------------------------------------------------------------------------

[2000-08-18 13:57:06] mphillip <email protected>
>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

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=6243 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>