Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Check the machine.config file(s) in your Entity Framework folder(s) (C:\Windows\Microsoft.NET\Framework\VersionNumber(s)). If it contains the below code, comment it out, and try running NORMS again.

  1. Code Block
    languagexml
    <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>

  2. 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.21.1 in the machine.config.

    I updated the version, replaced Version=4.122.18.3 of Web.config to Version=4.122.21.1 and oracle.manageddataaccess.client with 4.122.21.1 in both the machine.config, and the issue was resolved.

Note: If you have an error to debug the app, verify the configurations below

...

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@85e
showSpacefalse
sortmodified
showSpacetypefalsepage
reversetrue
typelabelspageNORMS Oracle
cqllabel in ( "oracle" , "norms" ) and type = "page" and space = "CA"labelsNORMS Oracle
Page Properties
hiddentrue

Related issues