PHP 5 + Oracle 10g

tanis

I'm trying to work with PHP 5 and Oracle 10g on a Windows XP box but Apache keeps crashing. I tried to find out what's the problem and it seems that the oci8 DLL is doing something wrong causing Oracle's oraclient10.dll to crash.

This is only happening with PHP 5, while PHP 4 works fine even with Oracle 10g.
The problem is that I'm working on a project that requires PHP 5 and there's no way to have it running stable.
Has this happened to anyone before? Any idea about how to debug the problem and find a solution?

rviola

I have the same problem. Have you fixed it?

tanis

No, I've not been able to solve it and I just moved on to build a Linux development server for this application to work with.

dsginter

Anyone solve this yet?

sgornick

Hi,

Assuming we had the same problem, I found the solution to be to replace the existing c:\php\ext\php_oci8.dll with a new one from the PEAR/PECL.
http://pecl4win.php.net/ext.php/php_oci8.dll
(#7 in the list is the latest for for PHP v5.1.2, for example)

Here is the error that was showing up in my Application Event Log (Windows Server 2003) when Apache would crash:
"Reporting queued error: faulting application Apache.exe, version 2.0.55.0, faulting module OraClient10.Dll, version 10.2.0.1, fault address 0x000ab9d3."
"Reporting queued error: faulting application Apache.exe, version 2.0.55.0, faulting module ntdll.dll, version 5.2.3790.0, fault address 0x0000869f."

Although I was able to connect and query fine, the fault / Apache crash would occur whenever I issued bad SQL.

At the end of this Oracle Technical Note is comments about the "re-factored" dll:
http://www.oracle.com/technology/pub/notes/technote_php_instant.html
"The "re-factored" OCI8 extension introduces new syntax for Instant Client support. The re-factored extension was first included in PHP 5.1.2."

My (now working configuration) is:
- Windows Server 2003 (no SP installed)
- Apache 2.0.55 (w/ PHP support as an Apache Module, not CGI)
- PHP 5.1.2
- PEAR 1.4.6
- PEAR DB 1.7.6

dsginter

Yeah - I did get it to run with a different php_oci8.dll. But the system was still very unstable (requiring a periodic Oracle service restart) so I built an Ubuntu box and put Oracle, PHP and Apache on it. Now, everything is rock solid.

I just wish I had those 6 hours back.

abtris

on win32 i solved this by change from module to cgi:

this part

LoadModule php5_module "C:/Apps/Inet/Apache-Group/php/php5apache2.dll"
AddType application/x-httpd-php .php
PHPIniDir "c:\Apps\Inet\Apache-Group\Php"

i replace with

ScriptAlias /php/ "c:/apps/inet/apache-group/php/"
AddType application/x-httpd-php .php

for PHP4

#Action application/x-httpd-php "/php/php.exe"

for PHP5

Action application/x-httpd-php "/php/php-cgi.exe"

and now working.