Oracle:SQLPlus
Main Page >> Oracle and SQL >> Getting Started >> SQL*Plus
SQL*Plus Client
First of all start SQL*Plus - see this page for details: Starting SQL*Plus
It will then present you with a log on screen as shown on the following figure:
http://mi-linux.wlv.ac.uk/~oracle/wiki/SQLPlus_Client.png
Fill in the following, note the format of the username carefully:
| User-name: | This is your student number, preceded by OPS$ and followed by @ora12c |
| E.g., if your username is 0912345, then type in: OPS$0912345@ora12c | |
| Password: | When you registered for Oracle, you will have been given a password. Type this in when prompted. |
| Note, the password will not be echoed on the screen, nor any asterisks shown. |
Do note that the password is case sensitive, but the user-name is not. Generally the initial password given starts with a capital letter. You can change this once you have logged in.
If you have logged in successfully you will be presented with the SQL> prompt:
http://mi-linux.wlv.ac.uk/~oracle/wiki/SQLPlus_Client2.png
Changing Your Password
It is advisable to change your initial password to something else. To do this, once you have logged in, type:
password
It will ask for your old password first, before you can set a new one.
Note, once you change your password, if you forget it we can only reset it to the original password. If you do find you have forgotten your password and the system has locked you out, re-run the registration program and it will reset it back for you:
