OraSQLPlus

Main Page >> Oracle and SQL >> Getting Started >> SQL*Plus

SQL*Plus - First Time

Apps Anyhere

The Oracle database can be accessed via different clients. When using the software at the University, it is available via the Applications Anywhere software hub: [Apps Anywhere]

The first time you use Oracle, click the Apps Anywhere icon on your desktop:

http://mi-linux.wlv.ac.uk/~oracle/wiki/Apps.png

Which will bring up the following window:

http://mi-linux.wlv.ac.uk/~oracle/wiki/appsAnywhere.png

Click where it says CLICK HERE and then search for Oracle. It will install as a group of 3 tools:

Oracle Data Modeller
Oracle SQL Data Developer
Oracle SQL*Plus

Note, you may have to install this for every PC that you use.

SQL*Plus Client

Once SQL*Plus has been installed you should find it has been added to your program menu (or select from new window - check):

http://mi-linux.wlv.ac.uk/~oracle/wiki/oracle_options.png

In which case you can start the program by clicking on:

  Start>All Programs>Oracle >SQL Plus 12.1

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.