After installing both Oracle Server and Client, 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 but are required for Smart Engineering Manager 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 Engineering Manager.
You must register these DLLs each time you apply a patch.
-
Open the Windows CMD Interface as Administrator.
-
Run the following four commands in the CMD window.
-
CMD: <Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\bin\4\OraProvCfg.exe /action:gac /providerpath:<Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll
-
CMD: <Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\bin\4\OraProvCfg.exe /action:gac /providerpath:<Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\PublisherPolicy\4\Policy.4.112.Oracle.DataAccess.dll
-
CMD: <Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\bin\4\OraProvCfg.exe /action:gac /providerpath:<Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\PublisherPolicy\4\Policy.4.121.Oracle.DataAccess.dll
-
CMD: <Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\bin\4\OraProvCfg.exe /action:gac /providerpath:<Oracle_Installation_Folder>\product\xx.x.x\client_1\ODP.NET\PublisherPolicy\4\Policy.4.122.Oracle.DataAccess.dll
The screen shot below shows an example of successful registration of all the dlls.
-
For additional information, refer to:
-
Oracle Support article: 12.2 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'.