We recently installed TTU 16.20 and unable to connect to oracle

Tools & Utilities
Teradata Employee

We recently installed TTU 16.20 and unable to connect to oracle

Teradata Parallel Transporter Version 16.20.00.01 64-Bit
Job log: /opt/teradata/client/16.20/tbuild/logs/tdadmin-106.out

 


Teradata Parallel Transporter Load Operator Version 16.20.00.01
LOAD_OPERATOR: private log not specified
Teradata Parallel Transporter ODBC Operator Version 16.20.00.01
ODBC_OPERATOR: private log not specified
ODBC_OPERATOR: connecting sessions
ODBC_OPERATOR: TPT17122: Error: unable to connect to data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
              STATE=82, CODE=0,
              MSG='523 80'
LOAD_OPERATOR: connecting sessions
LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: entering Acquisition Phase
LOAD_OPERATOR: disconnecting sessions
ODBC_OPERATOR: Total processor time used = '0.005 Second(s)'
ODBC_OPERATOR: Start : Fri Jun  8 10:28:33 2018
ODBC_OPERATOR: End   : Fri Jun  8 10:28:36 2018
LOAD_OPERATOR: Performance metrics:
LOAD_OPERATOR:     MB/sec in Acquisition phase: 0
LOAD_OPERATOR:     Elapsed time from start to Acquisition phase:   3 second(s)
LOAD_OPERATOR:     Elapsed time in Acquisition phase:   0 second
LOAD_OPERATOR:     Elapsed time in Application phase:   0 second
LOAD_OPERATOR:     Elapsed time from Application phase to end: < 1 second
LOAD_OPERATOR: Total processor time used = '0.047993 Second(s)'
LOAD_OPERATOR: Start : Fri Jun  8 10:28:33 2018
LOAD_OPERATOR: End   : Fri Jun  8 10:28:36 2018
Job step INSERT_TD_TABLE terminated (status 12)
Job tdadmin terminated (status 12)
Job start: Fri Jun  8 10:28:33 2018
Job end:   Fri Jun  8 10:28:36 2018

9 REPLIES
Highlighted
Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

This error generally means that you are pointing to 32-bit drivers but need the 64-bit version (or maybe vice versa).

Check the PATH / LD_LIBRARY_PATH / etc.

Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

Does 16.20 only support 64 bit datadirect drivers when connecting to Oracle?
Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

Does 16.20 only support 64 bit datadirect drivers when connecting to Oracle?
Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

Pointed to 32-bit but still receiving a different error

ODBC_OPERATOR: TPT17204: Driver Manager load error: 'lib_Ticu27.so: wrong ELF class: ELFCLASS32'

Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

It seems you are invoking 64-bit tbuild, so you do need the 64-bit drivers.

Double check the odbc.ini file (by default the one in <TPT16.20 install directory>/odbc) to be sure the Driver= points to the correct driver file, as well as having the correct library search path.

 

TPT 16.20 supports Simba or Oracle drivers for connecting to Oracle, in addition to the bundled / branded Data Direct drivers & driver manager.

Fan

Re: We recently installed TTU 16.20 and unable to connect to oracle

I have similar issue with TTU 16.20.  TTU 15.10 had 32 bit [which we use] and 64 versions of tbuild, but TTU 16.20 seems to have only 64 bit version of tbuild:

 


#tvlawsl01.lab.bcbsmn.com:/opt/teradata/client/15.10:>find -name tbuild -type l
./bin/tbuild
./tbuild/bin/tbuild
#tvlawsl01.lab.bcbsmn.com:/opt/teradata/client/15.10:>./bin/tbuild -V
Teradata Parallel Transporter Version 15.10.00.00 64-Bit
#tvlawsl01.lab.bcbsmn.com:/opt/teradata/client/15.10:>./tbuild/bin/tbuild -V
Teradata Parallel Transporter Version 15.10.00.00 32-Bit
#tvlawsl01.lab.bcbsmn.com:/opt/teradata/client/15.10:>which tbuild
/opt/teradata/client/15.10/tbuild/bin/tbuild


#tvlawsl02.lab.bcbsmn.com:/opt/teradata/client/16.20:>find -name tbuild -type l
./bin/tbuild
#tvlawsl02.lab.bcbsmn.com:/opt/teradata/client/16.20:>./bin/tbuild -V
Teradata Parallel Transporter Version 16.20.00.05 64-Bit
#tvlawsl02.lab.bcbsmn.com:/opt/teradata/client/16.20:>which tbuild
/opt/teradata/client/16.20/bin/tbuild

Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

Did you use the setup.bat script to install, as recommended in the Installation Guide? Did you have the required 32-bit compat C/C++ runtime libraries installed prior to installing TTU?

Fan

Re: We recently installed TTU 16.20 and unable to connect to oracle

This is a Linux installation, so our middleware department used file setup.sh to perform the installation.  I attached the installation log file and the TTU 16.20 directory structure.

 

We ran TTU 15.00 on this server prior to the TTU 16.20 installation, so there were c++ components on the server if they were required by TTU.  It has these c++ components:

 

#tvlawsl02.lab.bcbsmn.com:/usr:>find . -name libstdc* -exec ls -lart {} +

find: `./lib64/audit': Permission denied

find: `./lib/vmware-tools/symvers': Permission denied

find: `./local/lib64/perl5': Permission denied

-rwxr-xr-x. 1 root root  262024 May 17  2010 ./lib/libstdc++-3-libc6.2-2-2.10.0.so

-rwxr-xr-x. 1 root root  825480 Jun 28  2010 ./lib64/libstdc++.so.5.0.7

-rwxr-xr-x. 1 root root  733292 Jun 28  2010 ./lib/libstdc++.so.5.0.7

lrwxrwxrwx. 1 root root      18 Feb  5  2013 ./lib64/libstdc++.so.5 -> libstdc++.so.5.0.7

lrwxrwxrwx. 1 root root      31 Feb  5  2013 ./lib/libstdc++-libc6.2-2.so.3 -> libstdc++-3-libc6.2-2-2.10.0.so

lrwxrwxrwx. 1 root root      18 Feb  5  2013 ./lib/libstdc++.so.5 -> libstdc++.so.5.0.7

-rwxr-xr-x  1 root root  930192 Apr 12  2018 ./lib/libstdc++.so.6.0.13

-rwxr-xr-x  1 root root  989840 Apr 12  2018 ./lib64/libstdc++.so.6.0.13

-rw-r--r--  1 root root 1006992 Jun 18 11:50 ./lib/vmware-tools/lib64/libstdc++.so.6/libstdc++.so.6

-rw-r--r--  1 root root  950284 Jun 18 11:50 ./lib/vmware-tools/lib32/libstdc++.so.6/libstdc++.so.6

-r-xr-xr-x  1 root root 1006992 Jun 18 11:50 ./lib/vmware-caf/pme/lib/libstdc++.so.6

lrwxrwxrwx  1 root root      19 Aug 23 18:27 ./lib64/libstdc++.so.6 -> libstdc++.so.6.0.13

lrwxrwxrwx  1 root root      19 Aug 23 18:28 ./lib/libstdc++.so.6 -> libstdc++.so.6.0.13

 

./lib/vmware-tools/lib64/libstdc++.so.6:

total 992

drwxr-xr-x  2 root root    4096 Jun 18 11:50 .

-rw-r--r--  1 root root 1006992 Jun 18 11:50 libstdc++.so.6

drwxr-xr-x 84 root root    4096 Jun 18 11:50 ..

 

./lib/vmware-tools/lib32/libstdc++.so.6:

total 940

drwxr-xr-x  2 root root   4096 Jun 18 11:50 .

-rw-r--r--  1 root root 950284 Jun 18 11:50 libstdc++.so.6

drwxr-xr-x 82 root root   4096 Jun 18 11:50 ..

Teradata Employee

Re: We recently installed TTU 16.20 and unable to connect to oracle

Thought I would comment a bit on TPT (bitness) and its ODBC support.

 

Prior to TPT 16.00, when TPT was installed, 32-bit was the default.

This changes in 16.00 (known as 16.10). That is when we switched so that 64-bit TPT is the default.

And during the installation (unless specifically noted otherwise), 32-bit TPT is installed as well, we just do not make it simple to switch.

The goal is to get everyone onto 64-bit TPT. Most OS vendors are slowly doing away with 32-bit versions and we are no different.

Thus, if you really want to use 32-bit, I hope there is a real compelling reason to do so.

And to note, TPT16.20 is the last release in which we will be distributing 32-bit TPT.

 

Fred noted that TPT supports Simba ODBC drivers for Oracle, as well as the native Oracle drivers.

That is true, however we are expecting the user to use the bundled drivers from DataDirect by default.

The other driver vendors require their own driver manager (you cannot use the DataDirect driver manager with non-DataDirect drivers).

And if you use your own (non-DataDirect) driver manager, you must tell TPT where the driver manager file is in the TPT script.

And it seems as though you need to set the LD_LIBRARY_PATH environment variable (or platform equivalent) with that information as well (although I have not verified this; I just heard from our testers that this is so).

 

-- SteveF