ARCHIVED: How do I access my database on the IU Research Database Complex using the Oracle client for Windows XP?
Important: As of April 8, 2014, Microsoft no longer supports Windows XP with security updates. To ensure the highest security standards, the UITS Support Center no longer registers Windows XP devices to the IU network. UITS strongly recommends that you look into the options for replacing or upgrading your Windows XP computers for full compatibility with IU systems. See About end of life for Vista and Windows XP.
The Indiana University Research Database Complex supports research-related databases and data-intensive applications that require databases. The RDC provides an environment for database-driven web applications focusing on research, and offers the following database accounts:
- MySQL: The RDC supports MySQL Enterprise Server.
- Oracle: MySQL can meet most database needs. However, if your research has an immediate requirement for specific functionality in Oracle, you may request to be considered for an Oracle database account. To do so, follow the instructions in the RDC Database and Web Services Account Application.
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 left, click .
- Under "Databases", click .
- Under "Installation Packages", click .
- Click Network ID. . Log in with your IU
- Under "Downloads", click . 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.exe
file you downloaded from IUware, and double-click it to begin the installation. - 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
. 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 theclient
folder, double-click the file. - In the "Oracle Universal Installer" window, click .
- Under "Select Installation Type", choose , 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:
C:\oracle\product\10.2.0\client_1
Note: You may click UITS recommends keeping the default path.
to select an alternate path, but - Click to continue.
- Under "Available Product Components", near the bottom, click the checkbox to select .
- 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) (found under "Oracle Windows Interfaces 10.2.0.1.0").
- Click
When all requirements are verified, click
. . 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.
- Under "Summary", verify the installation information, and then click .
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 Assistant" dialog box. You may have to move the "Oracle Universal Installer" window to reveal the "Oracle Net Configuration Assistant" dialog box.
- In the "Oracle Net Configuration Assistant" dialog box, to see if
your client can be configured automatically, click the checkbox to
select
- 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 , and then . Skip to step 11.
- If this step fails, deselect , and then click and continue with step 3.
, and then 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 . If you do not know the Service Name, email the High Performance Systems group. - You will be prompted to enter the Network Protocol. Select , 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 , and then click . If the login test fails, select , enter your correct user information, and try again. Click when 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
(e.g.,
IUGP.IU.EDU
). Then, click . - If you want to configure another net service name, select , and follow steps 4 through 8 above. Otherwise, select , and then click .
- Once you have configured all of your net service names, click twice, and then click .
- Under "End of Installation", click . When asked if you really want to exit, click .
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.
This is document awqc in the Knowledge Base.
Last modified on 2018-01-18 15:53:24.
- 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.
- 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.