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 JANUARY 19, 2017

Applies to:

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

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


Symptoms

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
sys.hs_all_dd
ORA-28559: FDS_CLASS_NAME is TG4DRDA_DB2UDB10.2.0.1.0, FDS_INST_NAME is
ORAGWDB2
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.

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