We help IT Professionals succeed at work.

DBI & ORA-03113

mweagle
mweagle asked
on
Medium Priority
406 Views
Last Modified: 2012-06-21
Here's the Setup:
Perl 5.6.1
mod_perl
DBI
Oracle 8.1.7.2.0
Solaris 2.7

Here's the problem:
I've seemingly finally gotten my scripts to mod_perl and am attempting to keep open a $dbh to share and improve performance.  This is done using the guidelines laid out in http://perl.apache.org/guide/performance.html#Eliminating_SQL_Statement_Parsin.  I am not using the Apache::DBI module.  AFAIK, the code in the URL above instructs me to keep a global $dbh in a package, and when I try to connect, first ping the dbh to see if it's still valid.  If so, return that instance.  If not, try to reconnect.

When I run this code from the shell, everything is fine.  The DB is accessed without problems.  However, when I invoke this via an HTTP request, I receive the following:

ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute/Describe)

I've tried to set all environmental variables I can think of in the CGI itself, but to no avail.  Can someone _please_ tell me what else I could look at to track this down?  I've Google'd the error and it seems to be a catchall kind of thing.  All advice greatly appreciated. I would give more points if possible :)  

Comment
Watch Question

Freelance cloud developer
Commented:
try searching for "end-of-file on communication channel" in www.oracle.com
Commented:
Looks like Oracle backend process has fall into core dump. You may want to look into $ORACLE_HOME/admin/$SID/[bcu]core/* files and
look for cause of fail.

Commented:
Hi there,

I ran into this problem last week and found that a bug with Oracle was to blame.  My post to my fix can be found at the following URL.  Hope it helps:

http://faqchest.dynhost.com/prgm/dbi-l/dbi-02/dbi-0201/dbi-020106/dbi02011015_22223.html

Cheers,
Bonger (Darryl)
jmcgOwner
CERTIFIED EXPERT

Commented:
Nothing has happened on this question in over 12 months.

I will leave a recommendation in the Cleanup topic area that
the points be split between chris18 and Sapa (150:150).

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.