Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You may get "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when using SSMA for Oracle

You may get "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when using SSMA for Oracle

Symptoms

When using SQL Server Migration Assistant  to migrate data from an Oracle server to a remote SQL Server you may get the following error message:

Exception during processing: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

The messages in the results pane may look similar to the following:

Starting data migration agent...
Starting data migration...
Exception during processing: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Data migration complete.

↑ Back to the top

Cause

The problem occurs due to one of the following reasons:
  • Oracle client is not installed on the system where the remote SQL Server is running.
  • Oracle client on the remote system is not accessible to BCP Data Migrator utility that is used in the transfer process.

↑ Back to the top

Resolution

You can take the following steps to resolve the problem:

  • Ensure that the latest version of SSMA for Oracle Extension Pack is installed on the remote SQL server.
  • Install Oracle Client on your remote SQL Server.
  • The BCP Data Migrator utility is started under the same account that is used for SQL Server Agent service on the remote SQL Server. Ensure that this account has sufficient  privileges on the Oracle client installation folder.
  • Ensure that ORACLE_HOME environment variable is set to the correct path for your Oracle client installation. 

↑ Back to the top

Keywords: kb, vkball

↑ Back to the top

Article Info
Article ID : 2019079
Revision : 3
Created on : 4/29/2020
Published on : 4/29/2020
Exists online : False
Views : 386