My Oracle Support Banner

Trying to Use DBMS_PIPE in RAC Environment While Switching Instances Results in Hang Session (Doc ID 816123.1)

Last updated on JANUARY 29, 2022

Applies to:

PL/SQL - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Oracle Database version 10.2.0.4 using RAC

When trying to use DBMS_PIPE in a RAC environment with load balancing results in the session hanging when they are switching instances.

Changes

Upgraded Oracle Database to RAC environment with Load Balancing.

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
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.