GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Capture process starts but aborts almost immediately with ORA-00604

edited Apr 11, 2011 8:21AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Hi,

I've used the Grid Control (11.1.0.10) Streams Wizard to generate a simple Propagation, Capture and Apply between two 10g databases (10.2.0.4 running on AIX5.3). I am replicating six tables from a single schema.

However, the Capture process starts but aborts almost immediately with ORA-00604:-

ORA-00604: error occurred at recursive SQL level 1 ORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1799 ORA-06512: at line 1

I tried rebuilding the Streams environment, including the strmadmin streams administrator, but I still get the same error.

Has anyone got any ideas?

Thanks,

Chris

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