Oracle SQL -- linux.cci.drexel.edu (f.k.a. linux.ischool.drexel.edu)

You Must Be Connected to Drexel VPN to use linux.ischool.drexel.edu

Click here for instructions on how to connect to Drexel VPN.

IMPORTANT NOTES

  • linux.cci.drexel.edu was rebuilt and the new server was deployed. You could get error that the remote host identification has changed.  This can be ignored and the new fingerprint/id can be saved.
          1.  Example of the change in remote host identification error is shown below.

               WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!

               It is also possible that a host key has just been changed.

               The fingerprint for the RSA key sent by the remote host is
               SHA256…………………………………………………4
      
          2.  See Fix SSH host key error for Oracle SQL on linux.cci.drexel.edu.

  • Since linux.cci.drexel.edu was rebuilt with the latest CentOS and packages... Mac users should no longer need to use the customized commands/hashes they had to use on the old server.  They should be able to ssh directly to the server now. 
  • The new server hostname is “linux.cci.drexel.edu”. It is preferred to use that host name going forward.
  • However the old hostnames (linux.ischool.drexel.edu & linux.cis.drexel.edu) have been converted to CNAMES, and they usually still work.

START WITH THIS: All students have to create an account FIRST using the form at the webpage below.

For "How to connect to Linux/Oracle" for Windows or Mac:

If Nothing Appears When You Type in Your Password at Command Line Interface (Terminal, cmd.exe, console, etc) Prompt:

  • Letters and numbers in passwords do not appear here as you type them at the password prompt.

If You Forgot Your Linux/Oracle/Java/iSchool Password:

If you see "Your connection not fully secure" or "Warning: Potential Security Risk Ahead"?

Linux/Oracle/Java/iSchool Passwords MUST:

  • Only contain alphanumeric characters (a-z A-Z 0-9).
    • Letters and numbers only, in other words.
  • Begin & end with a letter.
  • Contain at least a couple numbers in them.
  • Be between 8-12 characters in length.

For connecting to GUI, but not sqlplus:

  • Use oracle2.cci.drexel.edu not oracle.cci.drexel.edu
  • sqlplus access does NOT use oracle2.cci.drexel.edu NOR oracle.cci.drexel.edu
  • Sqlplus doesn't use a hostname. It's still user@ike

If you get the error "Your DrexelOne username and/or password is not correct":

  • ...after filling out & submitting the Linux/Oracle/Java/iSchool form, then you need to change your DrexelOne password FIRST.
  • Then come back to the Linux/Oracle/Java/iSchool form password to get a new password or change your password.
  • Your DrexelOne password is what you use for Bb Learn, Zoom, Office365, and other Drexel websites.
    • Changing it will change that password for all of these other websites as well.
  • Make sure the new DrexelOne password ONLY contains alphanumeric characters (a-z A-Z 0-9).
    • Do not include in your new DrexelOne password ANY special or extended characters or punctuation, so do not include ! @ # $ % ^ & * ( ) ; , . [ ] { } \ | ` ~ ; : ' " < > / ? etc.
  • To change your DrexelOne password:
  • If own a Drexel-managed or -owned machine, particularly a Mac, please contact ihelp@drexel.edu first, as changing your password here will change your password on your Drexel-managed or -owned machine, and that might be better done on-campus, and perhaps not done at all on a Mac, but we'll assist regardless.
    • Drexel students working on their personal computers do not need to contact ihelp first.

Do you need a Linux/Oracle/Java/iSchool Account?

  • Fill Our the Request Form below to have a user account made for Linux/Oracle/Java/iSchool form.
  • IF you need Java as well for an assignment, still fill out the above form first.

SSH error - macOS X High Sierra users

  • To use the SSH client in the Mac terminal, type in the following. Replace USERID with your userid:
  • ssh -c 3des-cbc USERID@linux.cci.drexel.edu

SSH error - macOS X Mojave users:

  • To use the SSH client in the Mac terminal, type in the following. Replace USERID with your userid:
  • ssh -c 3des-cbc -oKexAlgorithms=+diffie-hellman-group1-sha1 USERID@linux.cci.drexel.edu

SSH error - macOS X Catalina users:

  • Mojave method above may also work.
  • To use the SSH client in the Mac terminal, type in the following. Replace USERID with your userid:
  • ssh -c 3des-cbc -oKexAlgorithms=+diffie-hellman-group1-sha1 USERID@linux.cci.drexel.edu
Fix SSH Hostkey error:

Incorrect Password or Still Have Password Authentication or Other Issues?

Locked tables

  • If you have service disrupted or other issues, unlocking usually takes 6-12 hours but if you are a Drexel CCI faculty/staff/student, please contact ihelp@drexel.edu  and we will help as soon as possible.

The Oracle website wants a username or email and password to download stuff. What do I do?

  • The Oracle website login, username, email you use, and password are all separate from Drexel and from linux.cci.drexel.edu.
  • So just go ahead and register for and create an Oracle account IF YOU NEED TO DOWNLOAD FILES FROM ORACLE.
  • Oracle just wants everyone to make an account in order to download stuff.
  • The Oracle account you create is completely separate from the CCI linux.cci.drexel.edu website and Drexel Connect.