Re: status 3221225477 restarts apache on win 2003 with php and oracle

On Jan 22, 3:05 pm, jzs <jayzee.sm..._at_gmail.com> wrote:
> SOFTWARE
> * windows 2003 sp2
> * apache 2.0.55 (win32)
> * php 5.1.2 (oci8 support enabled with "c:\oracle\product
> \10.2.0\client_1\bin" listed under apache environment, environment and
> php variables. path "c:\oracle\product\10.2.0\client_1\BIN" exists on
> machine)
>
> BACKGROUND
> when i try to connect to an oracle 10g database on another machine
> like so (
> $connection = oci_new_connect('username', 'password', 'php.net');
> ), my attempt is successful.
>
> PROBLEM
> however when i attempt to prepare an oracle statement for execution
> like so (
> $sql = oci_parse($connection, 'SELECT * FROM database WHERE column_id
> = 1');
> ), i get the following error:
> [notice] Parent: child process exited with status 3221225477 --
> Restarting
> this causes apache to stop!!! checkhttp://us.php.net/manual/en/function.oci-parse.php
> for more info.
>
> SOLUTION
> this is where you guys come in ;). google points to possible memory
> overflow :(.
> jzs

Welcome to Apache on MS Windows 32 bit hell. Have you checked out the Apache Lounge site yet? Why are you still running the Apache 2.0.x release? Can you consider upgrading to an Apache 2.2.x release instead? Have you applied the 10.2.0.3 patchset to the Oracle 10g R2 client?

Perhaps Mladen can provide some assistance on the PHP OCI call?

-bdbafh Received on Tue Jan 22 2008 - 14:43:03 CST