Oracle Getting Started

Main Page >> Oracle and SQL >> Workbook >> Getting Started

Accessing Oracle using SQL*PLUS

The DBMS software used in several database modules is known as Oracle and is supplied by the Oracle Corporation. Oracle is a fully featured multi-user database designed for large-scale applications.

You will use Oracle in a client-server mode. That means that you will use a Windows client program to communicate with Oracle that is situated on a Linux server. The database and the database management system are stored on machine called oradb-srv, the SQL*Plus program which you will use to talk to it is located on the University's Windows labs.

SQL*Plus is available in all the MI Labs, or in the Learning Centre labs that have the computing image. Alternatively, it is possible to use SQL*Plus from the student Linux server (mi-linux.wlv.ac.uk/csl-student.wlv.ac.uk) using a secure shell (SSH) program, such as Putty and the Linux command line interface.

To get started you need to carry out the following steps:

• Register for an account
• Installing SQL*Plus
• Using SQL*Plus
• Setting up the sample database
• Initial queries

Next Step

Once you have completed these steps return to the Workbook for the next section.