[Error 1000] [SQLState 08S01] Login Failure Is Received When Using ODI For Connecting To Teradata Data Server

(Doc ID 2141807.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When adding a connection to a Teradata Data Server in the Oracle data Integrator (ODI) Topology, the following Error is produced when the JDBC URL is configured as:

jdbc:teradata:/Teradata_server:1025/teradata

java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.41] [Error 1000] [SQLState 08S01]Login failure for Connection to MYSERVER:1025
Mon Apr 11 09:23:50 PDT 2016 socket orig=MYSERVER:1025 cid=7be2a92e sess=0 java.net.UnknownHostException: MYSERVER:1025
  at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
  at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:894)
  at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1286) at java.net.InetAddress.getAllByName0(InetAddress.java:1239)
  at java.net.InetAddress.getAllByName(InetAddress.java:1155)
  at java.net.InetAddress.getAllByName(InetAddress.java:1091)
  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:186)
  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:285)
  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:134)
  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:120) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:587)
  at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:97)
  at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:216)
  at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)
  at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)
  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)
  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)
  at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)
  at ...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms