Skip to Main Content

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!

Extract abends after a couple of seconds from extract start

976188Dec 17 2012 — edited Dec 17 2012
So far I successfully configured the manager for both machines as well as the replicat. The problem is that whenever I start the extract the goldengate collector on the second machine would just show display, "OGG-01228 Timeot in 300 seconds" then it will stop.

On the other hand, the first machine would have the following output:


Starting at 2012-12-17 19:24:08
***********************************************************************

Operating System Version:
Microsoft Windows 7 , on x86
Version 6.1 (Build 7601: Service Pack 1)

Process id: 5332

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2012-12-17 19:24:08 INFO OGG-03035 Operating system character set identifie
d as windows-1252. Locale: en_US, LC_ALL:.
extract group
extract ext1
connection to database
userid GGATE, password ******
hostname and port for trail
rmthost 192.168.105.13, mgrport 7809
path and name for trail
rmttrail d:\goldengate\dirdat\lt
--DDL support
ddl include mapped objname sender.*;
--DML
table sender.*;

2012-12-17 19:24:08 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
D:\GoldenGate\BR\EXT1.

Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = D:\GoldenGate

2012-12-17 19:24:08 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
D:\GoldenGate\dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 1G
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1.57G
CACHESIZEMAX (strict force to disk): 1.41G

Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

Database Language and Character Set:
NLS_LANG = ".WE8MSWIN1252"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"

2012-12-17 19:24:09 WARNING OGG-01423 No valid default archive log destination
directory found for thread 1.

2012-12-17 19:24:09 INFO OGG-01513 Positioning to Sequence 4, RBA 25249296,
SCN 0.1018149.

2012-12-17 19:24:09 INFO OGG-01516 Positioned to Sequence 4, RBA 25249296,
SCN 0.1018149, Dec 14, 2012 6:38:29 PM.

2012-12-17 19:24:12 INFO OGG-01085 extract received window closed event.

-----


If this can help, this was the guide that I had been following throughout the setup

http://www.practiceoracledba.com/2011/11/oracle-goldengate-11g-installation-on.html
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2013
Added on Dec 17 2012
1 comment
573 views