EXTRACT load
USERID gg, PASSWORD gg
RMTHOST 192.168.10.129, MGRPORT 7809
RMTTASK REPLICAT, GROUP tgload
TABLE GG.TCUSTMER;
TABLE GG.TCUSTORD;


REPLICAT tgload
TARGETDB TD14, USERID GG, PASSWORD GG
DISCARDFILE ./dirrpt/tgload.DSC, PURGE
SOURCEDEFS ./dirdef/source.def
MAP GG.TCUSTMER, TARGET GGDB.TCUSTMER;
MAP GG.TCUSTORD, TARGET GGDB.TCUSTORD;



odbc.ini:

[ODBC]
InstallDir=/opt/teradata/client/14.00/odbc_64
Trace=0
TraceDll=/opt/teradata/client/14.00/odbc_64/lib/odbctrac.so
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
 
[ODBC Data Sources]
default=tdata.so
TD14=tdata.so
 
[TD14]
Driver=/opt/teradata/client/14.00/odbc_64/lib/tdata.so
Description=Teradata running Teradata 14
DBCName=192.168.10.129
SessionMode=Teradata
CharacterSet=UTF8
DateTimeFormat=AAA
LastUser=
Username=gg
Password=gg
Database=ggdb
DefaultDatabase=ggdb
RunInQuietMode=YES
NoScan=YES

/opt/teradata/client/14.00/odbc_64/samples/C/adhoc
 
Enter Data Source Name: TD14
Enter UserID: gg
Enter Password:
 
Connecting with SQLConnect(DSN=TD14,UID=gg,PWD=*)...
 
.....ODBC connection successful.
 
ODBC version        = -03.52.0000-
DBMS name           = -Teradata-
DBMS version        = -14.00.0001  14.00.00.01-
Driver name         = -tdata.so-
Driver version      = -14.00.00.04-
Driver ODBC version = -03.51-

 telnet 192.168.10.1 7809
Trying 192.168.10.1...
telnet: connect to address 192.168.10.1: Connection timed out

 telnet 192.168.10.1 7809
Trying 192.168.10.1...
telnet: connect to address 192.168.10.1: Connection timed out

2012-08-16 03:56:08  INFO    OGG-00963  Oracle Oracle GoldenGate Manager for Teradata, mgr.prm:  Command received from EXTRACT on host 192.168.10.1 (START REPLICAT TGLOAD CPU -1 PRI -1 PARAMS ).
2012-08-16 03:56:08  INFO    OGG-00973  Oracle Oracle GoldenGate Manager for Teradata, mgr.prm:  Manager started replicat task process (Port 60643).
2012-08-16 03:56:08  INFO    OGG-01025  Oracle GoldenGate Delivery for Teradata:  REPLICAT task started by manager (port 60643).
2012-08-16 03:56:13  INFO    OGG-01229  Oracle GoldenGate Delivery for Teradata:  Connected to 192.168.10.1:65363.
2012-08-16 03:56:13  INFO    OGG-00995  Oracle GoldenGate Delivery for Teradata, tgload.prm:  REPLICAT TGLOAD starting.
2012-08-16 03:56:13  ERROR   OGG-01224  Oracle GoldenGate Delivery for Teradata, tgload.prm:  Resource temporarily unavailable.
2012-08-16 03:56:18  ERROR   OGG-01668  Oracle GoldenGate Delivery for Teradata, tgload.prm:  PROCESS ABENDING.

PORT 7809
dynamicportlist 7810-7820

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

2012-08-16 23:41:36  INFO    OGG-03035  Operating system character set identified as windows-1251. Locale: en_US, LC_ALL:.
--
-- GoldenGate Initial Data Capture
-- for TCUSTMER and TCUSTORD
--
EXTRACT load
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID gg, PASSWORD **
RMTHOST 192.168.1.144, MGRPORT 7809
RMTTASK REPLICAT, GROUP tgload
TABLE GG.TCUSTMER;
Using the following key columns for source table GG.TCUSTMER: CUST_CODE.

TABLE GG.TCUSTORD;
Using the following key columns for source table GG.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.


2012-08-16 23:41:43  INFO    OGG-01815  Virtual Memory Facilities for: COM
    anon alloc: MapViewOfFile  anon free: UnmapViewOfFile
    file alloc: MapViewOfFile  file free: UnmapViewOfFile
    target directories:
    C:\ggs\dirtmp.

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

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         = "AMERICAN_AMERICA.AL32UTF8"
NLS_LANGUAGE     = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"

2012-08-16 23:42:04  WARNING OGG-01223  TCP/IP error 10060 (A connection attempt failed because the connected party did not properly re
spond after a period of time, or established connection failed because connected host has failed to respond.).

2012-08-16 23:42:20  INFO    OGG-01230  Recovered from TCP error, host 192.168.1.144, port 7818.


GGSCI (WRUPE186001-OZI) 17>

***********************************************************************
                Oracle GoldenGate Delivery for Teradata
     Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700 
 Linux, x64, 64bit (optimized), Teradata ODBC on Jul 29 2011 21:52:09
 
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.


                    Starting at 2012-08-16 12:42:23
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Fri Aug 31 13:07:27 UTC 2007, Release 2.6.16.53-0.8.PTF.328697.0-smp
Node: s10-1300
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: 11456

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
----REPLICAT from Oracle to Teradata
DBOPTIONS _ODBC_UNIX_UTF16
REPLICAT tgload
TARGETDB TD13, USERID dbc, PASSWORD ***

2012-08-16 12:42:39  WARNING OGG-00572  Outstanding SQL statements limited to 15 by the Teradata ODBC driver.
DISCARDFILE ./dirrpt/tgload.DSC, PURGE
MAXTRANSOPS 500
BATCHSQL BATCHTRANSOPS 500, BYTESPERQUEUE 1000000,OPSPERBATCH 500
REPORTCOUNT EVERY 60 MINUTES, RATE
SOURCEDEFS ./dirdef/table.def
MAP GG.TCUSTMER, TARGET GGDB.TCUSTMER;
MAP GG.TCUSTORD, TARGET GGDB.TCUSTORD;

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

Database Version:
Teradata
Version 13.00.0019  13.00.00.19
ODBC Version 03.52.0000

Driver Information:
tdata.so
Version  13.00.00.03
ODBC Version 03.51

Database Language and Character Set:

Warning: Unable to determine the application and database codepage settings.
Please refer to user manual for more information.


2012-08-16 12:42:39  WARNING OGG-01223  TCP/IP error 104 (Connection reset by peer).

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************