Hi,
Did a new GG setup in the below environment.
Source - QADB - Win 2008 R2 - Oracle 11.2.0.3.0 without ASM
Target - TEST11GR2 - Win 2008 R2 - Oracle 11.2.0.3.0 with ASM
After configuring the source and target system i tired to start the extract DATA PUMP on the source system.but it went into ABENDED status.
Below is the error message from GGserr.log
-------------------------------------------------------------------------------------------------------------------------------
Check swap space. Recommended swap/extract: 128G (64bit system).
2013-10-18 16:35:59 INFO OGG-01014 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Positioning with begin time: Oct 18, 2013 4:22:43 PM, starting record time: Oct 18, 2013 4:35:38 PM at extseqno 3, extrba 1021.
2013-10-18 16:35:59 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, PUMP1.prm: EXTRACT PUMP1 started.
2013-10-18 16:36:05 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Socket buffer size set to 27985 (flush size 27985).
2013-10-18 16:36:05 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, PUMP1.prm: No recovery is required for target file D:\gg\dirdat\tr000000, at RBA 0 (file not opened).
2013-10-18 16:36:05 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, PUMP1.prm: Output file D:\gg\dirdat\tr is using format RELEASE 11.2.
2013-10-18 16:36:05 ERROR OGG-01033 Oracle GoldenGate Capture for Oracle, PUMP1.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is D:\gg\dirdat\tr000000, reply received is Could not create D:\gg\dirdat\tr000000).
2013-10-18 16:36:05 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, PUMP1.prm: PROCESS ABENDING.
-------------------------------------------------------------------------------------------------------------------------------
GGSCI (QADB) 67> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:05
EXTRACT ABENDED PUMP1 00:00:00 00:27:35
GGSCI (QADB) 68> view param ext1
extract ext1
userid gguser, password gguser
exttrail D:\gg\dirdat\tr
ddl include mapped objname NIG12.*;
table NIG12.*;
GGSCI (QADB) 69> view param pump1
EXTRACT pump1
USERID gguser, PASSWORD gguser
RMTHOST test11gr2, MGRPORT 7809
RMTTRAIL D:\gg\dirdat\tr
PASSTHRU
table NIG12.*;
------------------------------------------------------------------------------------------------------------------------------
GG installation directory location is different in source and destination.
Source - D:\gg
Target - C:\app\ops\product\gg
------------------------------------------------------------------------------------------------------------------------------
GGSCI (QADB) 70> info mgr
Manager is running (IP port QADB.7809).
Also Telnet from source to target server on port 7809 works.
------------------------------------------------------------------------------------------------------------------------------
Can someone highlight if there is any mistake in the configuration and advise ?
Thanks,
AshokKumar G