How do I access my database on the IU Research Database Complex using the Oracle client for Windows XP?The Indiana University Research Database Complex (
rdc.uits.iu.edu) supports research-related databases and data-intensive applications that require databases. The RDC supports Oracle and MySQL databases, and provides an environment (
rdcweb.uits.iu.edu) for database-driven web applications focusing on research.
Following are instructions for accessing your RDC database using the Oracle client for Windows XP.
On this page:
- 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:
- Go to IUware. On the
- Under "Databases", click
Oracle 10g R2 Client.
- Under "Installation Packages", click
Oracle Client 10g R2 Windows XP.
Log in to access downloads and product keys. Log in with your IU Network ID.
- 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:
- On your computer, find the
Oracle10gR2ClientWin32.exefile you downloaded from IUware, and double-click it to begin the installation.
- In the
Oracle 10g R2 Client Win 32window, 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
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
clientfolder, double-click the
- In the
Oracle Universal Installerwindow, click
- Under "Select Installation Type", choose
Custom, and then click
- 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:
Note: You may click
Browse...to select an alternate path, but UITS recommends keeping the default path.
- Under "Available Product Components", near the bottom, click the
checkbox to select
Show all components, including required dependencies.
- 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
- 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").
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
- Under "Summary", verify the installation information, and then
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:
- 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 Assistantdialog box. You may have to move the
Oracle Universal Installerwindow to reveal the
Oracle Net Configuration Assistantdialog box.
- In the
Oracle Net Configuration Assistantdialog box, to see if your client can be configured automatically, click the checkbox to select
Perform typical configuration, and then click
- 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
Nextand continue with step 3.
- 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
- Under "Selected Naming Methods", make sure "Local Naming" is
displayed in the box, and then click
- 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.
- You will be prompted to enter the Network Protocol. Select
TCP, and then click
- 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
- 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
Nextwhen the test is successful.
- You will be prompted to enter a name for the net service you just
created. UITS recommends using the Service Name you supplied above
IUGP.IU.EDU). Then, click
- If you want to configure another net service name, select
Yes, and follow steps 4 through 8 above. Otherwise, select
No, and then click
- Once you have configured all of your net service names, click
Nexttwice, and then click
- Under "End of Installation", click
Exit. When asked if you really want to exit, click
Connect to Oracle with SQL*Plus
If you need help connecting to your Oracle database, email the High Performance Systems group.
Last modified on November 12, 2013.