ODBC Connect Using TAF Preconnect Method Returns ORA-01017

(Doc ID 275585.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]
Oracle ODBC Driver - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Trying to use the Oracle ODBC driver and TAF PRECONNECT method results in 

ORA-1017 invalid username/password; logon denied.


The behavior can be reproduced with the a simple ODBC connection (the "Test Connection" button, for example) and the following TNSNames.ora entry.:

1. Edit tnsnames.ora and add the following connect string.

taf_test=
  (description=
    (failover=on)
    (load_balance=on)
    (address=
      (protocol=tcp)
      (host=myhostname)
      (port=1521))
    (address=
      (protocol=tcp)
      (host=myhostname)
      (port=1521))
    (connect_data=
      (service_name=ora92)
      (failover_mode=
        (type=session)
        (method=PRECONNECT))))

2. Create a new Oracle ODBC DSN and refer to the "taf_test" alias

3. Perform a test connection from the ODBC Administrator->Oracle dsn->configure

 

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