GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

unable to register integrated extract

edited Mar 29, 2018 1:33PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered

Our GoldenGate databases are out of sync because some archived logs got deleted. So I re-set up the GoldenGate again.

Here is what I did:

stop extract ext1

detete extract ext1

unregister extract ext1 database

then when I try to

register extract ext1 database


it hangs for a very long time, and finally it gave the error message:

ERROR   OGG-08221  Cannot register or unregister EXTRACT EASEXT because of the following SQL error: OCI Error 4021.

I checked the process, it waits for 'library cache lock'

I check further with this query:

select

     distinct

       ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,KSUSEMNM module,

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