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.
- Fill out the form on the landing page at
For "How to connect to Linux/Oracle" for Windows or Mac:
- General: https://linux.cci.drexel.edu/docs/index.pl
- Windows: https://linux.cci.drexel.edu/docs/windows/index.html
- Mac: https://linux.cci.drexel.edu/docs/mac/index.html
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:
- Fill out the form on the landing page at
- *BUT* enter a new password.
- This will reset your password and keep all of your data.
If you see "Your connection not fully secure" or "Warning: Potential Security Risk Ahead"?
- As long as you seeing this message when on the
https://linux.ischool.drexel.edu
or
https://linux.cci.drexel.edu/signup/index.pl
it's okay to do one of the following:
Firefox: Click "Advanced" > "Accept the Risk and Continue." We host these websites. They are completely safe.
Chrome: "Advanced" > "Proceed to... (unsafe)". We host these websites. They are completely safe.
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
Incorrect Password or Still Have Password Authentication or Other Issues?
- Contact ihelp@drexel.edu
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.