Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I deployed Oracle GoldenGate to integrate many-to-one databases. After initial loading everything works fine. Until recently, some of the replicat seem to stuck and do not proceed to change synchronizing.

The number of trial files keep incrementing, e.g up to 85, but as I run info replicat, it shows

Lag 00:00:00 
Time Since Chkpt 04:17:56
Log Read Checkpoint File ./dirdat/t0000062.

I tried to stop the very replicat with stop command, it failed. I tried kill the replicat and re-started it, also the same issue. have anyone run into the same situation and go through it?

PS: When I issue the info all command, every replicat show its status is runing


After half day analysis, I focused the issue on database, the update statement is stuck, it might be caused by deadlock. The bad news is even the statement is generated by GG, the statement is executed by sql server, which part can I put my tuning in?

share

migration rejected from stackoverflow.com Mar 24 at 16:44

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, Phil, Erik, swasheck, ypercubeᵀᴹ Mar 24 at 16:44

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
It is not very clear what your configuration is. Oracle or SQL Server as Source? Oracle or SQL Server as Target? Have you viewed the logs for the GG process that is causing the issue? For the target database have you confirmed it is a deadlock? – David Mann Mar 27 '12 at 16:24