Database Software

i have finished Initial Data Load from oracle to sqlserver2008

but Capture and Delivery part i have problem

this shi message

GGSCI (localhost) 19> view report pump1


***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x86, 32bit (optimized), Oracle 11g on Apr 30 2011 22:35:14

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.


Starting at 2011-06-04 11:13:55
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Tue Aug 18 15:51:54 EDT 2009, Release 2.6.18-164.el5
Node: localhost
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 4891

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************
extract pump1
USERID system, PASSWORD ********
rmthost 192.168.0.102, mgrport 7809
rmttrail ./dirdat/rl
PASSTHRU
gettruncates
TABLE ghw.TCUSTMER;
TABLE ghw.TCUSTORD;

CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.87G
CACHESIZEMAX (strict force to disk): 2.64G

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 Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"

Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.

2011-06-04 11:18:29 WARNING OGG-01223 TCP/IP error 110 (Connection timed out).


//////////////////////////////////////////////////////////////////////////////
add extract eorass,tranlog,begin now,threads 1
ADD EXTRACT pump1, EXTTRAILSOURCE ./dirdat/l1, BEGIN now,threads 1


edit params eorass
/*****
EXTRACT EORASS
USERID system, PASSWORD hxbt2011
exttrail ./dirdat/l1
TABLE ghw.TCUSTMER;
TABLE ghw.TCUSTORD;
*****/

edit params pump1

/********
extract pump1
USERID system, PASSWORD hxbt2011
rmthost 192.168.0.102, mgrport 7809
rmttrail ./dirdat/rl
PASSTHRU
gettruncates
TABLE ghw.TCUSTMER;
TABLE ghw.TCUSTORD;

*******/

add exttrail ./dirdat/l1 extract EORASS , MEGABYTES 5
ADD RMTTRAIL ./dirdat/rl, EXTRACT pump1, MEGABYTES 5

////////////////////////////////////////////////

i have try to ping this ipaddress 192.168.1.102 is ok
i alse try to telnet this ipaddress 192.168.1.102 7809 is ok
and i have disabled my firewall

whta should i do fro this

Edited by: 863589 on 2011-6-3 下午8:30