Problem with Oracle 9.2.0.6 with security patch

jwater · Post by **jwater** » Thu 02 Jun 2005 01:35

We updated our development Oracle database to Oracle 9.2.0.6 with the security patch this morning. When I run my ASP WEb app I now get the followinf error:
Server Error in '/gts' Application.
--------------------------------------------------------------------------------

ORA-02046: distributed transaction already begun ORA-02063: preceding line from RTS_ODS
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CoreLab.Oracle.OracleException: ORA-02046: distributed transaction already begun ORA-02063: preceding line from RTS_ODS

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\GTS_WEB\MyProfile.aspx.vb Line: 61

Stack Trace:

[OracleException: ORA-02046: distributed transaction already begun
ORA-02063: preceding line from RTS_ODS
]
CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3) +767
CoreLab.Common.DbCommandBase.b(CommandBehavior A_0) +113
CoreLab.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +4
CoreLab.Oracle.OracleCommand.ExecuteReader() +7
GTS_WEB.CommonVB.Get_Work_Phone() in c:\inetpub\wwwroot\GTS_WEB\CommonVB.vb:221
GTS_WEB.MyProfile.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\GTS_WEB\MyProfile.aspx.vb:61
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

Any Ideas as to why this is happening?

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

Paul · Post by **Paul** » Wed 08 Jun 2005 06:11

We did not encountered with this problem before. OraDirect .NET does not use distributed transaction. Possibly it is a problem of Oracle server (see error description in Oracle documentation). Try to modify you query.

ORA-02046 distributed transaction already begun

Cause: This is an internal error not normally encountered. A server session received a BEGIN_TRAN remote procedure call before finishing with a previous distributed transaction.

Action: Contact Oracle Customer Support.