How to login into Oracle

The Oracle server is available on oradb-srv. There are several ways of using it at the University, from:

This page also looks at:

Which Server?

The University now runs one Oracle server, oradb-srv, which is running version 12c. From 2013/14 all database modules will use Oracle 12c. Oracle11g is still available on scitdb for a short time, to allow any summer project students to complete.

Using Oracle from the Client

All the FSE labs now run the client software for accessing Oracle. For these you need to know your Oracle username and password (different from the username and password you use to logon to the computer labs). Typically your username on Oracle is your student number preceded by OPS$. That is, if your student number is 0912345 then your Oracle username will be ops$0912345.

Start>All Programs>Oracle>SQL*Plus

When using any of the client tools it will typically ask for the following:

Username:

your Oracle username
(your login username preceded with OPS$)

followed by: @ora12c

For example: ops$0912345@ora12c

Password: your Oracle password

Things to Note

When you login to mi-linux, your user files are mounted from a central server. These are separate from the documents you can see from your "My Documents" folder.

If you are a project student, remember the Oracle licence is for academic and research use only. That is, it can not be used for any commercial activity. Any student contravening this will have their Oracle account suspended and will be reported to the school management. If you are in any doubt if your project falls in this category, please contact the Oracle DBA first.

Common problems

Problem: When you login to mi-linux, you get the above message. To confirm this is the problem type:
pwd
and the system will respond with just
/
mi-linux loads your user files from a University file server. If you are a non-FSE student taking a database module, then you may not have an account on the FSE servers.

Action: Contact your module leader to get a FSE account created, or try the Web Registration Program.

If you get the following error message when trying to login to Oracle:

ERROR: ORA-01017: invalid username/password; logon denied

Problem: It means either you have provided the wrong username or password, or that you have not been registered on Oracle to use it.

Action: See how to get an Oracle account, to either get a new account, or this program will also tell you what your original password was, if you have forgotten it.

If you get the following error message when trying to login to Oracle:

ERROR: ORA-12560: TNS:protocol adapter error

Problem: It means you have forgotten to add the "@ora12c" after your username when logging in

Action: See how to login above.

Problem: It means you have exceeded the size limit of the files you have in your account. If you have downloaded a lot of pictures etc. from the web, then you can quite quickly exceed this. You can still login to Oracle, but you will not be able to save any queries or results.

Action: The only way round this is to delete some files!


Last updated: Tuesday, 17-Jun-2014 16:45:51 BST