RE: DBD::Oracle and ORA-600 [16365] errors

From: Tristan Greaves (tristan.greaves_at_jobsite.co.uk)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 11:48:26 +0100
To: <dbi-users@perl.org>

Hi again,

I have a small update on the above issue which we were experiencing upon
occasion.

Firstly, our versions of DBD::Oracle are quite old and I am recommending to
our operations team that they are upgraded as soon as feasible.
(Oldest on one server is v1.03 !)

Secondly, Oracle say they have had other reports of the ORA-600 [16365] error
which were rectified by disabling MTS. Our DBA informs me that this isn't
an option on our current configuration (I'll have to find out the specific
reasons).

We aren't doing anything clever with DBD::Oracle -- Oracle say we are
tripping the error by our applications sending new requests before reading
existing data (as per Metalink), but we are using DBI and DBD::Oracle
"straight".

This error occurs about once per week, and there is no real pattern. It
requires an Oracle restart when it happens though, which is a pain!

What could the link be between MTS, DBD::Oracle and this error?

Thanks,

Tris.