Our current version is Oracle Database 10g Enterprise Edition Release - 64bit Production With the Partitioning and Data Mining options

How do I get access to Oracle?

First, you need to set up your Oracle database account. Students are eligible when registered for a course that uses Oracle or when sponsored by faculty, e.g. for research. Students should ask their faculty sponsor to send the request to (Accounts are scheduled for removal, each after the instructor posts the student's grade.)

Activate your Oracle database account

You can activate your Oracle account by going to

How to connect to Oracle

If you are off campus you will first need to connect to the VPN. You can find more information on the VPN page.

There are three methods of connecting to Oracle. Follow your instructors directions as to which method to use.

Command line access to Oracle through SSH to

  1. If you are off campus (this includes the dorms) you need to first connect to the VPN
  2. Then SSH to On Windows you can use SecureShell. On a Mac you can use Terminal (in your Applications/Utilities folder) and enter the command "ssh". Linux you can use the command line "ssh".
  3. Once you are connected to zeus you run the command sqlplus and enter your Oracle username and password when prompted.

The iSQL*Plus web-browser Interface through

  1. If you are off campus (this includes the dorms) you need to first connect to the VPN
  2. Open the web page: (You may see security warnings. You click through them.)
  3. Login with your Oracle username and password.

The SQL Developer GUI

  1. Install SQL Developer from:
  2. If you are off campus (this includes the dorms) connect to the VPN
  3. Create a new connection using the following settings:
    SID: ite10g

Who can I contact if I have a problem with Oracle?

It depends on the kind of problem. If it is related to SQL commands or query errors, please refer to your instructor or class TA. If it is related specifically to your oracle account or the oracle systems, please email the Oracle administrator at oracle ((at))

If the problem is related to UNIX commands or systems, please ask a lab assistant or email the problem description(s) to system ((at))

What are the jdbc connection parameters for Oracle?

  • Name:
  • Port: 1521
  • Oracle SID: ite10g