ID: 29608 Comment by: phandangthai at yahoo dot com Reported By: tomek at matrox dot pl Status: No Feedback Bug Type: OCI8 related Operating System: W2k, Red Hat PHP Version: 5.0.0 New Comment:
When I use Windows server 2003, Standard Edition, Oci8 worked, but when I use the Enterprise version, I have the same problem, even if I use the latest stable php 5.1.2. But when I use the latest snap shot at http://snaps.php.net/win32/php5.1-win32-200603140730.zip (I'm not sure, it works currently, because, that changes frequenly, but you should download the last version from snap shot page). And Oci8 works fine Previous Comments: ------------------------------------------------------------------------ [2004-12-14 16:26:05] niall at mcphillips dot net PHP5.0.2 / Apache 1.3.33 / Oracle 9.2.0.5 / RHES 3.0 Both oci_connect and ocilogin fail with: Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324: service handle not initialized in /www/htdocs/oratest.php on line 8 oci_new_connect works but appears to force a new connection each time (overhead?). Is this a bug? ------------------------------------------------------------------------ [2004-09-09 15:10:42] artmotion at nurfuerspam dot de oci_new_connect did the job! One of those things that must be documented much better and brought to the developer's attention. ------------------------------------------------------------------------ [2004-09-01 10:40:18] marcus dot schuelke at juj dot de This Bug is caused by PHP 5 to fix the problem use oci_new_connect ( username,password, db) instead of ocilogon(); hope that will fix your problem.. ------------------------------------------------------------------------ [2004-09-01 02:51:44] cnichols at nmu dot edu Same problem over here. Running PHP 5.0.1 with Apache2 and Oracle 10g. I found a site saying that errmsg has to do with a soon-to-expire password, but I doubt that's the case for all of you :) ------------------------------------------------------------------------ [2004-08-30 10:21:46] symedeot at yahoo dot fr I have exactly the same problem ! If works sometimes, sometime not. If you ask the same page again, it should work or not... Warning: oci_execute() [function.oci-execute]: OCIStmtExecute: ORA-24324: descripteur de service non initialisé in ... Warning: ocifetch() [function.ocifetch]: OCIFetch: ORA-24338: descripteur d'instruction non exécuté in... Just try to access Oracle like this : $conn = OCILogon("GPE", "gpe","PLSE"); $stmt = OCIParse($conn,$myrequest); OCI_Execute($stmt,OCI_DEFAULT); while ( OCIFetch($stmt) ) { } OCIFreeStatement($stmt); OCILogoff($conn); Oracle 9.i under RedHat 9, php 5.00 and 5.01(same), any Apache 2 version. Everything fine on same server when using PHP 4.3x It is clearly a bug ! And we are quite a lot to report it ! ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/29608 -- Edit this bug report at http://bugs.php.net/?id=29608&edit=1
