My Oracle Support Banner

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

Last updated on JANUARY 18, 2017

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.