Services

Oracle

Overview

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

Students registered for the following courses get access to Oracle automatically:

  • AIT 524
  • AIT 580
  • AIT 614
  • AIT 622
  • AIT 690
  • CS 450
  • CS 504
  • CS 550
  • CS 755
  • INFS 311
  • INFS 414
  • INFS 614
  • INFS 740
  • INFS 755
  • INFS 760
  • ISA 765
  • IT 308
  • IT 314
  • IT 414
  • SWE 432
  • SWE 632
  • SWE 642
  • SWE 645

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 oracle@vse.gmu.edu. (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 https://access.vse.gmu.edu/oracle2/index.html


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 zeus.vse.gmu.edu

  1. If you are off campus (this includes the dorms) you need to first connect to the VPN
  2. Then SSH to zeus.vse.gmu.edu. On Windows you can use SecureShell. On a Mac you can use Terminal (in your Applications/Utilities folder) and enter the command "ssh jdoe@zeus.vse.gmu.edu". Linux you can use the command line "ssh jdoe@zeus.vse.gmu.edu".
  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 apollo.vse.gmu.edu

  1. If you are off campus (this includes the dorms) you need to first connect to the VPN
  2. Open the web page: https://apollo.vse.gmu.edu:4443/isqlplus/ (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: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
  2. If you are off campus (this includes the dorms) connect to the VPN
  3. Create a new connection using the following settings:
    hostname:apollo.vse.gmu.edu
    port:1521
    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)) vse.gmu.edu.

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


What are the jdbc connection parameters for Oracle?

  • Name: apollo.vse.gmu.edu
  • Port: 1521
  • Oracle SID: ite10g