At IU, how do I download and install the Oracle 12c client for Windows?

On this page:


Downloading Oracle 12c for Windows

At Indiana University, to download the Oracle 12c client for Windows, use either of the following methods:

For either download method, you must be logged into your computer as an administrator.

Note:
Indiana University policy Security of Information Technology Resources (IT-12) requires that you normally refrain from running your Windows computer as an administrator. For more, see What is the principle of least privilege?

Downloading the client directly from Oracle's website

To download the Oracle client directly from Oracle's website:

  1. Go to Oracle Database Software Downloads.
  2. Under "Oracle Database 12c Release 1", below "(12.1.0.2.0) - Enterprise Edition", to the far right of "Microsoft Windows x64 (64-bit)", click See All.
  3. Click OTN License Agreement, read the license agreement, and then close the window.
  4. Select Accept License Agreement. You will see a notification thanking you for accepting the OTN License Agreement and permitting you to download the software.
  5. Scroll down to the appropriate Oracle client for your operating system:
    • 32-bit: Under "Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)", click winnt_12102_client32.zip. This file requires 826.1 MB of free space on your hard drive.
    • 64-bit: Under "Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64)", click winx64_12102_client.zip. This file requires 846.3 MB of free space on your hard drive.

    You may be prompted to enter a valid OTN username and password. Once you have done so, you will see the "File Download" dialog box. If you do not have an OTN username and password, see the instructions for getting one above.

  6. Save the file.
  7. In Windows, navigate to the file, right-click it, and then select Extract all.
  8. Select a destination folder for the extracted files, and then perform the extraction.
  9. To launch the Oracle Client Installer, go to the destination folder, open the client directory, and then double-click setup.exe (the Oracle 12c setup file).

    At this point:

    • Windows may prompt you for an administrator username and password. Enter an administrator username and password to proceed.
    • Windows may present an "Open File - Security Warning" dialog box. Click Run to proceed.

    It may take a minute for the "Oracle Client Installer" window to appear. To see it, you may need to minimize any other application windows that are open.

When you are ready to configure the Oracle client, follow the instructions in the next section.

Downloading the client from IUware

To download the Oracle client from IUware:

  1. Go to Oracle Client 12c and select the Oracle version that corresponds to your operating system (i.e., 32-bit or 64-bit).
  2. If you see a button that says Log in for access, click it.
    • If you're not already logged into the IU Central Authentication Service (CAS), enter your IU username and passphrase, and then click LOGIN.
    • If you're already logged into IU CAS, proceed to the next step.
  3. Under "DOWNLOADS", click the .exe file listed (either Oracle 12c Client 32-bit.exe - 826.1 MB for 32-bit, or Oracle 12c Client 64-bit.exe - 853 MB for 64-bit).
  4. In the "File Download - Security Warning" dialog box, click Save, select a destination folder, and then click Save.
  5. You may see a warning similar to "Oracle 12c Client . . . is not commonly downloaded and could harm your computer." It is safe to ignore this warning and close the dialog box.

  6. When the download is complete, to open the IUware installer, go to the destination folder, and then double-click the Oracle .exe file you just downloaded.
  7. You'll see an "Open File - Security Warning" dialog box. Click Run.
  8. A "7-Zip self-extracting archive" dialog box will open. For "Extract to:", either accept the default (e.g., c:\username\Downloads), or change to another directory to which to extract the contents of this file. Click Extract. The extraction will take a few minutes.
  9. In the extraction directory you specified above, double-click the folder called Oracle 12c Client 32-bit or Oracle 12c Client 64-bit.
  10. Double-click the client folder.
  11. Double-click the setup file (of type "Application", not "Configuration Settings") to start the installation process.
  12. It may take a minute for the "Oracle Client Installer" window to appear. To see it, you may need to minimize any other application windows that are open.

When you are ready to configure the Oracle client, follow the instructions in the next section.

Configuring Oracle Net

Note:
If you have the TNS_ADMIN environment variable set on your workstation and have a tnsnames.ora file stored there, following these instructions will update that file instead of the tsanames.ora file in your Oracle Home network administrator directory.
  1. If you cannot see the "Oracle Net Configuration Assistant: Welcome" dialog box, move the "Oracle Client Installer" dialog box.
  2. In the "Oracle Net Configuration Assistant: Welcome" dialog box, click Next.
  3. In the "Oracle Net Configuration Assistant: Listener Configuration" dialog box, accept the default "LISTENER" name. Enter your OTN username and password (for details, see above), and then click Next.
    1. If it's not already selected, select TCP, and then click Next.
    2. Select Use the standard port number of 1521, and then click Next.
    3. If you see a "Windows Security Alert" dialog box:
      • Check Domain networks, such as a workplace network.
      • Check Private networks, such as my home or work network.
      • Click Allow access.
    4. When asked "Would you like to configure another listener?", select No, and then click Next.
    5. You will see the confirmation message "Listener configuration complete." Click Next.
  4. In the "Oracle Net Configuration Assistant: Naming Methods Configuration" dialog box, select Yes and then click Next.
  5. Make sure the "Selected Naming Methods" box has Local Naming, and then click Next.
  6. Enter the full service name, which is the database SID followed by an extension (e.g., oed1prd.uits.indiana.edu), and then click Next. If you do not know the full service name, contact the database administrator.
  7. Select TCP, and then click Next.
  8. Enter your hostname (for oed1prd, the hostname is dbserv.uits.indiana.edu). Unless otherwise specified, leave 1521 as the port number, and then click Next.
  9. Select Yes, perform test, and then click Next.

    If the login test fails, select Change Login, enter your user information, and try again.

    When the test is successful, click Next.

  10. UITS recommends using the name oed1prd.world as the name for the new net service. Alternatively, if you wish, you can use the same name as the SID and extension that you entered in step 6 above (e.g., oed1prd.uits.indiana.edu). Enter the name, and then click Next.
    Note:
    Entering a service name without a domain (e.g., oed1prd instead of oed1prd.world) can cause connection problems.
  11. If you want to configure another net service name, select Yes, and then repeat steps 6 through 10 above. Otherwise, select No, and then click Next.
  12. Once you have configured all of your net service names, you will see a series of confirmation messages. Click Next twice, and then click Finish.
  13. In the "Finish" dialog box, you will see the message "The installation of Oracle Client was successful". Click Close.

This is document agpr in the Knowledge Base.
Last modified on 2017-07-10 14:18:06.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.