ID: 29608
Comment by: marcus dot schuelke at juj dot de
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:
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..
Previous Comments:
------------------------------------------------------------------------
[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 !
------------------------------------------------------------------------
[2004-08-19 01:00:08] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2004-08-12 11:02:53] izhekov at ppartner dot com
I've tried to reproduce this problem.
I've installed 2 apache services on different ports 80 and 81 - first
of them using PHP5 and the other using PHP4 then I restarted the
system.
When first I access my scripts using PHP5 on port 80 everythings goes
fine.
Running scripts afterthat with PHP4 on port 81 also worked fine.
When I tried to access again scripts on apache service running on 80
port, errors occured again:
---------
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324:
service handle not initialized in
C:\SERVER\HTTPD\htdocs\service\db_modul.php on line 21
Warning: ocifetch() [function.ocifetch]: OCIFetch: ORA-24338: statement
handle not executed in C:\SERVER\HTTPD\htdocs\service\db_modul.php on
line 27
----------
------------------------------------------------------------------------
[2004-08-12 10:09:03] izhekov at ppartner dot com
I migrate from PHP 4 to PHP 5 on my Windows 2003 server. Everything
goes fine, but when I try to use an PHP application that uses Oracle
database I receive the error mentioned above. I restarted the Oracle
server but that not helped me. Other applications and PHP 4 works fine
with my Oracle server, but PHP 5 did not.
Last night the power supply goes down unexpectally and both Oracle
server and web server was restarted. Now everything seems to be fine,
but I'm sure the problem exists and many people will have the same
problems also.
Searching in Google for:
http://www.google.com/search?hl=bg&ie=UTF-8&q=%22service+handle+not+initialized+in%22+%2Bwarning&lr=
shows many sites with the same problem.
------------------------------------------------------------------------
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
