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.
