GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

DBMS_CAPTURE_ADM.BUILD(); is hanging

edited Feb 17, 2010 10:14PM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered
 

Hello,

The call to DBMS_CAPTURE_ADM.BUILD normally succeeds and it takes less than a second.

Sometimes, when I run DBMS_CAPTURE_ADM.BUILD under the same login with the same privileges on the same oracle server, it hanging and not returning anything. The session stays active with running this procedure.  

There is no other sessions of mine opened at this time. There is nothing from my activity that terminated abnormally before starting this supplied procedure.

The situation happening unexpectedly and goes away in few hours by itself (from what I see as developer). It happened twice already for the last week.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center