Extract abends after a couple of seconds from extract start
976188Dec 17 2012 — edited Dec 17 2012So 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