I need help! I can not even count the number of hours that I use to find a solution for this problem! I’m just giving up.

I have a perl program (#1) that process text files and insert the data in a DB. In this case is running in linux ubuntu and Oracle 10.g DB. I use DBD::Oracle Version 1.21 and DBI Version 1.604. Oracle Instant Client Version 10.2.0.4

As there could be thousand of text files, I have a perl program (#2) that allocate the text files based on the size in X folders and call X times perl program (#1) to process the files that where distributed in the folders.

The perl program (#2) runs well until any of the perl program instances (#1) finish. When the instance finish and get back to the program that called it, I loose the connection with the DB and I get the error

DBD::Oracle::db prepare failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCIStmtExecute/Describe)

I trace the DBI connection and I get this message,

   <- DESTROY(DBI::st=HASH(84d52b4))= undef
    <- disconnect_all= (not implemented) at DBI.pm line 716
!   <- DESTROY(DBI::db=HASH(84e2148))= undef during global destruction
!   <- DESTROY(DBI::dr=HASH(84d5590))= undef during global destruction
    !! ERROR: '3113' 'Error while trying to retrieve text for error OR
+A-03113 (DBD ERROR: OCIStmtExecute/Describe)' (err#0)
    <- prepare('Select rows_added,start_datetime,stop_datetime FROM kc
+rei_batch_job_history WHERE master_job_no = 123 AND master_job_sub_no
+ = 0')= undef at kc_tlog_monitor.pl line 1151
       ERROR: '3113' 'Error while trying to retrieve text for error OR
+A-03113 (DBD ERROR: OCIStmtExecute/Describe)' (err#0)
    <- errstr= 'Error while trying to retrieve text for error ORA-0311
+3 (DBD ERROR: OCIStmtExecute/Describe)' at kc_tlog_monitor.pl line 11
+51
       ERROR: '3113' 'Error while trying to retrieve text for error OR
+A-03113 (DBD ERROR: OCIStmtExecute/Describe)' (err#0)
    <- DESTROY(DBI::st=HASH(84d52b4))= undef
    <- disconnect_all= (not implemented) at DBI.pm line 716
    !! ERROR: '3114' 'Error while trying to retrieve text for error OR
+A-03113 (DBD ERROR: OCIStmtExecute/Describe) [err was 3113 now 3114]
Error while trying to retrieve text for error ORA-03114 (DBD ERROR: OC
+ITransRollback)' (err#1)
!   <- DESTROY(DBI::db=HASH(84e2148))= undef during global destruction
!   <- DESTROY(DBI::dr=HASH(84d5590))= undef during global destruction

[download]

I tried connecting again to the DB but still the same error. What I should do? I'm just been programming in perl for a couple of month, and I'm modifying those programs to run in Linux and Oracle. Win and Oracle using ODBC, works fine, so, it must to be something in my linux computer or DBD, but I am not sure where to look. ANY HELP is highly appreciated!

Eugenia

In reply to DBI - DBD:Oracle problem? by eugemz

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.