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

Intergraph Smart Reference Data Installation 2016 R4 (8.4)

PPMProduct
Intergraph Smart Reference Data
PPMCategory_custom
Installation & Upgrade
Version_SPMat_custom
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.

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

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

  5. Click Next.

    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.

  8. Change the registry setting NLS_LANG for the Oracle Client home to AMERICAN_AMERICA.AL32UTF8 (where AL32UTF8 is the character set of the database).

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

  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

    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

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.