Troubleshooting connection issue between Oracle Database & Opkey

Issue: - Troubleshooting connection issue between Oracle Database & Opkey

Platform

Opkey On-Premise and SaaS.

Solution

While connecting Opkey with the Oracle database, located on local or remote machine, Opkey users come across such issues:


System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for system.data: Column ‘InvariantName’ isconstrained to be unique. Value ‘Oracle.DataAccess.Client’ is already present.


Cause: 
The most common cause of such type of issue is installing or uninstalling of ODAC driver multiple times.


Resolution: The resolution for the above cause is to remove one row from the machine.config file ofMicrosoft.Net folder.
The machine.config file can be found at the following path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
The row to be deleted is given below:
“<add name=”ODP.NET, Unmanaged Driver” invariant=”Oracle.DataAccess.Client”description=”Oracle Data Provider for .NET, Unmanaged Driver”type=”Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess,Version=4.121.1.0, Culture=neutral, Public Key Token=89b483f429c47342″ />

Note:
Check before row deletion: Please check that the row with the above given value exists twice in the machine.config file. Now remove the last row with these values.

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article