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

I got this issue while trying to connect through visual studio 2015 to AWS RDS OracleDB procedures.

I was trying to connect from Windows 8.1 which is a x64 bit processor.

After a lot of efforts i was able to resolve this issue.

I went through many blogs and forums but i did not find a clear cut resolution.
I had tried giving permissions to ORACLE_HOME, asp.net "\bin" directories. but nothing worked out in my way..

Note, System.Data.OracleClient is deprecated from visual studio 2015. 
people are using Add reference 'Oracle.DataAccess','Oracle.ManagedDataAccess.dll'. However, System.Data.OracleClient still works out as expected.

ISSUE:
This issue mainly happens when you have installed older version of Oracle client in your PC or when you do not have Oracle client installed on your PC.

Resolution:
if you already have this installed on your pc, skip to step 2,

step 1 - ODAC Installation: first you need to install Oracle Data Access Components - ODAC,

Remember to open command prompt as Administrator in the below process
clear steps are provided here for ODAC installation.

step 2 - Oracle Client 11g installation: then you need to install Oracle client 11g. 

i have mentioned the installation steps in another post. 


Once this is installed, restart your PC and check if this issue has been resolved.

Hope this is helpful !