To obtain the Oracle ODBC driver, you need to install the Oracle ODBC driver on the machine where you will be running the migration.

You can download the Oracle ODBC driver from the Oracle official website.

You need to select the appropriate version, download and run it.

Download the Basic Package (RPM), ODBC Package (RPM) v.19:

 oracle-instantclient19.19-basic-19.19.0.0.0-1.x86_64.rpm
 oracle-instantclient19.19-odbc-19.19.0.0.0-1.x86_64.rpm

Install the packages using the “sudo yum install” command.

Add environment variables. The shell script can be added to the /etc/profile.d directory.

 export ORACLE_HOME=/usr/lib/oracle/19.19/client64
 export LD_LIBRARY_PATH=/usr/lib/oracle/19.19/client64/lib:$LD_LIBRARY_PATH
 export PATH=/usr/lib/oracle/19.19/client64/bin:$PATH

Download the ODBC 11 driver archives:

 instantclient-basic-linux.x64-11.2.0.4.0.zip 
 instantclient-odbc-linux.x64-11.2.0.4.0.zip. 

Unpack the archives.

Add paths to the Oracle ODBC 11 driver libraries to the LD_LIBRARY_PATH environment variable. In this example the /home/bob/ODBC_drivers/Oracle/11 directory has been used. The shell script can be added to the /etc/profile.d directory.

 export LD_LIBRARY_PATH=/home/bob/ODBC_drivers/Oracle/11/instantclient-basic-linux.x64-11.2.0.4.0/instantclient_11_2:/home/bob/ODBC_drivers/Oracle/11/instantclient-odbc-linux.x64-11.2.0.4.0/instantclient_11_2:$LD_LIBRARY_PATH

Provide a unixODBC library named libodbcinst.so.1 (or a symbolic link) on the system.

Make sure you have a library named libodbcinst.so.1 on your machine. If there are no libodbcinst.so.* files, install unixODBC. If they are provided, create a symbolic link libodbcinst.so.1:

 cd /usr/lib64
 sudo ln -s libodbcinst.so.2 libodbcinst.so.1

Then configure the ODBC connection as described in the ODBC Driver Configuration article.

If you have any questions or encounter any difficulties, please contact us at support@ispirer.com