Configuration Example: MineMarket with Oracle

MineMarket can be used with an Oracle database server.

System Requirements with Oracle

The following system requirements are specific to installations of MineMarket with Oracle.

Database Server

If Oracle is used, it may be hosted on a Unix server instead of a Windows machine.

The only supported Oracle version on the database server is Oracle 12c.

Each company or customer should manage their own tablespace policy to ensure that data-intensive applications like MineMarket never run out of space or have performance affected by tablespaces extending frequently.

MineMarket Application Server

Microsoft .NET Framework 2 and .NET Framework 4.8 should be installed before the Oracle Client is installed.

The 12c Oracle Client must be installed on the MineMarket Application Server.

OracleMTSRecoveryService must be installed on the MineMarket Application Server. OracleMTSRecoveryService is a part of the Oracle Data Provider for .NET (ODP.NET) and is included with the Oracle Client installer; however, it is not installed by default.

The Oracle.DataAccess.dll file must be copied from the Oracle 12c installation to the MineMarket installation folder.

If using the MineMarket Search Service, ensure that TNS_ADMIN has been added to the environment variables on the machine running the MineMarket Search Service (typically the MineMarket Application Server):

  1. From the Start menu, right-click Computer and select Properties. The System screen opens.
  2. Select Advanced system settings. The System Properties screen opens.
  3. On the Advanced tab, click Environment Variables. The Environment Variables screen opens.
  4. Create a new system variable with the variable name TNS_ADMIN. Set the variable value to the folder path of the tnsnames.ora file (for example, C:\\[path]\network\admin). Enter tnsping [listener name] at the command prompt to identify the folder path if required.
MineMarket Application Clients

Microsoft .NET Framework 2 and .NET Framework 4.8 should be installed before the Oracle Client is installed.

Every MineMarket Application Client must have the Oracle 12c Client installed.

The Oracle.DataAccess.dll file must be copied from the Oracle 12c installation to the MineMarket installation folder.