How to get NORMS running locally if there are Oracle issues

Instructions

Completely uninstall and reinstall oracle 12c. The installer we used was from the zip folder in \\TC4S0A\GROUPS\AARA\AARAD\Software Library\Developer Tools\Oracle, followed a standard installation, except for not installing any VS dev tools, and installed it system-wide.
Unconfigure Oracle’s GAC with the attached bat file (This is now in the \\Tc4s0a\groups\AARA\AARAD\NORMS folder)

Installed the latest ODT from Oracle’s website

<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
<oracle.manageddataaccess.client>
  <version number="*">
    <settings>
      <setting name="NAMES.DIRECTORY_PATH" value="TNSNAMES"/>
    </settings><dataSources>
    <dataSource alias="SampleDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) "/>
    </dataSources>
  </version>
</oracle.manageddataaccess.client>

Verify the machine.config files in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config, and C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config.
I had Version=4.122.18.3 in the Web.config and Version=4.122.1.0 in the machine.config.
I updated the version(replaced Version=4.122.1.0 of oracle.manageddataaccess.client with 4.122.18.3) in both the machine.config, and the problem resolved.

Reference: https://stackoverflow.com/questions/33312848/oracle-odp-net-error

If after doing these fixes, NORMS runs but has nothing appear on the actual webpage, please see this article: How to Fix NORMS When It Displays Nothing When Running Locally

How to get NORMS running locally if there are Oracle issues

Instructions

Related articles