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)
  • 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)
  • EVENT ID:1000, SOURCE: USERINIT ERROR
    ... the MSKB site. ... "could not execute the following script ... Also my logon.bat script works just fine with my ... servers and PC's, but on every PC and server I get that error msg. ...
    (microsoft.public.win2000.general)
  • Run Logon Script on Workstations Only
    ... I am creating a script that I want to run at logon in a Windows NT ... but want it to execute on Windows 2000 or XP Professional ... Workstations only, not on Servers. ...
    (microsoft.public.scripting.vbscript)