Confirming the database connection

When attempting to connect the Migration Tool to a database, the console window may display an error. The error states that the ojdbc driver (or other database driver) is not found in the library. This error indicates that the Migration Tool cannot connect to the database.

To confirm that the Migration Tool can connect to the database:

  1. Review the batch file:
    1. Open the Migration Tool batch file in a text editor.

    2. On the second line of the batch, confirm that the database driver (for example, ojdbc8.jar) is the first driver in the list of Java drivers.

    3. Confirm that no unnecessary database drivers are in the list.
  2. Confirm that the home folder that contains the Migration Tool's batch file, also contains the database driver (ojdbc8.jar).
  3. Confirm that a JAVA_HOME variable exists in the environment variables and points to the correct location.
  4. Uninstall any additional versions of Java on the machine that are not needed by other applications.
    Uninstalling these versions prevents conflicts with the version used by the Migration Tool.
  5. Confirm that the supported JRE version exists on the machine. If not, download the JRE from: http://www.oracle.com/technetwork/java/archive-139210.html.
  6. If the error persists:
    1. Locate the database driver in the database home directory (for example, Oracle - C:\oracle\jdbc\lib\ojdbc8.jar).
    2. Copy and paste the driver into the Migration Tool's home directory.
    3. If the system asks if you want to overwrite the file, say yes. This step assures that the version of the database driver in the Migration Tool folder, matches the version in the database folder.