Registering Oracle .NET Assemblies - Intergraph Smart Electrical - 2019 (9.0) - Installation & Upgrade - Hexagon

Intergraph Smart Electrical Installation and Upgrade
Language
English
Product
Intergraph Smart Electrical
Search by Category
Installation & Upgrade
Smart Electrical Version
2019 (9.0)

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

After installing both the Server and Client for Oracle 12.2 or 18.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 12.2 or 18.3 but are required for Smart Electrical 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 Electrical.

  • In the example below change 12.2 to 18.3 if you are using Oracle 18.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\12.2\client_1\ODP.NET\bin\4\OraProvCfg.exe> /action:gac /providerpath: " <Oracle_Installation_Folder>\product\12.2\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll"

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

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

    • CMD: <Oracle_Installation_Folder>\product\12.2\client_1\ODP.NET\bin\4\OraProvCfg.exe> /action:gac /providerpath: " <Oracle_Installation_Folder>\product\12.2\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 Electrical 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'.