Oracle Database Gateway Installation and configuration to connect SYBASE

Oracle Database Gateway: DB Link between oracle and sybase

Download Oracle Database 12c Database Gateway for Sybase from https://edelivery.oracle.com

 Configuring Oracle Database Gateway for Sybase

Configure Oracle Net for the Gateway.

The Oracle Net Listener listens for incoming requests from the Oracle database. For the Oracle Net Listener to listen for the gateway, information about the gateway must be added to the Oracle Net Listener configuration file.

Start the Oracle Net Listener for the Gateway home

Configure the Oracle Database for Gateway Access

To can access Sybase system, it must have an entry in its tnsnames.ora file to contact the listener we just created/modified, edit tnsnames.ora and add a connect descriptor for the gateway.

To access the Sybase server, you must create a database link. A public database link is the most common of database links.

Query Sybase object