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 11g release 2 client for 32-bit Windows?

Note: The following instructions are for 32-bit Windows. For 64-bit Windows, see At IU, how do I install the Oracle Database 11g Release 2 client for 64-bit Windows?

To install and configure the Oracle 11g release 2 client for 32-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.

Note: At Indiana University, the University Information Security Office (UISO) recommends that you normally refrain from running your Windows computer as an administrator. For more, see What is the principle of least privilege?

This method requires a valid OTN (Oracle Technology Network) username and password. If you do not have a valid OTN username and password, visit Oracle Database Software Downloads. At the top, click Sign In/Register for Account, and then follow the on-screen instructions.

If you do have a valid OTN username and password:

  1. Visit 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.

  4. Under "Oracle Database 11g Release 2", for "Microsoft Windows (32-bit)", click See All.

  5. Scroll down to "Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)". Click win32_11gR2_client.zip to download.

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

    Before continuing, 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.

  6. Save the file (win32_11gR2_client.zip).

  7. 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. In the folder you extracted the files to, open the client directory, and then double-click the Oracle 11g setup file (setup.exe) to launch the Oracle Client Installer. You may be prompted for a Windows administrator username and password before proceeding.

    If you receive an Open File - Security Warning dialog box, click Run.

    If you do not see the client installer, minimize application windows to see the installer window. It might take a minute for the installer window to appear.

  10. Proceed to Client installation process when you are ready to install the Oracle client.

Back to top


Running Oracle client setup from IUware

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

Note: At Indiana University, the University Information Security Office (UISO) recommends that you normally refrain from running your Windows computer as an administrator. For more, see What is the principle of least privilege?

  1. Go to Oracle Client 11g R2 - 32-bit.

  2. If there is a button that says Log in to access downloads and product keys, click this button and log in using your IU Network ID. This button will not display if you have already logged in.

  3. Under "Downloads", click Oracle11gR2Client32bit.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, double-click the Oracle11gR2Client32bit.exe file saved to your computer. The IUware installer will open.

  6. By default, the IUware installer will install the necessary files to c:\IUware Online\Oracle11gR2 Client 32bit. If you would like to change to a different folder, click Browse...  and select a different folder. To continue, click Install.

  7. The IUware installation program will extract the necessary files to the directory you specified. When it is complete, the Oracle Client installation should automatically start. If it does not, go to the folder you chose in the previous step and open the setup.exe file. The Oracle Client Installer may take a few minutes to open.

  8. Continue with the next section when you are ready to install the Oracle client.

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

Back to top


Client installation process

Note: To continue, you will need the following information:

Information needed Example
System Identifier (SID) of the database SID = oed1prd
Full service name of the database Service name = oed1prd.world (recommended)
Port number Default port = 1521
Name of host computer where database is located Host = dbserv.uits.indiana.edu

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

Note: If you have an Oracle Home environment variable set on your computer, remove this variable before starting the installation. It will interfere with setting some paths for the installation.

After verifying the above information 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. If you want to select other languages, click your preferred language in the box on the left, and then click > so that 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 will be 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 and 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. If an existing Oracle Home 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. SQL*Plus is now just a command shell tool. You may want to investigate SQL Developer as an alternative.

    The installation requires 705MB of space.

    After selecting the products, click Next.

  5. In the Perform Prerequisite Checks dialog box, the installer will verify that your environment meets all of the minimum requirements for installing and configuring the products you have chosen to install. If the checks are successful, the installation will automatically proceed to the next dialog box. If not, fix the flagged items before proceeding.

  6. Verify the installation information in the Summary dialog box and then click Finish.

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

  8. The Finish dialog box should show the message "The installation of Oracle Client was successful". Click Close.

  9. To finish the installation, configure Oracle Net. To configure the Oracle Net client at a later time, follow the instructions in Adding new database services at that time.

Back to top


Configuring Oracle Net

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.

  1. 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: Welcome dialog box, make sure that Perform typical configuration is not selected, and then click Next.

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

  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 your 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 test, and then click Next.

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

  8. UITS recommends using the name oed1prd.world as the name for the new net service. Enter the name, and then click Next.

    Note: Leaving just a name without a domain (e.g., oed1prd rather than oed1prd.world) can cause connection problems. You can also use the same name as the SID and extension that you entered in step 4 above (e.g., oed1prd.uits.indiana.edu).

  9. If you would like 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 twice, and then click Finish.

  11. In the Finish dialog box, you will see the message "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 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 your 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, click Change Login, enter your correct user information, and try again. Click Next when the test is successful.

  8. UITS recommends using the name oed1prd.world for the new net service. Enter the name, and then click Next.

    Note: Leaving just a name without a domain (e.g., oed1prd rather than oed1prd.world) can cause connection problems. You can also use the same name as the SID and extension that you entered in step 4 above (e.g., oed1prd.uits.indiana.edu).

  9. If you would like 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.

To connect to Oracle with SQL*Plus:

  1. From the 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 that was 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. When prompted, enter your password and click Enter.

  3. Click Enter. When prompted, enter your password and 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 that you attempt to open SQL Developer, you have to specify a path to the java executable file java.exe .

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

  2. You will get an Oracle SQL Developer dialog box with the message "Enter the full pathname for java.exe". Click Browse and browse to the java.exe file in the jdk\bin directory in your ORACLE_HOME directory (e.g., c:\Oracle11gR2\product\11.2.0\client_1\jdk\bin\java.exe). After the path is entered into the dialog box, click OK.

  3. SQL Developer should start. Setting the path will only need to be done the first time.

Back to top


Configuring and locating an ODBC data source

Programs that use 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. In the case of Oracle, the database connection information is simply the name of the Oracle Net service you set up when configuring the Oracle client.

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

  2. Provide a Windows administrator username and password.

  3. At the top of the ODBC Data Source Administrator window, select the tab labeled System DSN, 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 aznp in domain all.
Last modified on March 28, 2014.

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.