GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to adjust timeout in INITIAL EXTRACT LOAD?

yxes2013Jun 22 2013 — edited Jul 3 2013

Hi all

GG 11.2 SQLserver2008

I am extracting a big single table like 20G size., but It seems i hit the timeout limit? Or other resource limit? Or I am not sure though.

Below is my error:

2013-06-22 15:43:36 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error 0 (The operation completed successfully.) getting position in d:\GGora\dirdat\ex.

2013-06-22 15:43:36 INFO OGG-01085 Oracle GoldenGate Collector for Oracle: server received window closed event.

2013-06-22 15:43:36 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error 0 (The operation completed successfully.) getting position in d:\GGora\dirdat\ex.

2013-06-22 15:59:38 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, MGR.prm: Command received from EXTRACT on host DTC-PC.domain (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).

2013-06-22 15:59:39 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).

2013-06-22 15:59:39 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, MGR.prm: Command received from SERVER on host DTCKalayaan-PC (REPORT 1280 7819).

2013-06-22 15:59:39 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, MGR.prm: Manager started collector process (Port 7819).

2013-06-22 15:59:39 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.

2013-06-22 15:59:44 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to DTC-PC.domain:56507.

2013-06-22 15:59:44 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening d:\GGora\dirdat\ex (byte 0, current EOF 0).

2013-06-22 16:06:33 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error 0 (The operation completed successfully.) getting position in d:\GGora\dirdat\ex.

2013-06-22 16:12:08 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error 0 (The operation completed successfully.) getting position in d:\GGora\dirdat\ex.

2013-06-22 16:12:08 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error 87 (The parameter is incorrect.) getting position in d:\GGora\dirdat\ex.

2013-06-22 16:12:08 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error getting file position for d:\GGora\dirdat\ex (87,The parameter is incorrect.).

2013-06-22 16:12:09 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Error getting file position for d:\GGora\dirdat\ex (87,The parameter is incorrect.).

Where do I put the timeout limit?

Thanks,

zxy

This post has been answered by stevencallan on Jul 2 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2013

Added on Jun 22 2013

#goldengate

6 comments

1,324 views