ORA-01017 with DRDA Gateway (Doc ID 2129623.1)

Last updated on APRIL 26, 2016

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting a connection to a DB2400 database on AS400 using Database Gateway for DRDA (DG4DRDA), an ORA-1017 error is encountered.

The following is seen in the DG4DRDA gateway trace file:

Entered hgopoer at 2016/04/21-08:35:08
hgopoer, line 231: got native error 0 and sqlstate 28000; message follows...
[Oracle][ODBC DB2 Wire Protocol driver]Connection authorization failure occurred. Reason: Local Security Service non-retryable error. {28000}
Exiting hgopoer, rc=0 at 2016/04/21-08:35:08
hgocont, line 2755: calling SqlDriverConnect got sqlstate 28000

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