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

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

Date: Fri, 24 Sep 2004 09:35:37 +0100
To: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>, <dbi-users@perl.org>

Hi Ron,

> -----Original Message-----
> From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
> Sent: 23 September 2004 15:16
> To: Tristan Greaves; dbi-users@perl.org
> Cc: Tim Bunce
> Subject: RE: DBD::Oracle and ORA-600 [16365] errors
>
> This is a known bug with MTS. It is not anything to do with
> DDB::Oracle. If you take all of the SQL statements in your
> program(s) and execute them in the same manner as an on-line
> app would execute them, you would most likely encounter the
> same problem.

Thanks, it is nice to have some independent verification of the
problem, even if Oracle are pointing the finger everywhere except at
themselves!

> As for not using MTS, you could most likely persuade your DBA
> to give you a TNS address which makes a dedicated connection.

Our application typically runs 200+ simultaneous connections to the
database (via the wonders of mod_perl and the load on the web servers).
Then there are various batch scripts, TOAD users etc.

Basically, the database would run out of servers and fail, and there was
only so far we could "up" the number of servers before we ran out of
memory. And the box is pretty beefy!

So, MTS was the ideal solution, apart from this crash issue :-/

Tris.

Relevant Pages

  • Re: Return Code from Win32_Processs Create method
    ... > servers, so I can't use Win32_ProcessStopTrace class, as mentioned in ... > Dim objWMIService, intProcessID, intReturnCode ... > ' /* WMI Binding okay, so now execute the process ... > Wscript.Echo "WMI Binding Error: Process execution could not occurs due to ...
    (microsoft.public.scripting.vbscript)
  • Re: Execute permission denied on object xp_SQLagent_notify
    ... On my server the xp_sqlagent* stored procedures are granted execute to ... The account is public in master and db_owner in msdb. ... same settings on 10 servers. ... EXECUTE permission denied on object 'xp_sqlagent_is_starting', ...
    (microsoft.public.sqlserver.security)
  • Could corrupt data cause Error #7643 ("Too many results") ??
    ... I'm trying to execute this search on a table containing approx 80K records ... versions of SQL & OS and do not get the error on them. ... the Noise Word files for all of these servers are empty. ...
    (microsoft.public.sqlserver.fulltext)
  • Dont Understand login script location..
    ... created a login script under the "Default domain policy" OU, ... the servers, but how do you get it to execute on w98 systems, the following ...
    (microsoft.public.windows.server.scripting)