Windows Oracle Data Access Components (MOSC)

MOSC Banner

in-doubt locks observed intermitantly in dba_2pc_pending

edited Jun 25, 2018 2:20PM in Windows Oracle Data Access Components (MOSC) 7 commentsAnswered
We have a .NET 3.5 client application flowing trasactions to transactional WCF Service.

1) Both the Client and WCF service applications (with TCP binding) perform database operations with Oracle  10.2.0.4 database using ODP.NET 11.
2) Both the client and WCF Service are installed on the same machine while Oracle database is on different server. Operation system: Windows Server 2003, Sp2
3) DTC service started on machine hosting client and WCF service.

In the msdtc log it is observed that

RM_COMMIT_DELIVERY_FAILED_DUE_TO_CONNECTION_DOWN   which is causing the the transaction to go in-doubt state.

THere is no network failure. checked with netmon. What can be the possible reasons. Any pointer will be helpful. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center