Oracle:SQLPlus

From mi-linux
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Workbook >> 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 similar to the following figure:

InstantClient19c.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 @ora19c
  E.g., if your username is 0912345, then type in: OPS$0912345@ora19c
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:

InstantClient19cLogin.png

Easy Connect String

At the start of the 2019/20 Academic Year some labs have not been fully set-up yet. If you find the @ora19c returns with

ORA-12154: TNS:could not resolve the connect identifier specified

Then when prompted for a username in SQL*Plus, type in:

Your_Oracle_Username/Your_Oracle_Password@ora-srv.wlv.ac.uk:1521/catdb.wlv.ac.uk

This must be entered as one line at the Enter user-name: prompt. Replace Your_Oracle_Username and Your_Oracle_Password with your own details.

SQL*Plus Command Line

The prompt: SQL> means the system is waiting for you to enter a command.

There are two types of command that you may enter:

• SQL commands. For manipulating data in the database. Each SQL command is terminated by a semi-colon, which will be seen later.

• Control commands. For formatting results and editing. The semi-colon is optional for these commands.

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.

If you forget your new password and the system locks you out after several attempts, re-run the registration program and it will reset it back to the original password:

Oracle registration program

Please note: we can not access any updates to your password once you change it!

Next: Setting up the Sample Database

Initially you will have no tables in your database. The next step is to: set up the sample database