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

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.

    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
      
    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.

What is ike or @ike or user@ike or your-user-id@ike for?

  • See https://linux.cci.drexel.edu/docs/
  • This ike user is what you use to login to sqlplus.
  • Same userid as your Drexel uesrid, but follow it with @ike instead.
  • You'll see more on this at the above link. You'll need to click the PuTTY link, or Windows 10/11 Command Line or Mac OS links at the above link look at later steps in the instructions for more on the @ike user.

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 Oracle linux.cci.drexel.edu form, then you need to change your DrexelOne password FIRST.
  • Then come back to the Oracle linux.cci.drexel.edu form password at
    https://linux.cci.drexel.edu/signup/
    to get a new password or change your password.
  • Your DrexelOne & Oracle linux.cci.drexel.edu 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 your new DrexelOne & Oracle linux.cci.drexel.edu passwords ONLY contains alphanumeric characters (a-z A-Z 0-9).
    Do not include in your new DrexelOne & Oracle linux.cci.drexel.edu passwords ANY special or extended characters or punctuation,
    so do not include ! @ # $ % ^ & * ( ) ; , . [ ] { } \ | ` ~ ; : ' " < > / ? etc.
  • To change your DrexelOne password:
    Visit https://accounts.drexel.edu, and click "Forgot Password?"
    Or go directly to https://passwordreset.microsoftonline.com/
  • 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.

If you see "ORA-01017: Invalid Username/Password" after trying to login to SQLPLUS?

  • Make sure the SQLPLUS (or sqlplus) password matches your Oracle linux.cci.drexel.edu password.
  • Make sure the SQLPLUS (or sqlplus) password ONLY contains alphanumeric characters (a-z A-Z 0-9).
  • If it doesn't, or you still have issues, change your Oracle linux.cci.drexel.edu password at:
    https://linux.cci.drexel.edu/signup/
  • Sometimes, SQLPLUS does not like characters Oracle linux.cci.drexel.edu is okay with, and vice versa, or something gets out of sync between the 2 passwords. Changing the password 9 times out of 10 resolves this issue.
  • Changing your Oracle linux.cci.drexel.edu password is just like setting it for the 1st time.
  • Do not include in your new Oracle linux.cci.drexel.edu password ANY special or extended characters or punctuation, so do not include ! @ # $ % ^ & * ( ) ; , . [ ] { } \ | ` ~ ; : ' " < > / ? etc.

If you see "ORA-12532: TNS: invalid argument" after trying to login to SQLPLUS?

  • Make sure the SQLPLUS (or sqlplus) password matches your Oracle linux.cci.drexel.edu password.
  • Make sure the SQLPLUS (or sqlplus) password ONLY contains alphanumeric characters (a-z A-Z 0-9).
  • If it doesn't, or you still have issues, change your Oracle linux.cci.drexel.edu password at:
    https://linux.cci.drexel.edu/signup/
  • Sometimes, SQLPLUS does not like characters Oracle linux.cci.drexel.edu is okay with, and vice versa, or something gets out of sync between the 2 passwords. Changing the password 9 times out of 10 resolves this issue.
  • Changing your Oracle linux.cci.drexel.edu password is just like setting it for the 1st time.
  • Do not include in your new Oracle linux.cci.drexel.edu password ANY special or extended characters or punctuation, so do not include ! @ # $ % ^ & * ( ) ; , . [ ] { } \ | ` ~ ; : ' " < > / ? etc.

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.
    https://linux.cci.drexel.edu

    or...
    https://linux.cci.drexel.edu/signup/index.pl
  • If you are asked if you should continue, click "Advanced" & "Proceed" & the like, or "Continue."
    We host the site. It's safe.
  • 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.