Skip to main content

How to install Oracle 19c client for ConnectMaster manually

Updated

 

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

 

Installation

Note:

Extraction of the software ZIP files and installation should NOT be run from a network path. Copy them to a local path beforehand!

 

Important:

Make sure you unpack the installation files to a short, local path that does NOT contain spaces!

e.g.: C:\temp\CM702_ora19c_x64_0205.1

 

Before extraction make sure the zip files are unblocked in the files properties.

 

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"

Related articles

Comments

0 comments

Please sign in to leave a comment.