Re: MSDTC and Oracle problem (ORA-00161)
From: Angel Saenz-Badillos[MS] (angelsa_at_online.microsoft.com)
Date: 04/30/04
- Next message: sburns: "Re: Reset to Null a parameter in an SQLCommand"
- Previous message: achobbs: "ADO.NET Not Returning Error"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 10:44:08 -0700
I was afraid that you were going to say something around those lines, I have
been sending out emails myself trying to understand DTC setup, domain
controllers and Service Pack 1 security features. I would like to encourage
you to post this same question in a distributed transaction newsgroup and in
Oracles forums (we are using Oracles DTC implementation).
As far as setup issues:
If your server is Windows 2003 Server:
Make sure that you have "Enable network COM+ access" and "Enable network DTC
access" installed from:
start->contol panle->add or remove programs->add remove windows components->
application server->
If your server is Windows XP contact PSS for QXP6.
If your server is Windows 2000 make sure you have the latest service pack.
On both the server and the client:
Make sure that Component Services is properly set up:
start->administrative tools->component services.
Component Services->Computers.
right click on my computer, properties. MSDTC tab
Make sure that msdtc is started and properly set up. Then click on Security
Configuration and make sure everything is checked.
Last question, are both client and server on the same domain? If not
definitely ask for help on the Distributed transaction newsgroups, and let
me know what you find because I think that is the problem I am currently
running into <g>
Thanks,
-- Angel Saenz-Badillos [MS] Managed Providers This posting is provided "AS IS", with no warranties, and confers no rights.Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Uros" <anonymous@discussions.microsoft.com> wrote in message news:138755D8-5598-4334-86A9-DE8546A35E1C@microsoft.com... > No, Oracle is the only RM that is involved in the transaction > and it is only enlisted once. > > We assumed that either configuration of Oracle or > Windows server is causing the problem and performed > some tests to confirm this. > > We were able to run the transactions from our development > Windows machine connecting to development or test database. > Same test suite but run on test server failed when connecting > to development or test database. > > We are now investigating the configuration of the Windows server in > test environment. > > ----- Angel Saenz-Badillos[MS] wrote: ----- > > Hmm are you trying to enlist more than 64 RMs in the same transaction? > > -- > Angel Saenz-Badillos [MS] Managed Providers > This posting is provided "AS IS", with no warranties, and confers no > rights.Please do not send email directly to this alias. > This alias is for newsgroup purposes only. > > > "Uros" <uros.novak@amis.net> wrote in message > news:A939C4FD-5063-4B3E-AEE4-B0386D8072CD@microsoft.com... > > Hi, > >> I am trying to resolve a particular problem and I have found no resources > related to this issue on the web. > >> We are having problems with serviced components that require transactions. > The problem seems to be > > between MS DTC and Oracle Services for MTS as we are gettin back the > following error message: > >> 2004-04-28 09:41:56,390 [2072] ERROR DataAccess - Oracle exception > (ORA-00161: transaction branch length 72 is illegal (maximum allowed 64)). > > Exception: System.Data.OracleClient.OracleException > > Message: ORA-00161: transaction branch length 72 is illegal (maximum > allowed 64) > > Source: System.Data.OracleClient > > at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, > Boolean& isInTransaction) > > at > System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(Str > ing encryptedConnectionString, OracleConnectionString options, > OracleConnection owningObject, Boolean& isInTransaction) > > at > System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionStrin > g parsedConnectionString, Object transact) > > at System.Data.OracleClient.OracleConnection.Open() > > at Vodafone.Eirrm.DataAccess.OracleBaseObject.ExecuteNonQuery(String > storedProcedure, OracleParameter[] parameters) > >> The system is running on Windows 2000 Advanced Server with SP3 > > * .NET Framework 1.1 > > * Oracle 9i Client version 9.2.0.1.0 > > * Oracle9i 9.2.0.1.1 Patch for Oracle Service for MTS on Windows NT, > Windows 2000, and Windows XP > > * Oracle Data Adaptor for .NET 9.2.020 > >> Any help, hint and information will be appreciated. > >> Many thanks, > > Uros > >
- Next message: sburns: "Re: Reset to Null a parameter in an SQLCommand"
- Previous message: achobbs: "ADO.NET Not Returning Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
