Prepare Oracle

Before you can create multi-user workspaces where several users have access to the same data, first you need to prepare your common repository.

To prepare an Oracle environment, follow the steps below:

Prepare the client

To prepare the client, you must install the corresponding Oracle Data Access Components (ODAC) on the client machine and redirect the ODAC version for all programs on the machine.

Download the installer directly from Oracle. You can install the ODAC in one of the following ways:

If you use the TBox DB Expert Module, you must install via Oracle Universal Installer. The required Oracle ODBC driver is not included in the XCopy deployment.

Install via XCopy

To install via XCopy, follow the steps below:

  1. Go to the Oracle downloads page.

  2. Download ODAC XCopy version ODAC 19.3. Use the 64-bit version if your operating system is 64-bit. Otherwise, you can use the 32-bit version.

  3. Extract the ZIP file to a temporary folder. You can delete the temporary folder and the ZIP file after the installation.

  4. Extract the ZIP file.

  5. Open a command prompt with administrator privileges and change to the temporary folder.

  6. Execute the following command with the path to your Oracle install folder: install.bat all <oracle install folder> odac

    For example: install.bat all C:\oraclexe\ODP.NETx64 odac

  7. Execute the following command to change to the install folder for the managed driver: cd "<oracle install location>\odp.net\managed\x64\"

  8. Execute the following command: configure.bat

  9. For the redirect, register the ODAC DLL file in the Global Assembly Cache (GAC) with the following command:

    OraProvCfg.exe /action:gac /providerpath:..\common\Oracle.ManagedDataAccess.dll

  10. To register the publisher policy, execute the following command:

    OraProvCfg.exe /action:gac /providerpath:..\PublisherPolicy\4\Policy.4.122.Oracle.ManagedDataAccess.dll

Install via Oracle Universal Installer (OUI)

To install via OUI, follow the steps below:

  1. Go to the Oracle downloads page.

  2. Download OUI version 64-bit ODAC 19.3.

  3. Extract the ZIP file to a temporary folder. You can delete the temporary folder and the ZIP file after the installation.

  4. Run the setup.exe file from the temporary folder.

  5. In the setup window, select Oracle Data Provider for .NET.

  6. Follow the installer prompts. By default, the install folder is C:\app\oracleuser\product\19.0.0\client_1

  7. Execute the following command to change to the install folder for the managed driver: cd "<oracle install location>\odp.net\managed\x64”

  8. Execute the following command: configure.bat

  9. For the redirect, register the ODAC DLL file in the Global Assembly Cache (GAC) with the following command:

    OraProvCfg.exe /action:gac /providerpath:..\common\Oracle.ManagedDataAccess.dll

  10. To register the publisher policy, execute the following command:

    OraProvCfg.exe /action:gac /providerpath:..\PublisherPolicy\4\Policy.4.122.Oracle.ManagedDataAccess.dll

Prepare the database

Make sure the user who prepares the Oracle server for common repositories has the following access rights to all tables of the common repository: SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER.

To prepare your database, follow these steps:

  1. Create a database on the database server.

  2. To create the tables, adapt the Create Tables ORACLE.sql script to your requirements, and then run it.

    You can find the script in %COMMANDER_HOME%\SQL\Oracle.

What's next

Now that you have prepared the database, you can create your workspaces. For information on how to do so, see chapter "Create Oracle, MS SQL Server, or DB2 workspaces".