3.3 Accessing the Gateway
This topic describes how to access the gateway.
To access the gateway, complete the following steps on the Oracle database:
- Log into the Oracle database to access the gateway.
- Create a database link to the DRDA database. For example:
CREATE PUBLIC DATABASE LINK DRDA CONNECT TO ORADRDA IDENTIFIED BY oracle_pw USING 'tns_name_entry'
- Retrieve data from the DRDA database.
This query fetches the
TABLE
table in the schemaSECURE
, using the nameORADRDA
as the DRDA server user profile. TheORADRDA
user profile must have the appropriate privileges on the DRDA server to access theSECURE.TABLE
files:SELECT * FROM SECURE.TABLE@DRDA
The following is an example of the error messages that are displayed if insufficient privileges are displayed:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]ORADRDA DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION SELECT ON THIS OBJECT SECURE.TABLE. ORA-02063: preceding 2 lines from DRDA
Parent topic: Using the Oracle Database Gateway for DRDA