ARCHIVED: How do I access my database on the IU Research Database Complex using the Oracle client for Windows XP?

Following are instructions for accessing your RDC database using the Oracle client for Windows XP.

• Download the Oracle client from IUware
• Install the Oracle client
• Configure Oracle Net
• Connect to Oracle with SQL*Plus
• Getting help

Download the Oracle client from IUware

The Oracle client for Windows XP is available free of charge to Indiana University students, faculty, and staff via IUware:

1. Go to IUware. On the left, click Databases.
2. Under "Databases", click Oracle 10g R2 Client.
3. Under "Installation Packages", click Oracle Client 10g R2 Windows XP.
4. Click Log in to access downloads and product keys. Log in with your IU Network ID.
5. Under "Downloads", click Oracle10gR2ClientWin32.exe-471.0 MB. Choose to save the file to your computer.

Install the Oracle client

After you've downloaded the client software, you must install it on your computer:

1. On your computer, find the Oracle10gR2ClientWin32.exe file you downloaded from IUware, and double-click it to begin the installation.
2. In the "Oracle 10g R2 Client Win 32" window, choose where to save the program files. By default, the installation saves files to:

     C:\IUware Online\Oracle 10g R2 Client Win 32

   To choose a different locations, click Browse.... To extract the files and start the installation, click Install.

   Note: The installation program takes a few minutes to extract files to the directory you specified. When it's complete, the Oracle Universal Installer should automatically run. If it doesn't, go to the directory you specified (e.g., C:\IUware Online\Oracle 10g R2 Client Win 32), and in the client folder, double-click the setup.exe file.

3. In the "Oracle Universal Installer" window, click Next.
4. Under "Select Installation Type", choose Custom, and then click Next
5. Under "Specify Home Details", select a name for the installation and the full path where you want to install the client. The default path is:

     C:\oracle\product\10.2.0\client_1

   Note: You may click Browse... to select an alternate path, but UITS recommends keeping the default path.

6. Click Next to continue.
7. Under "Available Product Components", near the bottom, click the checkbox to select Show all components, including required dependencies.
8. From the list of available product components, use the checkboxes to select these components, in the following order:
   • 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
9. In the list of available product components, click to deselect (i.e., not install) Oracle Services For Microsoft Transaction Server 10.2.0.1.0 (found under "Oracle Windows Interfaces 10.2.0.1.0").
10. Click Next. The installer will verify that your environment meets the minimum requirements for installing and configuring the products you selected. You must manually verify and confirm any items that are flagged with warnings and items that could not be verified automatically. For details about performing these checks, click the item and review the details in the box at the bottom of the window.

    When all requirements are verified, click Next.

11. Under "Summary", verify the installation information, and then click Install.

After the components are installed, the Oracle Universal Installer will guide you through configuring and starting the components you selected. For instructions, see the next section.

Configure Oracle Net

Note: Before continuing, you need the following pieces of information:

• The name of the host computer where the database is located:

    libra45.uits.iu.edu

• The System Identifier (SID) of the database and its full service name; to find these, see the RDC Oracle Database Welcome letter you received in email after creating your account

To begin configuring the products you installed:

1. In the Oracle Universal Installer window, under "Configuration Assistants", you'll see the Oracle Net Configuration Assistant has started and is in progress. Beneath this window (where you may not be able to see it at first), you'll find the "Oracle Net Configuration Assistant" dialog box. You may have to move the "Oracle Universal Installer" window to reveal the "Oracle Net Configuration Assistant" dialog box.
2. In the "Oracle Net Configuration Assistant" dialog box, to see if your client can be configured automatically, click the checkbox to select Perform typical configuration, and then click Next:
   • If you see the messages, "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. Skip to step 11.
   • If this step fails, deselect Perform typical configuration, and then click Next and continue with step 3.
3. Under "Selected Naming Methods", make sure "Local Naming" is displayed in the box, 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., IUGP.IU.EDU). Enter the full Service Name, and then click Next. If you do not know the Service Name, email the High Performance Systems group.
5. You will be prompted to enter the Network Protocol. Select TCP, and then click Next.
6. You will be prompted to enter the Host Name (use libra45.uits.indiana.edu). Leave the port number as the default port (1521). Then click Next.
7. Click the radio button to select Yes, perform test, and then click Next. If the login test fails, select Change Login, enter your correct user information, and try again. Click 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 Service Name you supplied above (e.g., IUGP.IU.EDU). Then, click Next.
9. If you want 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. Under "End of Installation", click Exit. When asked if you really want to exit, click Yes.

Connect to Oracle with SQL*Plus

See Access your MySQL database on the IU Research Database Complex

Getting help

If you need help connecting to your Oracle database, email the High Performance Systems group.