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.

Downloading and installing the 12c Oracle client

Downloading the 12c Oracle Client

The clients are stored on the UW Box service so you may be prompted to login with your NetID and password.

  1. Select on the following item(s) that you want to download.
  2. Once you are in the Box environment, click on the download button on the top right of the screen.
    • Note: 32-bit Windows applications will not work with Oracle's 64-bit ODBC driver. Therefore, users of 64-bit versions of Windows may need to install the 32-bit version of the Oracle Client if they intend to make ODBC connections with 32-bit applications. For instance, if you are running 64-bit Windows 7 but you plan to use a 32-bit copy of MS Access to connect to EPM, you should install the 32-bit version of the Oracle Client. If you intend to use both 64-bit and 32-bit applications to create ODBC connections, you will need to install both clients.
  3. When you are prompted to download the client, choose to Save the file to an easily accessible location on your computer's hard drive.
    • Note: The zip archive containing the client installer is large and may take several minutes to download.
  4. Once the download is complete, you can continue to the installation process.

Installing the Oracle 12c Client

  1. Locate the zip archive containing the client installer on your computer's hard drive.

  2. Right-click the zip archive and select 'Extract All...'. Windows will decompress the contents of the zip archive into a folder in the same location.

  3. Open the resulting folder called 'Client32' (or 'Client64'.). Double-click on the application labeled 'setup' to launch the installer program.

    image of the setup window

  4. On the first installer screen choose 'Administrator' as the installation type.

    image of the select_installation_type window

  5. Click 'Next >' on the language selection screen.

  6. Make sure "Use Windows Built-in Account" is selected, then click 'Next >'..

    image of the specify Oracle Home User window

  7. On the 'Specify Installation Location' screen change the default 'Oracle Base' location to C:\app\, and Software Location to C:\app\client\product\x.x.x\client_1. Click 'Next >' to continue with the installation.


    The image below does not have the correct install paths. Please follow the install paths above.

    image of the oracle32 folder directory

  8. click YES and then install
  9. The installer program will check for prerequisites and initiate the installation process. Once the installation is complete, you will be taken to a summary screen.

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