Install Oracle Client 18c - Intergraph Smart Reference Data - 2016 R4 (8.4.0) - Installation & Upgrade - Hexagon

Intergraph Smart Reference Data Installation 2016 R4 (8.4)
Language
English
Product
Intergraph Smart Reference Data
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
2016 R4 (8.4)

Install the Oracle client version V979518-01.

  1. Open the Client folder and double-click setup.exe.

  2. Select Administrator and click Next.

    Software installation path

  3. In the Select Product Languages window, select English, click Selectarrow, and click Next.

  4. In the Oracle Home User Selection window, select Use Windows Built-in Account, and click Next.

  5. Click Next.

    SHARED Tip If you want to change the Oracle base or software location, click Browse and select another directory.

  6. In the Summary window, click Install.

  7. When the installation is finished, click Close.

Register 18c Oracle.DataAccess.dll and Oracle.DataAccess.EntityFramework.DLL

After you install Oracle client, you must manually register Oracle.DataAccess.dll to Global Assembly Cache (GAC).

  1. Enter the command cmd in Windows search.

  2. Right-click Command Prompt, and then click Run as administrator.

  3. Type the command to access the ODP.NET folder which is in the Oracle installation location.

    Example: >CD<Oracle Installation Drive>\<Oracle installation folder>\product\18.0.0\client_1\ODP.NET\bin\4

    ODP.NET

  4. Type the command, oraprovcfg /action:gac /providerpath:<Oracle Installation Drive>\<Oracle installation folder>\product\18.0.0\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll

    RegisterGAC

    Repeat the same for Oracle.DataAccess.EntityFramework.DLL

  5. Type the command, oraprovcfg /action:gac /providerpath:<Oracle Installation Drive>\<Oracle installation folder>\product\18.0.0\client_1\ODP.NET\bin\4\EF6\Oracle.DataAccess.EntityFramework.dll

    Register 18c

From Oracle 18c, the 'UTL_FILE_DIR' parameter is no longer supported. Now, you must specify the name of a directory object and provide read, write permissions to 'm_project_role' and 'm_sys' user.

In case of multiple directories mapped to the same physical path, each directory need to be granted permission to generate the log files successfully from the system.