DBD::Oracle 1.16 on OSX 10.3 running Oracle 10.1 (ORA 00600 error)

From: Ron Stewart (ron_at_wicell.org)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 15:59:14 -0600
To: <dbi-users@perl.org>

Hi,
   As described in the subject, I'm getting an ORA-00600 error. It is intermittent (happening about 50%) of the time and is not
dependent on having a long datatype in the table I'm selecting from. The actual error is:
        DBD::Oracle::st execute failed: ORA-00600: internal error code,
arguments: [kpofdr-long], [], [], [], [], [], [], []
which I get on doing various types of select statements.

I believe this is a bug in Oracle 10.1 (Oracle bug note 3612581.8) . The problem here is that Oracle 10 release 2 may not be released for a few months. And there is no patch from Oracle for OSX yet.

I also saw some people having success by using DBD::Oracle 1.15 in a similar situation (but they may have been running Oracle 9i). I'm guessing that DBD::Oracle 1.15 doesn't work for Oracle 10g, based on error messages I get when I try to make about being unable to determine the Oracle version (version 0.01 or something like that is what Makefile.pl guesses). Also, there are instructions to run nmedit to fix some symbol table issues, but I believe those are 9i-specific.

I've also tried bumping up my SGA as much as possible to no avail.

Any ideas? Is there some sort of work around I'm missing?

thanks,
Ron