#29835 [NEW]: OCI8 module could not load in IIS
From: izhekov at ppartner dot com Operating system: Windows 2003 PHP version: 5.0.1 PHP Bug Type: OCI8 related Bug description: OCI8 module could not load in IIS Description: I've tried to install PHP on IIS 6 with Oracle module support. Everything is set correctly - the PHP installation instructions are executed, an Oracle client is installed, Oracle environments are set. The problem is that when I try to open any .php script, the web server return an error message: "Unable to load dynamic library c:\php\ext\php_oci8.dll: Access denied" The file php_oci8.dll is right there and it have property permissions set. oci.dll is located in %ORACLE_HOME%\bin\. I've tried this on three different servers and the problem is on all of them. Oracle version is 9.2.0.1.0. -- Edit bug report at http://bugs.php.net/?id=29835&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29835&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=29835&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=29835&r=trysnapshot51 Fixed in CVS:http://bugs.php.net/fix.php?id=29835&r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=29835&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29835&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29835&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29835&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29835&r=support Expected behavior: http://bugs.php.net/fix.php?id=29835&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29835&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29835&r=submittedtwice register_globals:http://bugs.php.net/fix.php?id=29835&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29835&r=php3 Daylight Savings:http://bugs.php.net/fix.php?id=29835&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29835&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29835&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29835&r=float
#29814 [NEW]: Apache server locks up when using OCI8 and sessions
From: izhekov at ppartner dot com Operating system: Windows 2003 PHP version: 5.0.1 PHP Bug Type: OCI8 related Bug description: Apache server locks up when using OCI8 and sessions Description: Here is an example: This script causes web server to not responding. When using only sessions or only OCI connection everything goes fine but when they are in combination in one script the web server locks up. -- Edit bug report at http://bugs.php.net/?id=29814&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29814&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=29814&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=29814&r=trysnapshot51 Fixed in CVS:http://bugs.php.net/fix.php?id=29814&r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=29814&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29814&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29814&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29814&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29814&r=support Expected behavior: http://bugs.php.net/fix.php?id=29814&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29814&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29814&r=submittedtwice register_globals:http://bugs.php.net/fix.php?id=29814&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29814&r=php3 Daylight Savings:http://bugs.php.net/fix.php?id=29814&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29814&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29814&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29814&r=float
#29608 [Com]: OCi reports OCIStmtExecute: ORA-24324: service handle not initialized
ID: 29608
Comment by: izhekov at ppartner dot com
Reported By: tomek at matrox dot pl
Status: Feedback
Bug Type: OCI8 related
Operating System: W2k, Red Hat
PHP Version: 5.0.0
New Comment:
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
--
Previous Comments:
[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.
[2004-08-11 17:43:31] [EMAIL PROTECTED]
>I think the OCI8 functions did not work at all in PHP 5.
you're wrong.
OCI8 functions work for most of the people.
Perhaps you're misusing them or having some problems with Oracle
client/Oracle server.
I still need more info to find out what happens and/or to reproduce
your situation. Feel free to provide this info and open the bug report
again.
--------
[2004-08-11 16:34:48] izhekov at ppartner dot com
I have the same problem. If you search in google for this error, you'll
find some sites that have the same problem. I'm using Windows 2003
Server. I think this bug is fatal for many people. I think the OCI8
functions did not work at all in PHP 5.
[2004-08-11 09:51:44] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
[2004-08-11 09:44:33] tomek at matrox dot pl
Description:
I wrote my site using PHP 4.3.8, W2k and Apache in both version 2 and
1.3.x. Everything was all right until the day when I decided to change
my php version (now I have 5.0.0)
Scripts which executes oracle queries sometimes works sometimes not.
I've notice 2 kinds of situations:
First : apache reports :
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324:
service handle not initialized in /usr/local/apache/htdocs/dupa1.php on
line 5
Second : apache child process is killed
I thought that problem is in OS. I tried to run my site on Red Hat with
apache 1.3.31 and php 5.0.0 and problem is still the same.
Changes in version of Oracle client also doesn't resolve the problem.
Reproduce code:
---
$query = 'SELECT * FROM opal_sesje';
$conn = ocilogon('xxx','xxx','xxx');
$stmt = OCIParse($conn, $query);
OCIexecute($stmt, OCI_DEFAULT);
$error = OCIError($stmt);
print_r($error);
Expected result:
just blank page
Actual result:
--
blank page or OCI warning or no result
--
Edit this bug report at http://bugs.php.net/?id=29608&edit=1
#29608 [Com]: OCi reports OCIStmtExecute: ORA-24324: service handle not initialized
ID: 29608
Comment by: izhekov at ppartner dot com
Reported By: tomek at matrox dot pl
Status: Feedback
Bug Type: OCI8 related
Operating System: W2k, Red Hat
PHP Version: 5.0.0
New Comment:
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.
Previous Comments:
[2004-08-11 17:43:31] [EMAIL PROTECTED]
>I think the OCI8 functions did not work at all in PHP 5.
you're wrong.
OCI8 functions work for most of the people.
Perhaps you're misusing them or having some problems with Oracle
client/Oracle server.
I still need more info to find out what happens and/or to reproduce
your situation. Feel free to provide this info and open the bug report
again.
----
[2004-08-11 16:34:48] izhekov at ppartner dot com
I have the same problem. If you search in google for this error, you'll
find some sites that have the same problem. I'm using Windows 2003
Server. I think this bug is fatal for many people. I think the OCI8
functions did not work at all in PHP 5.
[2004-08-11 09:51:44] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
[2004-08-11 09:44:33] tomek at matrox dot pl
Description:
I wrote my site using PHP 4.3.8, W2k and Apache in both version 2 and
1.3.x. Everything was all right until the day when I decided to change
my php version (now I have 5.0.0)
Scripts which executes oracle queries sometimes works sometimes not.
I've notice 2 kinds of situations:
First : apache reports :
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324:
service handle not initialized in /usr/local/apache/htdocs/dupa1.php on
line 5
Second : apache child process is killed
I thought that problem is in OS. I tried to run my site on Red Hat with
apache 1.3.31 and php 5.0.0 and problem is still the same.
Changes in version of Oracle client also doesn't resolve the problem.
Reproduce code:
---
$query = 'SELECT * FROM opal_sesje';
$conn = ocilogon('xxx','xxx','xxx');
$stmt = OCIParse($conn, $query);
OCIexecute($stmt, OCI_DEFAULT);
$error = OCIError($stmt);
print_r($error);
Expected result:
just blank page
Actual result:
--
blank page or OCI warning or no result
--
Edit this bug report at http://bugs.php.net/?id=29608&edit=1
#29608 [Com]: OCi reports OCIStmtExecute: ORA-24324: service handle not initialized
ID: 29608
Comment by: izhekov at ppartner dot com
Reported By: tomek at matrox dot pl
Status: Feedback
Bug Type: OCI8 related
Operating System: W2k, Red Hat
PHP Version: 5.0.0
New Comment:
I have the same problem. If you search in google for this error, you'll
find some sites that have the same problem. I'm using Windows 2003
Server. I think this bug is fatal for many people. I think the OCI8
functions did not work at all in PHP 5.
Previous Comments:
[2004-08-11 09:51:44] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
[2004-08-11 09:44:33] tomek at matrox dot pl
Description:
I wrote my site using PHP 4.3.8, W2k and Apache in both version 2 and
1.3.x. Everything was all right until the day when I decided to change
my php version (now I have 5.0.0)
Scripts which executes oracle queries sometimes works sometimes not.
I've notice 2 kinds of situations:
First : apache reports :
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324:
service handle not initialized in /usr/local/apache/htdocs/dupa1.php on
line 5
Second : apache child process is killed
I thought that problem is in OS. I tried to run my site on Red Hat with
apache 1.3.31 and php 5.0.0 and problem is still the same.
Changes in version of Oracle client also doesn't resolve the problem.
Reproduce code:
---
$query = 'SELECT * FROM opal_sesje';
$conn = ocilogon('xxx','xxx','xxx');
$stmt = OCIParse($conn, $query);
OCIexecute($stmt, OCI_DEFAULT);
$error = OCIError($stmt);
print_r($error);
Expected result:
just blank page
Actual result:
--
blank page or OCI warning or no result
--
Edit this bug report at http://bugs.php.net/?id=29608&edit=1
