My Oracle Support Banner

DTP Service Failover fails with ORA-30006 when a sql session has executed long-running DML (Doc ID 1263014.1)

Last updated on DECEMBER 10, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Unable to properly stop a DTP service when a long running sql statement which is utilising that service is being executed.

Service relocation of a DTP service fails with

k2g_dtp_stop_svc(): Error 30006 (ret -1) occured while stopping service [xa1]; some transactions might not have been completely cleaned up

when a session which is using the DTP service is performing long running sql. The DTP service is left in an unusable state and all subsequent connection attempts report the ORA-30006 error.

<Patch 9133665> which contains the fixes for <Bug 7508090> and <Bug 8565972> has been applied.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.