How To Upgrade Oracle Client 11g To 12c In Windows

Downloading and Installing Oracle 12c Client

This document describes the installation process for the Oracle 12c Customer software. The University of Wisconsin-Madison doesn't require whatsoever particular version installation of the Oracle customer, only for best compatibility, it is recommended users install the 12c client. It is NOT recommended users running the Oracle 11g client update to 12c unless they are experiencing technical issues with the 11g client.

Downloading the Oracle 12c Client

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

1. Select on the post-obit detail(south) that you desire to download.

   • 32-bit version

   • 64-bit version
2. One time yous are in the Box environment, click on the download button on the summit right of the screen.

   Notation:

   • 32-bit Windows applications volition 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 yous are running 64-bit Windows vii but you plan to utilize a 32-bit re-create of MS Admission to connect to EPM, y'all should install the 32-bit version of the Oracle Client. If y'all intend to utilise both 64-bit and 32-bit applications to create ODBC connections, you will demand to install both clients.
3. When you lot are prompted to download the client, choose to Salve the file to an easily accessible location on your calculator'due south hard bulldoze.

   Annotation: The goose egg archive containing the client installer is large and may accept 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 annal containing the client installer on your figurer'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 binder called 'Client32' (or 'Client64'.). Double-click on the application labeled 'setup' to launch the installer programme.

   

4. On the kickoff installer screen choose 'Administrator' as the installation blazon.

   

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

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

   

7. On the 'Specify Installation Location' screen alter the default 'Oracle Base' location to C:\app\, and Software Location to C:\app\customer\product\12.2.0\client_1. Click 'Next >' to keep with the installation.

   
   The image below does non accept the right install paths. Please follow the install paths above.

   

8. The installer plan will check for prerequisites and initiate the installation process. One time the installation is complete, you will be taken to a summary screen.

Final Setup Instructions

1. Relieve UW TNSnames.ora file to the correct location in the Oracle directory: Adding, Edting, or Replacing Your TNSnames.ora File for InfoAccess


2. Set up up ODBC connectedness (using either 32 or 64 scrap every bit appropriate): Configuring an ODBC connexion to InfoAccess in Windows . It is critical to name the Data Source Name in ODBC every bit "UW Data Warehouse" otherwise BA's Admission files will give errors when connecting to InfoAccess. Examination connectedness.


3. Test in Oracle.

---

Keywords:	oracle odbc database db driver installation install download 11g box 12c Advise keywords	Doc ID:	91189
Owner:	Kyle A.	Group:	DoIT Help Desk
Created:	2019-04-19 09:41 CDT	Updated:	2021-03-09 17:00 CDT
Sites:	DoIT Help Desk
Feedback:	126 68   Annotate Suggest a new document

Source: https://kb.wisc.edu/helpdesk/page.php?id=91189

Posted by: shepardabse1969.blogspot.com

Share this post