Downloading and Installing Oracle Client

This document describes the installation process for the Oracle Client software. The University of Wisconsin-Madison doesn't require any particular version installation of the Oracle client. References to specific versions have been removed.

Downloading and installing the 19c Oracle client (Recommended)

The clients are stored on the UW Box service, which may require your NetID credentials.

Oracle Client 19c 

To install, review the client installation instructions located in the Oracle Client Box Folder.

Final Setup Instructions

  1. Save UW TNSnames.ora file to the correct location in the Oracle directory: Adding, Editing, or Replacing Your TNSnames.ora File
  2. Set up ODBC connection (using either 32 or 64 bit as appropriate): Configuring an ODBC connection to InfoAccess in Windows . It is critical to name the Data Source Name in ODBC as "UW Data Warehouse" otherwise BA's Access files will give errors when connecting to InfoAccess. Test connection.
  3. Test in Oracle.


Keywords:
oracle odbc database db driver installation install download 11g box 12c 19c
Doc ID:
91189
Owned by:
Help Desk KB Team in DoIT Help Desk
Created:
2019-04-19
Updated:
2024-08-15
Sites:
DoIT Contract Partner Support Help Desk, DoIT Departmental Support, DoIT Help Desk