| Lesson 2 | Server Manager |
| Objective | Learn what you can do with Server Manager. |
Server Manager is a command-line utility used to manage an Oracle database.
It is present in every Oracle installation, and is primarily used for the following tasks:
- Starting a database
- Shutting down a database
- Running various Oracle-supplied DBA scripts
- Creating a database
- Executing SQL commands for the purpose of creating and managing users, space, tables, and other database objects.
There is a GUI version of Server Manager available that is currently only supported under UNIX, and only using X-Windows . The
GUI version provides the following extra functionality:
In this course we will be using Server Manager because it can be used with all current releases of Oracle. If you are using release 8.1 or above, the same commands should work from SQL*Plus as well.
- A real-time monitoring function
- GUI screens to create and modify users, tables, indexes, tablespaces, and so forth.
In this course we will be using Server Manager because it can be used with all current releases of Oracle. If you are using release 8.1 or above, the same commands should work from SQL*Plus as well.