Hi,
I am new to GoldenGate and I am trying to evaluate GG, I am trying to use GoldenGate for Flat Files.
I was able to generate a trail file from a 1 row table, on the same DB but different installation ggs_src
and I placed this file on the target GG ggs_trg dirdat folder manually "cp /oracle/u04/ggs_src/dirdat/bb000000 /oracle/u04/ggs_trg/dirdat".
However when I start my FF extract I do not see any FF files under dirout (default output location)..
Here is what I did:
EXTRACT SRCONV
SOURCEDEFS ./dirdef/t1pg.def
CUSEREXIT ./flatfilewriter.so CUSEREXIT PASSTHRU includeupdatebefores, params "./ffwriter.properties"
TABLE T1.*;
ggsci> ADD EXTRACT srconv, EXTTRAILSOURCE ./dirdat/bb
ggsci> start srconv
and here is the SRCONV.rpt
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:32:12
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-10-02 00:25:53
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Aug 18 15:51:48 EDT 2009, Release 2.6.18-164.el5
Node: romania
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 29751
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2013-10-02 00:25:53 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
EXTRACT SRCONV
SOURCEDEFS ./dirdef/t1pg.def
CUSEREXIT ./flatfilewriter.so CUSEREXIT PASSTHRU includeupdatebefores, params "./ffwriter.properties"
2013-10-02 00:25:53 INFO OGG-04523 /oracle/u04/ggs_trg/extract running with user exit library ./flatfilewriter.so, compatiblity level (3) is not current, using compatiblity level (2).
2013-10-02 00:25:53 INFO OGG-04526 /oracle/u04/ggs_trg/extract running with user exit library ./flatfilewriter.so. Current session character set is operating system default character set.
TABLE T1.*;
2013-10-02 00:25:53 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/oracle/u04/ggs_trg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
****************************************
Started Oracle GoldenGate for Flat File
Version 3.0.1.5
****************************************
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file ./dirdat/bb000000 at 2013-10-02 00:25:53
++++
I do NOT see any thing in the dirout file, NO FILES generated while I see that gg did see the trailfile ./dirdat/bb000000.
Any idea why?
Thanks in Advance
Alaa