My Oracle Support Banner

Ora-28500 error with argument 523 80 {82} (Doc ID 1417823.1)

Last updated on APRIL 09, 2020

Applies to:

Oracle Database Gateway for Sybase - Version to [Release 11.1 to 11.2]
Oracle Database Gateway for SQL Server - Version to [Release 11.1 to 11.2]
Oracle Database Gateway for Informix - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
Just adding a note that this note applied for an DG4DRDA gateway issue as well...


Error occurs when selecting via a Database Gateway (ex: DG4MSQL,DG4SYBS...)

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
523 80 {82}
ORA-02063: preceding 2 lines from FACETS

In the gateway trace file, we can see:

Exiting hgocip, rc=0 at 2012/02/07-08:58:54
Entered shgogohn at 2012/02/07-08:58:54
Exiting shgogohn, rc=28500 at 2012/02/07-08:58:54
Entered hgocont_OracleCsidToIANA at 2012/02/07-08:58:54
Returning 4
Exiting hgocont_OracleCsidToIANA at 2012/02/07-08:58:54
Exiting hgogenconstr, rc=0 at 2012/02/07-08:58:54
Entered hgopoer at 2012/02/07-08:58:54
hgopoer, line 233: got native error 0 and sqlstate 82; message follows...
523 80 {82} <==============================================abnormal digits
Exiting hgopoer, rc=0 at 2012/02/07-08:58:54
hgocont, line 2753: calling SqlDriverConnect got sqlstate 82
Exiting hgocont, rc=28500 at 2012/02/07-08:58:54 with error ptr FILE:hgocont.c LINE:2772 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2012/02/07-08:58:54 with error ptr FILE:hgolgon.c LINE:781 ID:Calling hgocont
Entered hgoexit at 2012/02/07-08:58:54
Exiting hgoexit, rc=0


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.