I keep getting this error:
ORA-03113: end-of-file on communication channel
It happens about 90% of the time. The other 10% of the time, the connection seems really slow.

Here's my code reduced to the essential elements:

$connection = ocilogon("webphone", "mypass", "phonebook") or die("Could not logon");

$SQL = "SELECT distinct DEPARTMENT FROM phone_info";
$stmt = ociparse($connection, $SQL);
ociexecute($stmt, OCI_DEFAULT); 
while (OCIFetchInto($stmt, $row, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo  $row["DEPARTMENT"] . "<BR>";

}


ocilogoff($connection);

This is with Apache2, PHP4, Oracle 10g. All of that is on an RHEL3 box.

My production script actually has a couple of queries. After this query fails the rest of the queries give this error:

Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in

and the script finally ends with:

Warning: Unknown: failed to rollback outstanding transactions!: ORA-03114: not connected to ORACLE in Unknown on line 0

I've tried using oci_new_connect instead of ocilogon, but only partly works. This specific query will work fine, but it only postpones the error message to the 2nd query.

I've checked the error logs for apache, it doesn't say anything more than what PHP puts out on the screen. The log on Oracle doesn't seem to show any problems. Can anyone help me??

    Sounds like your oracle connection is dying on you. Do you have access to the Oracle logs on the other end? I had a similar problem, and my oracle sys admin was able to fix the problem. No clue what he did, by the way...

      The DBA claims it is not a problem on Oracle. :glare:

        So, has he actually checked his log files, or is he just being recalcitrant?

        Seriously, this sounds like a problem on the database end. Are you getting any system level error messages of processes being killed etc???

          Sxooter wrote:

          So, has he actually checked his log files, or is he just being recalcitrant?

          Sometimes I wonder if he even knows where the log files are. Of course there are other times when he seems brilliant.

            Write a Reply...