Oracle on is a virtualized host running Oracle DB server.  There is one database instance running on called "course".
Obtaining accounts on
Aqua Data Studio
Perl DBI
It is recommended that all oracle users register at  There is no charge for this and you will be able to download sample code and have access to tutorials.  There is a wealth of information on this site.
Obtaining accounts on is intended for coursework only.  Individuals (students, faculty, and staff) can create an Oracle account by running the database password reset utility at The utility will send the database owner an email describing the login credentials for either a new account or the existing account. The email is sent to the owner's address and should arrive within an hour (generally much sooner). Contact the IST Service Desk if you encounter any difficulties.

Database accounts remain available while the owner attends/works at NJIT. For security purposes, database passwords will be reset to a random string every August. The owner may obtain a new password at

All accounts for databases running on are authenticated internally. This means you have a separate Oracle userid and password. Unless there are special requirements for a project, your Oracle userid will be your UCID. Your Oracle password will be unique. Since your Oracle password is embedded in scripts and passed across the network it is STRONGLY recommended to keep your Oracle password different from your UCID or Highlander AFS password. Your Oracle userid and password will be emailed to you when your account is created.
All access to databases running on must be via Oracle clients. There is no telnet or ssh access to The use of a VPN client will be required if attempting to connect to Oracle from off campus. 
Aqua Data Studio

Aqua Data Studio (ADS) is a database developer's complete Integrated Development Environment (IDE). The IDE provides three major areas of functionality:
  1. Database query and administration tool
  2. Suite of compare tools for databases, source control and filesystems, and
  3. a complete and integrated source control client for Subversion (SVN) and CVS.
NOTE that you MUST use VPN to access Oracle using ADS from off campus.


NOTE: The Oracle installation was upgraded to version 12c in January 2015

The following is the JDBC connect statement to use to connect to the "course" database running on

getConnection("", "oracle_username","oracle_password")

The following program demostrates a connection to the course database on and executing the SQL statement "SELECT SYSDATE FROM DUAL"

Click jdbc.txt​ for a printer friendly version of this code.
Connecting to the Oracle DB using PHP

The following is example code on how to connect NJIT's Oracle DB through PHP.

Perl DBI
Perl DBI and DBD-Oracle modules are installed and available for connecting to Oracle on using perl scripts.

You can find documentation for the perl DBI module by clicking here.

The following is the perl DBI connect statement to use to connect to the "course" database running on

$dbh = DBI->;connect("dbi:Oracle:host=prophet;sid=course";port=1521", 'username/password')   or die" Error connecting to course"
The following program demostrates a connection to the project database on and executing the SQL statement "SELECT SYSDATE FROM DUAL"
#!/usr/local/bin/perl -wuse strict;use DBI;my $dbh = DBI->connect(";sid=course;port=1521", �username/password�)       or die" Error connecting to project";my $sql = qq{ SELECT SYSDATE FROM DUAL };my $sth = $dbh->prepare( $sql );$sth->execute();while (my($sysdateString) = $sth->fetchrow_array){  print $sysdateString, "\n";}$dbh->disconnect();# See the DBI module documentation for full details# for some advanced uses you may need Oracle type values:#use DBD::Oracle qw(:ora_types);
Note: Always use /usr/local/bin/perl, not perl. Using only perl means that the first such instance found in your PATH will be used; this is genenerally /bin/perl, for which the module is not available. /usr/local/bin/perl (version 5.8.0 as of Fall 2005) does contain the module

To see which perl is first in your PATH: which perl

Oracle10g Database Online Documentation, Release 2 (10.2) TBD

Last Updated: June 29, 2017