“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 !

AWS RDS OracleDB - Oracle Client 11g x64bit installation on Windows 8 or above

Here are the steps to install free x64bit Oracle client 11g on your windows PC.

i got this error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater." even after installing 64bit ODAC components in my PC. Then i realized i would require Oracle Client 11g as well.

step 1:  download the zip files from Oracle site available with below header. PFB,

Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64)

step 2: extract both the zip files in same folder (i created OracleClient folder here). 
let's say,
C:\Users\Testuser123\Desktop\OracleClient

step 3: after extraction, goto the folder and run 'setup.exe' as Administrator.

then follow the step by step process mentioned in this video.

This would take around 12 minutes for finishing installation.

Once this is installed you can use your SQL*PLUS to connect to AWS oracleDB, or System.Data.OracleClient dlls and libraries through vs2015 without any issues.

Thanks for your time :)

Hope this is helpful..

Failure - Test failed: The Network Adapter could not establish the connection for AWS Oracle DB

I have experienced these issues while developing a service web application using back end as AWS Oracle DB and front end - HTML5, CSS3, C#.net framework 4.6.

Very few people would opt for RDS Oracle DB. Hence, we find very less resolutions for issues related to AWS oracle Database.

Here is one among them,
'Failure - Test failed: The Network Adapter could not establish the connection'

We get this issue due to improper Inbound/Outbound traffic configuration of Security groups for your RDS database in AWS console.


Here is the step by step resolution for this,


Goto RDS Dashboard in Amazon Web service (AWS) console and click on Instances.

Click on your available DB instance and select Details tab.  Please see the highlighted below,

click on your security group. 

Note: it's best if you customize your security group rather than using Default groups,

Then select Inbound Traffic configuration and click on EDIT.

Now, here you can customize as how you are going to connect to this Database.

You can determine if the connection is specific to a person or a group or a process.

In my case, only me needed the connection to this Database. 

so, in Source column, modify the drop down menu as per requirements. 

if the connection is for your self, 

choose 'MY IP' from the drop down. This automatically stores your IP address and allows you to connect to the Database.

Now try connecting from SQL Developer and starting creating your own DB Objects.

Hope this is Helpful!

Followup with learning additional errors-Fixes.. :)