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 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