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 for Windows XP?

Note: On Windows 7 machines, UITS strongly recommends using Oracle 11g release 2, as this is the earliest version of Oracle that is certified for Windows 7. See At IU, how do I install the Oracle 11g release 2 client for 32-bit Windows? or At IU, how do I install the Oracle Database 11g Release 2 client for 64-bit Windows?

Note: Following are instructions for installing the Oracle 10g client release 2 on Windows XP. For other versions of 10g, see At IU, how do I install the Oracle 10g client release 2 for Windows Vista?

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

Running the Oracle client setup by downloading directly from Oracle's web site

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 475 MB 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 Oracle Client 10g R2 - Windows XP.

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

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

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

  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
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, 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 the 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. 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. You will be prompted to select a network protocol. Select TCP, and then click Next.

  6. Enter the hostname when prompted. For oed1prd, enter dbserv.uits.indiana.edu . Unless specified otherwise, leave the port number as the default port, 1521. To continue, 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. You will be prompted to enter a name for the net service you just created; UITS recommends using oed1prd.world . 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. 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. Select Local Net Service Name Configuration, and then click Next.

  3. Select Add, and then click Next.

  4. You will be prompted to enter the service name. 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. You will be prompted to select a network protocol. Select TCP, and then click Next.

  6. Enter the hostname when prompted. For oed1prd, the hostname is dbserv.uits.indiana.edu . Unless specified otherwise, leave the port number as the default port, 1521. To continue, 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. You will be prompted to enter a name for the net service you just created; UITS recommends using oed1prd.world . 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. 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., oed1prd.world or oed1prd.uits.indiana.edu). 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. Select Administrative Tools, and then select Data Sources (ODBC).

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