OraFAQ Forum: General » Failure to enlist in resource Manager

Home » Other » General » Failure to enlist in resource Manager

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Failure to enlist in resource Manager [message #195999]

Tue, 03 October 2006 10:02

conormanning
Messages: 1
Registered: September 2006
Location: Ireland

Junior Member

Hi,

I am running Stress tests on my Application using Microsofts mtsStress tool. I am using 2 Clients, 2 Application Servers and one Database Server and am using Microsofts ODBC Driver.

One error which keeps occurring reads as follows:

A Database Error has occurred. Code -2147168246 [Microsoft][ODBC driver for Oracle] Failure enlisting in Resource Manager.

This error appears to be happening much more frequently on whichever Client is started last.
The error coming back from Oracle is
ORA-02042: too many distributed transactions

Any advice would be appreciated

Report message to a moderator

Re: Failure to enlist in resource Manager [message #196334 is a reply to message #195999]

Thu, 05 October 2006 01:14

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

If you are on 8.1.7 or below, increase distributed_transactions in your init.ora. If not:

02042, 00000, "too many distributed transactions"
// *Cause: the distributed transaction table was full because too many
//      distributed transactions were active.
// *Action: Run fewer transactions.  If you are sure you don't have too
//      many concurrent distributed transactions, this indicates an internal
//      error and support should be notified.  Instance shutdown/restart
//      would be a work-around.

Report message to a moderator

Previous Topic:	Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val
Next Topic:	Data Modification on Personal Orcale 7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:05:35 CST 2024