Indiana University
  •  
  •  
  •  

At IU, how do I install the Oracle 10g client?

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. For different versions of Oracle 10g, see:

For instructions on how to install and configure the Oracle 10g client, see the appropriate section below:

Running the Oracle client setup from the CD

To run the setup program from the CD:

  1. Log into your Windows 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?

  2. Insert the Oracle client CD and wait for the Oracle Database 10g Client - Autorun window to open.

  3. If it doesn't start automatically, double-click My Computer, and then double-click the Oracle10g icon.

  4. Skip to the section entitled Client installation process.

Back to top

Running the Oracle client setup from IUware

If you do not have an Ethernet connection, run the Oracle client setup from a CD instead of using this method.

  1. Visit Oracle Client 10g.

  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 Oracle10gClient.exe.

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

  5. After the download is complete, double-click the Oracle10gClient.exe file that was saved to your computer. A window will open called Oracle 10g Client (10.1.0.2). Once the installation program has loaded, click Next.

  6. By default, the install program will install the necessary files to C:\IUware Online\Oracle 10g Client (10.1.0.2). If you would like 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 automatically begins as the Oracle Universal Installer runs. This will take a few minutes.

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

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

Back to top

Client installation process

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

Information needed Example (for Oed1prd)
Version of the database to connect to (8 or 8i or later) 8i or later
Name or System Identifier (SID) of the database and the full service name of the database SID = oed1prd
Service name = oed1prd.world (recommended)
Port number The default port is 1521.
Name of the host computer where the database is located dbserv.uits.indiana.edu

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

Verify the information above with the database administrator before proceeding. When you are ready, proceed with the installation:

  1. If the CD ran automatically, or you clicked the Oracle10g icon, proceed with the next step. If you clicked setup.exe, skip ahead to step 3.

  2. From the window that opens, choose Install/Deinstall Products.

  3. From the Oracle Universal Installer, choose Next.

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

  5. The installer will load the product information and then present you with the Installation Types window. Unless you know that you want another type of installation, select Custom. Once you have selected your installation type, click Next.

  6. In the Available Product Components window, in the following order, select:

    • Oracle Network Utilities
    • SQL*Plus
    • Oracle JDBC/OCI Interfaces
    • Oracle Call Interfaces
    • Oracle Windows Interfaces

    In the following order, deselect:

    • Oracle Services For Microsoft Transaction Server
    • Oracle One-Off Patch Installer

    Make sure that Enterprise Manager 10g Java Console is selected.

  7. When you have finished making your selections, click Next.

  8. The product information may take a couple of minutes to load. When the information is finished loading, a summary of the installation information will be displayed. Check the summary information and 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. In the Oracle Net Configuration Assistant:Welcome window, you have two options:

    1. To see if your client can be configured automatically, select Perform typical configuration. 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", click Next, then Finish. You are done with this section.
    2. If the previous step fails, deselect Perform typical configuration. Click Next, and then continue with step 2.

  2. Ensure that the Naming Methods Configuration window displays Local Naming in the box labeled "Selected Naming Methods". Click Next.

  3. You will be prompted for 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.

  4. Enter your hostname. 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.

  5. Choose Yes, perform test, and then select Next.

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

  6. Enter a net service name; UITS recommends using the name 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 3 above (e.g., oed1prd.uits.indiana.edu).

  7. If you would like to configure another net service name, select Yes and follow steps 2 through 6 again. Otherwise, select No, and then click Next.

  8. Once you have configured all of your net service names, click Next twice, then Finish, and then Exit. When asked if you really want to exit, select 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

Use this section if you need to set up an Oracle client connection to an Oracle database on another computer:

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

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

  3. Select Add, and then choose Next.

  4. You will be prompted for 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. Make sure that TCP is selected, and then click Next.

  6. Enter your hostname. For Oed1prd, the hostname is dbserv.uits.indiana.edu. Unless you are instructed otherwise, select Use the standard port number of 1521. To continue, click Next.

  7. Choose Yes, perform test, and then select Next.

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

  8. Enter a net service name; UITS recommends using the name 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. If you would like to configure another net service name, select Yes, then Next, and then follow steps 1 through 8 again. Otherwise, select No, and then click Next.

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

Back to top

Connecting to Oracle with SQL*Plus

To connect to Oracle with SQL*Plus:

  1. From the Start menu, select Programs and then Oracle - OraClient10g_home1.

  2. From the Oracle menu, select Application Development, and then SQL Plus.

  3. Enter your Oracle username and password in the spaces provided.

  4. In the box labeled "Host String:", enter the name you specified when configuring the Oracle Net Service (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. 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 Settings, and then Control Panel.

  2. In Windows XP, 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

IU Data Warehouse configuration information

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: iedsstst.uits.indiana.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: iedss.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