University Computing Systems

Oracle on is a new database server running Oracle10g. is a Sun Microsystems Enterpise 4500 Server with the Solaris 9 operating system installed. There is one database running on called
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.  All students registered for courses that require access to an oracle database server will automatically be given accounts on the Oracle Database server ( running on

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.
ADS is the recommended tool for accessing Oracle. For download and installation instructions see
ADS documentation can be found here.
NOTE that you MUST use VPN to access Oracle using ADS from off campus.

Sql*Plus clients

NOTE: As of January 2008 the iSql*Plus web client is no longer the recommended Oracle client. Please use Aqua Data Studio.

As of Oracle version 11, iSQL*Plus is not support by Oracle. The old version cannot connect to the new database.

As of NJIT's upgrade to Oracle 11g2 in August 2011, iSQL*Plus is not available.


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

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

* This sample demonstrates the jdbc driver by printing the system date from dual
* after connectng to the course database on

// You need to import the java.sql package to use JDBC
import java.sql.*;

class jdbcTest_course
public static void main (String args [])
throws SQLException
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

String url = "";

try {
String url1 = System.getProperty("JDBC_URL");
if (url1 != null)
url = url1;
} catch (Exception e) {
// If there is any security exception, ignore it
// and use the default

// Connect to the database
Connection conn =
DriverManager.getConnection (url, "username", "password");

// Create a Statement
Statement stmt = conn.createStatement ();

// Select the SYSDATE column from the dual table
ResultSet rset = stmt.executeQuery ("select SYSDATE from dual");

// Print the result
while ( ())
System.out.println (rset.getString (1));

// Close the RseultSet

// Close the Statement

// Close the connection

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 -w
use strict;
use DBI;
my $dbh = DBI->connect(";sid=course;port=1521", ’username/password’)
or die" Error connecting to project";


my $sth = $dbh->prepare( $sql );

while (my($sysdateString) = $sth->fetchrow_array){

print $sysdateString, "\n";


# 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)