Downloading Gateway Products

Oracle Database Gateway products can be downloaded from the following –

1. Oracle Technology Network – OTN –

http://www.oracle.com/technology/software/products/database/index.html

Choose the relevant platform and version then the ‘See All‘ option.
Under that there will be an option to download the Gateway products, for example –

Oracle Database Gateways 11g Release 2 (11.2.0.1.0) for Microsoft Windows (32-bit)

Only 11.2 and 12c versions can be downloaded from this link.
If installing the base 11.2.0.1.0 version you should then apply the latest patchset which is currently 11.2.0.4.

Extracting the Installation Files

  1. Move the zip file downloaded to oracle folder (/u01/app/sw )
  2. If the downloaded file has the zip extension, use the following command to extract the content:

  1. Start the installer:

Oracle Universal Installer: Welcome

  1. Click Next.

Oracle Universal Installer: Specify Home Details :

  1.  Specify a name for the installation in the Name field
  2. The Path field in the Specify Home Details screen is where you specify the destination for your installation .

Oracle Universal Installer: Available Product Components

  1. SelectOracle Database Gateway for SQL Server 11.2.
  2. Click Next.

Oracle Database Gateway for SQL Server

  1. SQL Server Database Server Host Name – Specify the host name or the IP address of the machine hosting the SQL Server database server
  2. SQL Server Database Server Port number – Specify the port number of the SQL Server database server
  3. SQL Server Database Name – Specify the SQL Server database name

 

Oracle Universal Installer Summary

  1. Click Install to start.

Click Install

Once it prompts with above screen, open another shell and run the script as root

Click Exit to Finish the installation.

In next article we can configure Oracle Database Gateway for Microsoft SQL Server.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply