Differences

This shows you the differences between two versions of the page.

--- knowledge-base:database-migration:setup-and-troubleshooting:oracle:odbc-driver-installation [2018/06/21 12:43]
+++ knowledge-base:database-migration:setup-and-troubleshooting:oracle:odbc-driver-installation [2024/04/22 13:16] (current)
volha.zhyrava
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/oracle-migration|Ispirer Capabilities: Oracle Migration]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== Oracle: ODBC Driver Installation for Windows ======
+To obtain the Oracle ODBC driver, you will have to install the Oracle Client on the machine where you will run the migration.
+You can download the Oracle client, that includes ODBC Driver, from the [[http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html|Oracle official website]].
+You need to choose the appropriate version, download and run it.
+==== Oracle ODBC Driver 11g ====
+On the first page you need to choose the installation type. We recommend to install "Administrator" type:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_1.png?600|}}
+Select languages on which this product will run:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_2.png?600|}}
+Choose the Oracle base path and a location for storing Oracle software files:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_3.png?600|}}
+Click "Finish" button and wait for the installation process is finished:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_4.png?600|}}
+==== Oracle ODBC Driver 19c ====
+Run the installer file.
+At the first page you need to select radio button ‘Use Windows Build-in Account’ item:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_5.jpg?nolink|}}
+Select the Installation type ‘Administrator’ and check the Selected language.
+Specify an Installation Location:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_6.jpg?nolink|}}
+Perform Prerequisite Checks:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_7.jpg?nolink|}}
+Run the installation:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_8.jpg?nolink|}}
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_inst_9.jpg?nolink|}}
+Close the installer:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:oracle_odbc_inst_10.jpg?nolink|}}
+\\
+Then you will need to set up the TNS Service names and ODBC connections, the way it is shown in the articles below:
+   * [[knowledge-base/database-migration/setup-and-troubleshooting/oracle/tns-configuration|TNS Service Name Configuration]]
+   * [[knowledge-base/database-migration/setup-and-troubleshooting/oracle/odbc-driver-configuration|ODBC Driver Configuration]]
+\\
+If you have any other questions, please contact us: [[[email protected]]]