Oracle on seer.njit.edu

Seer.njit.edu is a new database server running Oracle10g. Seer.njit.edu is a Sun Microsystems Sunfire 280R with the Solaris 9 operating system installed. There are two databases running on seer.njit.edu -- research.njit.edu and project.njit.edu.

otn.oracle.com
Obtaining accounts on research.njit.edu
Obtaining accounts on project.njit.edu
Authentication
Access
JDBC
Perl DBI


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 research.njit.edu
Research.njit.edu is 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. Emails are sent to the user prior to account expiration.
Obtaining accounts on project.njit.edu
Project.njit.edu is intended for short term undergraduate and graduate research projects. These projects are generally about a year's duration and are performed to fulfill the Bachelor's or Master's degree requirements. 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. Emails are sent to the user prior to account expiration.
Authentication
All accounts for databases running on seer.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 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.  
Sql*Plus clients
The Oracle installation was upgraded to version 11g2 in August 2011.

iSQL*Plus is not supported in Oracle 11g2, and thus is no longer available.   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 demostrates 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 demostrates 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);






 
Last Updated: June 29, 2017