Unable to connect to datasource oracle using TPT

Connectivity

Unable to connect to datasource oracle using TPT

Am trying to fetch data from oracle table and load it to teradata table using TPT. But not able to connect to oracle.

 

Error:

Teradata Parallel Transporter ODBC Operator Version 15.00.00.00
ODBC_OPERATOR: private log specified: exportoper_privatelog

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER =
= =
= ODBC OPERATOR VERSION 15.00.00.00 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.00.00.00 =
= =
= COPYRIGHT 2001-2014, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
= =
= Process I.D.: *****=
= =
===================================================================

**** 23:53:55 Processing starting at: Thu Jan 5 23:53:55 2017

===================================================================
= =
= Module Identification =
= =
===================================================================

ODBC Operator for Linux release 2.6.32-642.6.2.el6.x86_64 on vvsl50285
ODBCMain : 15.00.00.03
ODBCSQL : 15.00.00.06
ODBCUtil : 15.00.00.01
PcomCLI : 15.00.00.23
PcomMBCS : 14.10.00.02
PcomMsgs : 15.00.00.01
PcomNtfy : 14.10.00.05
PcomPx : 15.00.00.07
PcomUtil : 15.00.00.07
PXICU : 15.00.00.00
TDICU : 15.00.00.00

===================================================================
= =
= Attribute Definitions =
= =
===================================================================

**** 23:53:55 Options in effect for this job:
OperatorType: Producer
Instances: 2
Character set: Not specified; will use default
Checkpoint: No checkpoint in effect
DataBlockSize: 2048K bytes

===================================================================
= =
= SQL Session Connection =
= =
===================================================================

**** 23:53:55 Connecting to RDBMS: <not supplied by user>
**** 23:53:55 Connecting with UserId: '******'
ODBC_OPERATOR: connecting sessions
ODBC_OPERATOR: TPT17122: Error: unable to connect to data source
**** 23:53:55 TPT17122: Error: unable to connect to data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=I, CODE=0,
MSG='['
**** 23:53:55 TPT17101: Fatal error received from ODBC driver:
STATE=I, CODE=0,
MSG='['
MAIN_STEP SELECT_2[0001] Fatal Error ODBC_OPERATOR 2 1 INITIATE-Ended 23:53:55 0.0000 0.0000 65000 0 0 0 0 0 N Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP SELECT_2[0001] Success ODBC_OPERATOR 2 1 TERMINATE-Started 23:53:55 0.0000 0.0000 65000 0 0 0 0 0 N Y

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

ODBC_OPERATOR: disconnecting sessions
**** 23:53:55 Logging off all sessions
ODBC_OPERATOR: TPT17124: Error: unable to disconnect from data source
**** 23:53:55 TPT17124: Error: unable to disconnect from data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=0, CODE=0,
MSG='['
**** 23:53:55 TPT17101: Fatal error received from ODBC driver:
STATE=0, CODE=0,
MSG='['

Instance Cpu Time
======== ================
1 0.00 Seconds
2 0.00 Seconds

**** 23:53:55 Total processor time used = '0 Second(s)'
. Start : Thu Jan 5 23:53:55 2017
. End : Thu Jan 5 23:53:55 2017
. Highest return code encountered = '12'.
ODBC_OPERATOR: Total processor time used = '0 Second(s)'
ODBC_OPERATOR: Start : Thu Jan 5 23:53:55 2017
ODBC_OPERATOR: End : Thu Jan 5 23:53:55 2017

 

details:

Red Hat Enterprise Linux Server release 6.8
Teradata Parallel Transporter Version 15.00.00.00

DataDirect ODBC driver :ddtrc26.so

 

 

Tags (1)