My Oracle Support Banner

Ora-28506 Ora-28559 Ora-1790 When Selecting All_users, All_tab_columns Or Dual Using TG4DRDA As Non-Sysdba User (Doc ID 393490.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database Gateway for DRDA - Version to [Release 10.2 to 11.2]
IBM AIX on POWER Systems (64-bit)
Oracle Transparent Gateway for IBM DRDA - Version: Based Systems (64-bit)

***Checked for relevance on 23-NOV-2011***


Problem reproduces with the DRDA Gateway 10.2 on AIX platform and DB2/UDB on AIX


SQL> select * from all_users@TEST_USER;
select * from all_users@TEST_USER
ERROR at line 1:
ORA-28506: parse error in data dictionary translation for ALL_USERS stored in
ORA-00604: error occurred at recursive SQL level 1
ORA-01790: expression must have same datatype as corresponding expression
ORA-02063: preceding 4 lines from TEST_USER


In 11.2 version, we can get a different error like ORA-3113 :

SQL> Select 1 from dual@TEST_USER;
Select 1 from dual@TEST_USER
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 30102
Session ID: 141 Serial number: 18969

This problem is reproduced when the database link has been created by a user that does not have
SYSDBA privileges.
The SELECT is executed by this non-SYSDBA user.

The problem reproduces only in 3 cases:

Select 1 from dual@TEST_USER;
select * from all_users@TEST_USER;
select * from all_tab_columns@TEST_USER;

There is no problem with another dictionary views or tables and  if the user is a SYSDBA user.


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.