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 10g client release 2?

Note: This document explains how to install the Oracle 10g client release 2. For instructions for other releases, see:

For Oracle 10g client release 2, see the appropriate section below:

Running the Oracle client setup by downloading directly from Oracle's web site (for Microsoft Windows)

Note: This method requires a valid Oracle Technology Network (OTN) username and password. If you do not have a valid OTN username and password, visit the Oracle Technology Network web page. Click Register for a free Oracle Web account in the upper right corner, and follow the on-screen instructions.

To run the Oracle client setup by downloading directly from Oracle's web site:

  1. Visit the Oracle web site.

  2. Read the OTN License Agreement by clicking OTN License Agreement. When finished, close the OTN License Agreement 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. In the section titled "Oracle Database 10g Client Release 2 (10.2.0.1.0)", click 10201_client_win32.zip to download; you will need 475MB of space on your hard drive for this download. Enter a valid OTN username and password.

  5. In the File Download dialog box, save the 10201_client_win32.zip file to a location you will remember on your local hard drive.

  6. Navigate to the 10201_client_win32.zip file you saved, right-click the file, and then scroll to and click Extract all. The files inside the .zip file will be extracted to the location you choose.

  7. Select or create a folder location (e.g., C:\Oracle 10g Client (10.2.0.1)) for the extracted zipped files.

  8. Once all zipped files have been extracted, navigate to the folder you created.

  9. Navigate to the \client\install directory and double-click the file oui.exe to launch the Oracle Universal Installer.

Back to top

Running the Oracle client setup from IUware

  1. Visit IUware at: http://iuware.iu.edu/
  2. In the column on the left, choose Database.

  3. Select Oracle 10g R2 Client for Windows (not Vista).

  4. Next to "Available for Download", click Login. If prompted, enter your IU Network ID, and then click Download.

  5. After the download is complete, double-click the Oracle10gR2ClientWin32.exe file. A window called Oracle 10g Client (10.1.0.2) will open. Click Next.

  6. By default, the install program will install the necessary files to C:\IUware Online\Oracle 10g R2 Client Win 32. To change to a different folder, click Browse... . To continue, click Install.

  7. The installation program will extract the necessary files to the directory you specified. When it is complete, the installation should automatically begin as the Oracle Universal Installer runs; if not, go to C:\IUware Online\Oracle 10g R2 Client Win 32\client and double-click setup.exe. This will take a few minutes.

Note: You may need to move the installer window to see the configuration window.

Back to top

Client installation process

Note: Before continuing, you need the following information:

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

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

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

  1. From the Oracle Universal Installer dialog box, click Next.

  2. The installer will load product information and present you with the Installation Types dialog box. Unless you know you want another type of installation, select Custom, and then click Next.

  3. The installer will provide default file locations for you, but you can enter an alternate path in the available box or click Browse... to navigate to an alternate location. When you are ready to continue, click Next.

  4. In the Available Product Components dialog box, check Show all components, including required dependencies. Then use the checkboxes to select, in the following order, the components listed:

    • Oracle Net 10.2.0.1.0
    • SQL*Plus 10.2.0.1.0
    • Oracle JDBC/THIN Interfaces 10.2.0.1.0
    • Oracle Call Interface (OCI) 10.2.0.1.0
    • Oracle Windows Interfaces 10.2.0.1.0
    • Enterprise Manager 10g Java Console 10.2.0.1.0

  5. In the Available Product Components dialog box, deselect Oracle Services For Microsoft Transaction Server 10.2.0.1.0.

  6. Click Next to continue.

    In the Product-Specific 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. You need to manually verify and confirm the items that are flagged with warnings and items that require manual checks.

  7. Once you have verified that all checks have passed, click Next.

  8. The Summary dialog box will display a summary of the installation information. Verify that this information is correct, and then click Install.

  9. To finalize the installation, you must configure Oracle Net. If you want to do this now, proceed to the next section. If you want to configure the Oracle Net client later, follow the instructions in the section Adding new database services.

Back to top

Configuring Oracle Net

  1. The Configuration Assistants dialog box will appear. If you cannot see the Oracle Net Configuration Assistant: Welcome dialog box, move the Configuration Assistants box.

  2. In the Oracle Net Configuration Assistant: Welcome dialog box, you have two options:

    • To see if your client can be configured automatically, select Perform typical configuration, and then click Next. If the text now says "Welcome to the Oracle Net Configuration Assistant" and "The Assistant has determined that your client can use the easy connect naming method for identifying the database", click Next, and then Finish. You are done with this section.
    • If the previous step fails, deselect Perform typical configuration. Click Next, and then continue with step 3.

  3. In the Oracle Net Configuration Assistant dialog box, make sure "Local Naming" is displayed in the box labeled "Selected Naming Methods". Click Next.

  4. You will be prompted to enter the service name. This is the database SID followed by an extension (e.g., oed1.world). Enter the full service name, and then click Next.

    Note: If you do not know the service name, check with the database administrator.

  5. You will be prompted to select a network protocol. Select TCP, and then click Next.

  6. Enter the hostname when prompted. For oed1, enter dbserv.uits.indiana.edu . Unless specified otherwise, leave the port number as the default port, 1521. To continue, click Next.

  7. Click the radio button next to 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. You will be prompted to enter a name for the net service you just created. UITS recommends using the name you supplied in step 4 (e.g., oed1.world ). Click Next.

  9. To configure another net service name, select Yes and 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. The End of Installation dialog box will appear; click Exit. When asked if you really want to exit, click Yes.

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

If you need to set up an Oracle client connection to an Oracle database on another computer:

  1. From the Start menu, select All Programs, then Oracle - OraClient10g_home, then Configuration and Migration Tools, and then Net Configuration Assistant.

  2. Click the radio button next to Local Net Service Name Configuration, and then click Next.

  3. Click the radio button next to Add, and then click Next.

  4. You will be prompted to enter the service name. This is the database SID followed by an extension (e.g., oed1.world ). Enter the full service name, and then click Next.

    Note: If you do not know the service name, check with the database administrator.

  5. You will be prompted to select a network protocol. Select TCP, and then click Next.

  6. Enter the hostname when prompted. For oed1, the hostname is dbserv.uits.indiana.edu . Unless specified otherwise, leave the port number as the default port, 1521. To continue, click Next.

  7. Click the radio button next to 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. You will be prompted to enter a name for the net service you just created. UITS recommends using the name you supplied in step 4 (e.g., oed1.world ). Click Next.

  9. To configure another net service name, select Yes and 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.

Back to top

Connecting to Oracle with SQL*Plus

To connect to Oracle with SQL*Plus:

  1. From the Start menu, select All Programs, then Oracle - OraClient10g_home, then Application Development, and then click SQL Plus.

  2. Enter your Oracle username and password.

  3. In the "Host String:" field, enter the name you specified when configuring Oracle Net (e.g., oed1.world ). Click OK.

After completing the steps above, you will be in the SQL*Plus command line interface environment. Verify that the SQL*Plus Release number is 10.2.0.1. To change your password, see How do I change my Oracle password using SQL*Plus?

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. To configure and locate an ODBC data source:

  1. From the Start menu, click Control Panel, or Settings and then Control Panel.

  2. In Windows XP, select Administrative Tools, and then select Data Sources (ODBC). In Windows 98, NT, and 2000, select ODBC Data Sources, ODBC, or ODBC Data Sources (32-bit).

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

  4. From the list, select Oracle in OraClient10g_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 Oed1 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 oed1_ora
    Description Not required; just a phrase reminding you why you created this ODBC data source Oracle ODBC for Oed1 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 oed1.world
    User name 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.ucs.indiana.edu
  • Host computer: iedssdev.uits.indiana.edu
  • Port number: 1521 (default)
  • Net service name: dss1dev.ucs.indiana.edu (This is also the service name when you create an ODBC data source.)

For test (dss1tst)

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

For production (dss1prd)

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

Back to top

This is document awdw in domain all.
Last modified on November 10, 2009.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.