Fix “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error in .NET

Introduction

In this article I will explain cause and resolution of “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error

Cause

This error generally occurs when you deploy an application on the server that access Oracle database using “System.Data.OracleClient” library and it doesn’t find the library on the server.

Resolution

To resolve this error you need to install Oracle Data Access Components (ODAC) with Xcopy deployment on the server which enables Oracle Data Provider for .NET (ODP.NET). Please follow these steps to install ODAC on the server

Step 1: Download ODAC component

For 32-bit download ODAC1120320Xcopy_32bit.zip from here
For 64-bit download ODAC112021Xcopy_x64.zip from here

You have to sign up to download these from oracle.com.  I will download and install ODAC for 64-bit.

Step 2: Extract downloaded zip file anywhere on the system for example on the Desktop

2013-09-22 17_44_47-ODAC112021Xcopy_x64

Step 3: Open Command Prompt (cmd) and run following command to change directory to the extracted folder:
cd C:UsersdeepakDesktopODAC112021Xcopy_x64

2013-09-22 18_04_37-C__Windows_system32_cmd.exe

Step 4: Run following command in the Command Prompt to install Oracle Data Access Components
install.bat odp.net20 c:oracle11.2odac odac11

2013-09-22 18_09_10-C__Windows_system32_cmd.exe

Step 5: Add following paths of the installed ODAC components in the Path environment variable of the system

C:oracle11.2odac
C:oracle11.2odacbin

Follow these steps to add paths to the environment variable

Step 5.1: Right click on “Computer” and select “Properties” to open the System properties

Step 5.2: Click on “Advanced system settings” to open “System Properties”

Step 5.3: Click on “Environment Variables” button under “Advanced” tab to open “Environment Variables” window

Step 5.4: Double click on the “Path” variable in the “System Variables” (scroll down if it’s not visible) section to edit the “Path” variable

Step 5.5: Add C:oracle11.2odac;C:oracle11.2odacbin; at the beginning in the “Variable value” TextBox

Step 5.6: Close all the windows by clicking on “OK” button

Step 6: Restart your system.

Note: If 64-bit ODAC component(ODAC112021Xcopy_x64) does not works in a 64-bit system, try to install 32-bit ODAC component (ODAC1120320Xcopy_32bit). It worked for me.

14 thoughts on “Fix “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error in .NET

  1. cjsrssslove@gmail.com

    Hi sir,
    Thanks for your article and i had an issue when i run install.bat odp.net20 c:oracle11.2odac odac11 this command it shows an error like “Access is Denied “

    Reply
    1. Bhanu

      Thanks for the post … its working fine on local but not working on IIS please suggest…. I have already given the necessary permission on oracle folder

      Reply
  2. Nirmalya Ganguly

    dear sir, I am getting this error after done all :- ORA-12154 : TNS COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED. OK.

    Reply
  3. kishor

    dear sir, I am also getting this error after done all :- ORA-12154 : TNS COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED. OK.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *