Difference between revisions of "Oracle:SQLPlus"
| Line 27: | Line 27: | ||
== Changing Your Password == | == Changing Your Password == | ||
| − | It is advisable to change your password to something else | + | It is advisable to change your initial password to something else. To do this, once you have logged in, type: |
password | password | ||
It will ask for your old password first, before you can set a new one. | 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 | + | |
| + | 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: | ||
| + | |||
| + | https://mi-linux.wlv.ac.uk/~oracle/reg12c/orareg.php | ||
Revision as of 13:49, 13 January 2016
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:
