At IU, what is the Oracle database Oed1 for self-learning, and how do I get an account?

The UITS Oracle database for self-learning and instruction (named Oed1) is available to Indiana University students, faculty, and staff seeking to learn about Oracle. The current version of the server is Oracle Enterprise Edition 10.1.0.2 and is running on Solaris 5.8. Oed1 is maintained and supported by the UITS Data Management Services group.

UITS backs up information from Oed1 to disk and to tape daily. To accomplish the backup, Oed1 is shut down each day at 5am and is available no later than 6am. In the event of a system failure, UITS can restore Oed1 to the point of the last good backup, which is usually from that morning. UITS cannot promise up-to-the-minute recovery of accounts. Further, UITS does not offer recovery of data for individual accounts in cases where data loss is the result of user error. UITS encourages you to maintain copies of all scripts as a sensible measure.

IU students, faculty, and staff may acquire an Oracle account and have access to Oed1 for learning basic SQL and Oracle schema administration techniques. Research and development on Oed1 is prohibited.

Obtaining an Oracle account

To request an account on Oed1 for learning Oracle, use the Request Form for an Individual Oracle Account at:

Note: If an Oracle account is required for a course, do not use this form to request an account. Your instructor will set up your account with the necessary specifications.

Account requests are processed during business hours Monday-Friday. If your account request is granted, you will receive information about your Oracle account via email. If your account request does not meet the parameters of service, UITS will also communicate this information via email.

Note that the UITS High Performance Systems group hosts an Oracle database for research at IU. That service is intended solely to provide a hosting service for research data. The two environments are separate due to the differences in use, volatility, and space requirements. To request an account on the Oracle database for research, visit:

Connecting to your Oracle account

For information regarding how to connect to your Oracle account, see At IU, how do I connect to my account on the UITS Oracle database Oed1?