Database Login on Teradata Failing with "Not enough information to log on" Error (Doc ID 1303152.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version 4.0.0 to 11.1.1.0.11 [Release 4.0.0 to 11.1.1]
Information in this document applies to any platform.

Symptoms

Error:
------
Extract or Replicat fail to start up with the following ODBC error:

2011-03-02 11:11:07 GGS ERROR 118 Database operation failed: Couldn't connect to TDWPDVLP. ODBC error: SQLSTATE 28000 native database error 0. [Teradata][ODBC Teradata Driver] Not enough information to log on.

Changes

Any user upgrading from ODBC 12.0 to 13.0.0.6 or higher will run into this issue if they do not have the userid and password in the parameter file. Since the userid and password are optional, a lot of users may not have this setup. This will then require parameter file changes when upgrading from 12.0 to 13.0.

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