Using DG4DRDA Connections Fail Wth Errors AUTHORIZATION ERROR BIND NativeErr = -567 or BIND ADD ERROR NativeErr = -719 (Doc ID 1432620.1)

Last updated on AUGUST 08, 2013

Applies to:

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

Symptoms

After an upgrade or new installation of Database Gateway for DRDA (DG4DRDA) 11.2.0.3 the following error is received on any query through the gateway if a manual bind of the gateway package is performed instead of an automatic bind:

select sysdata from dual@drda_link
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver][DB2]AUTHORIZATION ERROR BIND DVFIS01. UCCMVSBQ.NULLID.DDOS510A.(01) BINDADD
{HY000,NativeErr = -567}
ORA-02063: preceding 2 lines from DRDA_LINK

 

If an automatic bind has been made the following error happens when trying to connect as a different user from that which made the bind -

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver][DB2]BIND ADD ERROR; PACKAGE <package_name>
ALREADY EXISTS.  DB2F.ORACLEGTW.DD999.(01) {HY000,NativeErr = -719}
ORA-02063: preceding 2 lines from <db_link>



Changes

Upgrade or a new install of DG4DRDA 11.2.0.3.

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