OGG Replicat not progressing/Hung
edited Sep 3, 2013 11:01AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
Hello Expert,
One of replicat is hung state and progressing from almost two days. I tried checking for any blocking session or locks in the database, was not able to find any .
The database session is inactive state with event 'SQL*Net message from client'. ALso tried to clean up the session both db session/os process and then restart , no luck.
None of the commands expect 'info replicat_name' works . All the other process work without any issues.
Can you please help me understand the reason for this and the steps to resolve the same.
GGSCI (tp667) 1> info all
One of replicat is hung state and progressing from almost two days. I tried checking for any blocking session or locks in the database, was not able to find any .
The database session is inactive state with event 'SQL*Net message from client'. ALso tried to clean up the session both db session/os process and then restart , no luck.
None of the commands expect 'info replicat_name' works . All the other process work without any issues.
Can you please help me understand the reason for this and the steps to resolve the same.
GGSCI (tp667) 1> info all
5