Oracle
The Oracle database (commonly referred to as Oracle) is a relational database management system from Oracle Corporation. NJIT currently offers Oracle database space on two separate servers, prophet.njit.edu and seer.njit.edu.
Prophet:
prophet.njit.edu is a database server, used for coursework.The database instance running on prophet.njit.edu is named course. If you have forgotten or otherwise need to reset your Oracle password, click here.
Command line interface (CLI)
To use a CLI to connect to prophet, on any Linux AFS client :
module load oraclient-12c
sqlplus UCID@course
Access
All access to databases running on prophet.njit.edu must be via Oracle clients. There is no telnet or ssh access to prophet.njit.edu. 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:- Database query and administration tool
- Suite of compare tools for databases, source control, and filesystems, and
- a complete and integrated source control client for Subversion (SVN) and CVS.
JDBC
The following is the JDBC connect statement to use to connect to the "course" database running on prophet.njit.edu.
getConnection("jdbc:oracle:thin:@prophet.njit.edu:1521:course", "oracle_username","oracle_password")
The following program demonstrates a connection to the course database on prophet.njit.edu and executing the SQL statement "SELECT SYSDATE FROM DUAL"
Click jdbc.txt for a printer-friendly version of this code.
Perl DBI
Perl DBI and DBD-Oracle modules are installed and available for connecting to Oracle on prophet.njit.edu 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 prophet.njit.edu.
$dbh = DBI->;connect("dbi:Oracle:host=prophet;sid=course";port=1521", 'username/password') or die" Error connecting to course"
The following program demonstrates a connection to the project database on prophet.njit.edu and executing the SQL statement "SELECT SYSDATE FROM DUAL"
#!/usr/local/bin/perl -wuse strict;use DBI;my $dbh = DBI->connect("dbi:Oracle:host=prophet.njit.edu;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 DBI.pm module is not available. /usr/local/bin/perl (version 5.8.0 as of Fall 2005) does contain the DBI.pm module
To see which perl is first in your PATH: which perl
Seer:
seer.njit.edu is an Oracle database used for research projects. If you have forgotten or otherwise need to reset your Oracle password, click here.
About
There are two databases running on seer.njit.edu -- research.njit.edu and project.njit.edu.
- research.njit.edu - Intended for long term faculty research projects. To have a project installed on research.njit.edu, send an email to oracle@njit.edu. Faculty accounts have no expiration while student accounts have a one year expiration. Student accounts may be renewed as necessary.
- Project.njit.edu - intended for short term undergraduate and graduate research projects. All accounts on project.njit.edu require faculty sponsorship. To obtain an account on project.njit.edu, have your faculty advisor send an email to oracle@njit.edu requesting the account on your behalf. Faculty accounts have no expiration while student accounts have a one year expiration. Student accounts may be renewed as necessary.
Access
All access to databases running on seer.njit.edu must be via Oracle clients. There is no telnet or ssh access to seer.njit.edu. The use of a VPN client will be required if attempting to connect to Oracle from off campus.
JDBC
The following is the JDBC connect statement to use to connect to databases running on seer.njit.edu. Replace ORACLE_SID with either "project" or "research" depending on which database you want to connect to.
getConnection("jdbc:oracle:thin:@seer.njit.edu:1521:ORACLE_ID", "oracle_username","oracle_password")
The following program demonstrates a connection to the project database on seer.njit.edu 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 project database on seer.njit.edu. */// You need to import the java.sql package to use JDBCimport java.sql.*;class jdbcTest_project{ public static void main (String args []) throws SQLException { // Load the Oracle JDBC driver DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url = "jdbc:oracle:thin:@seer.njit.edu:1521:project"; 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 (rset.next ()) System.out.println (rset.getString (1)); // Close the RseultSet rset.close(); // Close the Statement stmt.close(); // Close the connection conn.close(); }}
Perl DBI
Perl DBI and DBD-Oracle modules are installed and available for connecting to Oracle on seer.njit.edu 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 databases running on seer.njit.edu. Replace ORACLE_SID with either "project" or "research" depending on which database you want to connect to.
$dbh = DBI->connect("dbi:Oracle:host=limpid;sid=ORACLE_SID;port=1521", ’username/password’) or die" Error connecting to ORACLE_SID";The following program demonstrates a connection to the project database on seer.njit.edu and executing the SQL statement "SELECT SYSDATE FROM DUAL"
#!/usr/local/bin/perl -wuse strict;use DBI;my $dbh = DBI->connect("dbi:Oracle:host=seer.njit.edu;sid=project;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);