This discussion is archived
6 Replies Latest reply: Jul 3, 2013 3:02 AM by yxes2013 RSS

How to adjust timeout in INITIAL EXTRACT LOAD?

yxes2013 Newbie
Currently Being Moderated

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  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: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: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.).

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.).

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.).

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points