Ora-28500 error with argument 523 80 {82}
Last updated on JANUARY 18, 2017
Applies to:
Oracle Database Gateway for Sybase - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Oracle Database Gateway for Informix - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Just adding a note that this note applied for an 11.2.0.3 DG4DRDA gateway issue as well...
Symptoms
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:
dsn:[myserver]:4141/facets
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
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
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