Register Oracle .NET Assemblies - Intergraph Smart Instrumentation - 13.1 - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
13.1

If you are not installing Oracle Sever and Client version 18.3 or 19.3, you can skip this procedure.

After installing both the Server and Client for Oracle 18.3 or 19.3 you must run the following Command Line commands from the Command Line or Power Shell. This registers specific DLLs that were not registered in the Global Assembly Cache (GAC) when installing Oracle 18.3 or 19.3 but are required for Smart Instrumentation to function with Oracle.

The following procedure describes the four commands that you need to action to register the appropriate DLLs to the GAC and complete the Oracle connection to Smart Instrumentation.

  • In the example below change 18.3 to 19.3 if you are using Oracle 19.3.

  • You must register these DLLs each time you apply a patch.

  1. Open the WIndows CMD Interface.

  2. Run the following four commands in the CMD window.

    • CMD: <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\bin\4\OraProvCfg.exe> /action:gac /providerpath: " <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll"

    • CMD: <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\bin\4\OraProvCfg.exe> /action:gac /providerpath: " <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\PublisherPolicy\4\Policy.4.112.Oracle.DataAccess.dll"

    • CMD: <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\bin\4\OraProvCfg.exe> /action:gac /providerpath: " <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\PublisherPolicy\4\Policy.4.121.Oracle.DataAccess.dll"

    • CMD: <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\bin\4\OraProvCfg.exe> /action:gac /providerpath: " <Oracle_Installation_Folder>\product\18.3\client_1\ODP.NET\PublisherPolicy\4\Policy.4.122.Oracle.DataAccess.dll"

  3. Connect to the Instance you created when installing Oracle, using the Oracle Net Manager.

  4. Open the Smart Instrumentation Profile Manager and create a profile for your database.

  5. Run the DBSetup manager.

For additional Information, refer to:

  • Oracle Support article: '18.3 Installation Does Not Register Oracle Data Provider for .Net in the GAC (Doc ID 2272241.1)'.

  • Oracle Central Designer software Help topic: 'Registering .NET assemblies'.