Oracle Database Connection Error

When encountering error message similar to the one mentioned below, please follow below instructions.

DS:34 Process Runner DB
DBMANAG:1 The type initializer for 'Process_Runner_DB.ProrDBOracle' threw an exception.

Cause

This error occurred due to incompatible version of Oracle Data Access Components (ODAC) installed on user's machine.

Prerequisites

Perform the following to know the running windows system type:
Select the Start button.
Right-click Computer, select Properties.The Properties window apperars.
Under System check out the System Type. It would either be a 32-bit or a 64-bit operating system.

Suggested Solution

Install compatible version of Oracle Data Access Components (ODAC) for Process Runner DB from the following link: www.oracle.com/database/technologies/odac-nuget-downloads.html
Once the link is opened in the browser, scroll-down the window and select download link as shown below:
Unzip the file to a location of your choice. In this example, we have set the path as C:\.
For instructions on ODAC112040Xcopy installation, refer to the README included with that particular installation.
Copy the downloaded zip folder into one of the system drives. For example the C:\.
Open Command Prompt, ensure to run it as Administrator.
In the Cmd window, open the copied folder.
To change the drive to C: type the C:\ and hit enter.
Enter cd C:\ODAC112040Xcopy_32bit which is the name of the folder we copied. The cursor will change to C:\ODAC112040Xcopy_32bit as we have selected the ODAC112040Xcopy_32bit folder.
Enter the command install.bat all [drive]\[folder] odac, this would install the .bat file in the this folder. for example install.bat all c:\oracle odac.