These instructions are for accessing your GL Oracle Account.
To access oracle for your class, you must first have a Unix account. If you
do not have one, please see the helpdesk in room ECS020. Once you have
that, your teacher must have requested Oracle accounts for the students in your
class, which would get you to here. Now, to log into Oracle to begin your
work, please follow the following steps.
First log into your UMBC Unix account through ssh. This can be your gl account, Research account, and possibly other departmental accounts. Once you have logged in, then execute the following commands:
At this point you should see a prompt on your screen asking for your password. This is asking for your Oracle password, which is initially the same as your username. Once you have logged in, you will see an SQL> prompt, at which you will type your sql commands. The first thing you should do is type the command "password", which will prompt for your old password, and then a new one twice. This is for security reasons, so please change your password.
If you note in the above command, you typed "$USER". The "$USER" can be replaced with your username or not. It will automatically be replaced with your login name by your shell. If you are logging in from a server where you have this software available, but your username is different than your GL username, then you will want to replace "$USER" with your GL username.
Here are a few things to watch for, and how to correct them. Most are out of your control, but we need you to notify the correct people when you see them.
This means that either you have typed in your password wrong, specified your username incorrectly, or your correct GL username is not on the teacher's list. In the first case, try again, and if you still can't get it, send email to the address below. In the second case, specify your GL username correctly instead of using $USER. In the third case, have your teacher contact the address below with your correct GL username and ask to have your GL username added to their Oracle class.
This is because the listener service on the server has stopped responding. Please either report this to the address below, or contact someone at the helpdesk in room ECS020( x53838 ) and report the problem.
This is because you did not type "$USER" after sqlplus at the prompt. Be sure that you're spelling it correctly, and all those letters are capital.
For this to happen you must be specifying the ORACLE_SID incorrectly. This should never occur if you follow the instructions above. This probably means you are specifying something after your username such as typing "sqlplus $USER@GU". There should not be anything directly after your username. If you are trying to specify a file to read commands in from, you should have a space befor the "@filename".
This means that it could not create the file specified. This is usually for one of two reasons. One is because you are over quota. You can check this by typeing "quota -v" from your unix prompt(same place you typed sqlplus). Another reason is that you type sqlplus while you were in a directory that you could not write to. The filename specified after "spool" is created in your current directory.
This probably means that you forgot to type "source /usr/local/oracle.cshrc", or the equivilent. The command means that "sqlplus" is not in your path, and the source command extends you path so that it will be.
Any questions or problems should be directed to systems@umbc.edu.