Oracle on prophet.njit.edu

Prophet.njit.edu is a virtualized host running Oracle DB server.  There is one database instance running on Prophet.njit.edu called "course". 

otn.oracle.com
Obtaining accounts on prophet.njit.edu
Authentication
Access
Aqua Data Studio
JDBC
Perl DBI
Documentation

otn.oracle.com
It is recommended that all oracle users register at otn.oracle.com.  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 prophet.njit.edu
Prophet.njit.edu is intended for coursework only.  Individuals (students, faculty, and staff) can create an Oracle account by running the database password reset utility at http://mypassword.njit.edu/db. 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 UCID@njit.edu 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, prophet.njit.edu:course database passwords will be reset to a random string every August. The owner may obtain a new password at http://mypassword.njit.edu/db.


Authentication
All accounts for databases running on prophet.njit.edu 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.
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:
  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
 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 demostrates 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.
 
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 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 demostrates 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


Documentation
Oracle10g Database Online Documentation, Release 2 (10.2) TBD








 
Last Updated: June 29, 2017