After installing both the Server and Client for Oracle, 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 P&ID to function with Oracle.
The following procedure describes the four commands that you need to run to register the appropriate DLLs to the GAC and complete the Oracle connection to Smart P&ID.
You must register these DLLs each time you apply a patch.
-
Open Windows CMD as an 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'.