Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

At IU, how do I install the Oracle Database 11g Release 2 client for 64-bit Windows?

Note: This document explains how to install the Oracle Database 11g Release 2 client for 64-bit Windows. For 32-bit Windows, see At IU, how do I install the Oracle 11g release 2 client for 32-bit Windows?

To install and configure the Oracle Database 11g Release 2 client for 64-bit Windows, see the appropriate section below.

On this page:

Running Oracle client setup via direct download from Oracle's web site

Note: To install Oracle components, you must be logged into the computer as an administrator. Also, the following method requires a valid Oracle Technology Network (OTN) username and password. If you do not have a valid OTN username and password, register for a free Oracle Web account.

If you do have a valid OTN username and password:

  1. Go to Oracle Database Software Downloads.

  2. Click OTN License Agreement, read the license agreement, and then close the window.

  3. Select Accept License Agreement. You will see a notification thanking you for accepting the OTN License Agreement, and permitting you to download the software.

    Note: You will need 609 MB of free space on your hard drive before downloading this file.

  4. Scroll down to Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) . Click win64_11gR2_client.zip to download.

    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.

  5. Save the file win64_11gR2_client.zip to your computer.

  6. Navigate to the file, right-click it, and then select Extract all.

  7. Select or create a folder location (e.g., c:\Oracle11gR2 Client 64bit) for the extracted files, and perform the extraction.

  8. Once all zipped files have been extracted, navigate to the folder you specified in the previous step.

  9. To launch the Oracle Client Installer, in the same folder, enter the client directory, and then double-click setup.exe.

    If prompted, enter your Windows administrator username and password.

    You may need to minimize application windows to see the installer window. Also, it might take a while for the installer window to appear.

    You may also receive an Open File - Security Warning dialog box. If you do, click Run.

  10. When you are ready to install the Oracle client, continue with Client installation process below.

Back to top

Running Oracle client setup from IUware

Note: To install Oracle components, you must be logged into the computer as an administrator.

  1. Download Oracle Client 11g R2- 64-bit from IUware.

  2. If you are not logged into IUware, click Log in to access downloads and product keys, and then log in with your IU Network ID. If you're already logged in, skip this step.

  3. Under "Downloads", click Oracle11gR2Client64bit.exe.

  4. In the File Download - Security Warning dialog box, click Save, select a destination folder, and then click Save.

  5. Once the download is complete, go to the destination folder, and double-click Oracle11gR2Client64bit.exe to begin the installation.

  6. By default, the IUware installer will install the necessary files to c:\IUware Online\Oracle11gR2 Client 64bit. To install files in a different folder, click Browse... , and then select a different folder. To continue, click Install.

  7. After the IUware installer extracts the necessary files to the directory you specified, the Oracle Client installation should start automatically. If it does not, go to the folder you specified in the previous step, and then double-click setup.exe. The Oracle Client Installer may take a few minutes to open.

    Note: You may need to move the IUware installer window and other open windows to see the Oracle Client Installer window.

  8. When you are ready to install the Oracle client, continue with Client installation process below.

Back to top

Client installation process

To complete the client installation process, you need the following information:

  • System Identifier (SID) of the database: oed1prd
  • Full service name of the database: oed1prd.world (recommended)
  • Port number: 1521
  • Hostname of computer where database is located: dbserv.uits.indiana.edu

If you use the IU Data Warehouse, for configuration information, see Oracle client configuration information for the IU Data Warehouse below.

Note: This installation requires 705 MB of space. Also, if you have an Oracle Home environment variable set on your computer, remove it before starting the installation, or it will interfere with setting some paths for the installation.

After you have verified the information above with the database administrator:

  1. The Oracle Client Installer will load product information and present you with the Select Installation Type dialog box. Unless you want a different type of installation, select Custom, and then click Next.

  2. The Select Product Languages dialog box will appear with English already selected. To select other languages, click your preferred language in the box on the left, and then click > so the language appears in the box on the right. After selecting the languages, click Next.

  3. In the Specify Installation Location dialog box, the installer will provide default file locations for you, but you can enter an alternate path in the available boxes, or click Browse... to navigate to alternate locations. The first file location is for an Oracle Base directory for files related to configuration and software. Choose or create a directory (e.g., c:\Oracle11gR2).

    The second file location is for the Oracle Home directory for software files. The path should begin with your selected Oracle Base directory (e.g., c:\Oracle11gR2\product\11.2.0\client_1).

    Note: Do not use an existing Oracle Home directory. If an existing Oracle Home directory is defaulted, choose a different location.

    When you are ready to continue, click Next.

  4. In the Available Product Components dialog box, select the following components:

    • Oracle Java Client
    • SQL*Plus
    • Oracle JDBC/THIN Interfaces
    • Oracle Call Interface (OCI)
    • Oracle Net
    • Oracle Programmer
    • Oracle SQL Developer (optional)
    • Oracle Connection Manager
    • Oracle ODBC Driver
    • Oracle Objects for OLE
    • Oracle Provider for OLE DB
    • Oracle Data Provider for .NET
    • Oracle Providers for ASP.NET

    Note: The SQL*Plus GUI application and SQL*Plus Worksheet are no longer available in Oracle 11g. If you don't want to use SQL*Plus from the command line, you should investigate SQL Developer as an alternative.

    When you're finished, click Next.

  5. In the Perform Prerequisite Checks dialog box, the installer will verify that your environment meets the minimum requirements for installing and configuring the products you have chosen.

  6. In the Summary dialog box, verify the installation, and then click Finish.

    The Install Product dialog box will prepare, copy, and set up files, configure the installation, and then proceed to the next dialog box.

  7. In the Finish dialog box, you should see "The installation of Oracle Client was successful". Click Close.

  8. To finish the installation, continue with Configuring Oracle Net below.

    To configure the Oracle Net client at a later time, continue with Adding new database services when you are ready.

Back to top

Configuring Oracle Net

Note: If you have TNS_ADMIN set in the variables on your computer, and have a tnsnames.ora file at that location, that file will be updated during the following configuration instead of a tnsnames.ora file in your Oracle Home network admin directory.

  1. In the Oracle Net Configuration Assistant: Welcome dialog box, make sure that Perform typical configuration is not selected, and then click Next.

    Note: If you cannot see the Oracle Net Configuration Assistant: Welcome dialog box, move the Configuration Assistants dialog box.

  2. In the Oracle Net Configuration Assistant: Naming Methods Configuration dialog box, make sure "Local Naming" is displayed in the "Selected Naming Methods" box, and then click Next.

  3. Enter the 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 service name, check with the database administrator.

  4. Select TCP, and then click Next.

  5. Enter the hostname (for oed1prd , the hostname is dbserv.uits.indiana.edu ). Unless otherwise specified, leave 1521 as the port number, and then click Next.

  6. Select Yes, perform test, and then click Next.

    Note: If the login test fails, select Change Login, enter your correct user information, and then try again. When the test is successful, click Next.

  7. For the name of the new Net service, UITS recommends using oed1prd.world . Enter the name, and then click Next.

    Note: Using a name without a domain (e.g., oed1prd instead of oed1prd.world) can cause connection problems. Alternatively, you may reuse the service name you entered in step 4 above (e.g., oed1prd.uits.indiana.edu).

  8. To configure another Net service name, select Yes, and then follow steps 4 through 8 above. Otherwise, select No, and then click Next.

  9. Once you have configured all your Net service names, click Next twice, and then click Finish.

  10. In the Finish dialog box, you will see "The installation of Oracle Client was successful". Click Close.

After following the steps above, you are finished setting up the Oracle client. You may want to continue to one of the following sections:

Back to top

Adding new database services

Note: If you have TNS_ADMIN set in the environment variables on your computer, and have a tnsnames.ora file at that location, that file will be updated during the following configuration instead of a tnsnames.ora file in your Oracle Home network admin directory.

To set up an Oracle client connection to an Oracle database on another computer:

  1. From the Windows Start menu, select All Programs, then Oracle - OraClient11g_home1, and then Configuration and Migration Tools. Then, click Net Configuration Assistant.

  2. Select Local Net Service Name Configuration, and then click Next.

  3. Select Add, and then click Next.

  4. Enter the 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 service name, check with the database administrator.

  5. Select TCP, and then click Next.

  6. Enter the hostname (for oed1prd , the hostname is dbserv.uits.indiana.edu ). Unless otherwise specified, leave 1521 as the port number, and then click Next.

  7. Select Yes, perform a test, and then click Next.

    Note: If the login test fails, select Change Login, enter your correct user information, and then try again. When the test is successful, click Next.

  8. For the name of the new Net service, UITS recommends using oed1prd.world . Enter the name, and then click Next.

    Note: Using a name without a domain (e.g., oed1prd instead of oed1prd.world) can cause connection problems. Alternatively, you may reuse the service name you entered in step 4 above (e.g., oed1prd.uits.indiana.edu).

  9. To configure another Net service name, select Yes, and then follow steps 4 through 8 above. Otherwise, select No, and then click Next.

  10. Once you have configured all of your Net service names, click Next, and then click Finish.

Back to top

Connecting to Oracle with SQL*Plus

Note: The SQL*Plus GUI application and SQL*Plus Worksheet are no longer available in Oracle 11g. If you don't want to use SQL*Plus from the command line, you should investigate SQL Developer as an alternative.

To connect to Oracle with SQL*Plus:

  1. From the Windows Start menu, select All Programs, then Oracle - OraClient11g_home1, and then Application Development. Then, click SQL*Plus.

  2. At the command prompt, enter your Oracle username followed by  @ , and then the Net service name you configured for the database connection. For oed1prd, this may be oed1prd.world or oed1prd.uits.indiana.edu, so you would enter  username@oed1prd.world  or  username@oed1prd.uits.indiana.edu . Click Enter.

  3. When prompted, enter your password, and then click Enter.

After completing the steps above, you will be in the SQL*Plus command shell environment. If you would like to change your password, see How do I change my Oracle password using SQL*Plus?

Back to top

Starting SQL Developer the first time

Note: The first time you open SQL Developer, you must specify a path to the java executable file (java.exe ).

  1. From the Windows Start menu, select All Programs, then Oracle - OraClient11g_home1, and then Application Development. Then, click SQL Developer.

  2. In the Oracle SQL Developer dialog box, you'll see "Enter the full pathname for java.exe ". Click Browse, and navigate to java.exe in the jdk\bin directory in your ORACLE_HOME directory (e.g., c:\Oracle11gR2\product\11.2.0\client_1\jdk\bin\java.exe).

  3. After entering the path, click OK. SQL Developer should start.

Back to top

Configuring and locating an ODBC data source

Programs that use Open Database Connectivity (ODBC) to connect to remote databases must have a way to identify the type of database and the computer to which they are connecting. This is accomplished through an ODBC data source, which associates a name with some database connection information. With Oracle, the database connection information is the same as the name of the Oracle Net service you set up when configuring the Oracle client.

  1. From the Windows Start menu, click All Programs, then Oracle - OraClient11g_home1, then Configuration and Migration Tools, and then Microsoft ODBC Administrator.

  2. Enter a Windows administrator username and password.

  3. At the top of the ODBC Data Source Administrator window, select the System DSN tab, and then click Add... .

  4. From the list of drivers, select Oracle in OraClient11g_home1, and then click Finish.

  5. Enter your information in the window that appears, and then click OK.

    The following example will create an Oracle ODBC data source for the oed1prd database on dbserv.uits.indiana.edu :

    Field Explanation Example
    Data source name User-specified name by which you will refer to this ODBC data source oed1prd_ora
    Description Not required; just a phrase reminding you why you created this ODBC data source Oracle ODBC for Oed1prd database on dbserv.uits.indiana.edu
    TNS Service name The Oracle Net service name you created for the database to which you want to connect oed1prd.world or oed1prd.uits.indiana.edu
    User name This is usually left blank; you will be prompted for this later when you make an ODBC connection to the database.  

  6. The ODBC data source you added will now appear in your System DSN list. Click OK to finish your ODBC configuration.

Back to top

Oracle client configuration information for the IU Data Warehouse

Note: The following information is only for IU Data Warehouse users.

You can use the following configuration information when configuring Oracle Net to connect to the IU Data Warehouse:

For Development (dss1dev)

  • Database service name: dss1dev.uits.indiana.edu
  • Host computer: iedssdev.uits.indiana.edu
  • Port number: 1521 (default)
  • Net service name: dss1dev.uits.indiana.edu (This is also the service name when you create an ODBC data source.)

For Test (dss1tst)

  • Database service name: dss1tst.uits.indiana.edu
  • Host computer: esdbd99.uits.iupui.edu
  • Port number: 1521 (default)
  • Net service name: dss1tst.uits.indiana.edu (This is also the service name when you create an ODBC data source.)

For Production (dss1prd)

  • Database service name: dss1prd.uits.indiana.edu
  • Host computer: esdbd100.uits.indiana.edu
  • Port number: 1521 (default)
  • Net service name: dss1prd.uits.indiana.edu (This is also the service name when you create an ODBC data source.)

Back to top

This is document azoc in domain all.
Last modified on February 19, 2013.

I need help with a computing problem

  • 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.

I have a comment for the Knowledge Base

  • 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.