How to install Oracle 19c client for ConnectMaster manually

This article describe the manual installation for the Oracle 19c database client for use with ConnectMaster.

Installation

In the ConnectMaster installation package you find the Oracle 19c client install package.

• Open the Windows command line (cmd.exe) with administrator rights
• Change to the directory containing the setup.exe for the Oracle client. e.g.:
  

cd C:\temp\CM702_ora19c_x64_0205.1\oracle19c\client

• Run setup.exe with the following arguments

setup.exe "ORACLE_HOME_NAME=OraClient19c_ConnectMaster"

An "Oracle Universal Installer" window will shortly pop up. Then the main Oracle Client installation program will start.

• Choose custom installation

As the installation directory we suggest the following:

• Oracle Base: “C:\cm\oracle
• Software Directory: “C:\cm\oracle\product\19.0.0\client_1”

• Additional components to install:
  • Oracle Database Utilities
  • SQL*Plus
  • Oracle Net
  • Oracle ODBC Driver
  • Oracle Data Provider for .NET

• Finish the installation process.
• In the Oracle software directory under ../network/admin (e.g. C:\cm\oracle\product\19.0.0\client_1\network\admin ) if the file "tnsnames.ora" does not exist yet, create a text file with this name.
• Edit it to configure the connection properties to your desired destination database ( TNSNAMES.ORA File – The Complete Guide - databasestar.com )

Register the Oracle DataAccess.dll

• Open the Windows command line (cmd.exe) with administrator rights
• Change to the ConnectMaster assemblies directory. e.g.

  cd C:\cm\cm675\assemblies

• Register the dll using the following command. Make sure the software directory matches the one you configured above. e.g.:

  gacutil.exe -i "C:\cm\oracle\product\19.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll"

You should see "Assembly successfully added to the cache"