DB Creation   «Prev  Next»

Lesson 2Server Manager
ObjectiveLearn what you can do with Server Manager.

Oracle Server Manager Capabilities

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:
  1. Starting a database
  2. Shutting down a database
  3. Running various Oracle-supplied DBA scripts
  4. Creating a database
  5. Executing SQL commands for the purpose of creating and managing users, space, tables, and other database objects.
Server Manager is Oracle's database administration tool. The graphical component of Server Manager (Server Manager/GUI) allows you to perform database administration tasks with the convenience of a graphical user interface (GUI). The line mode component of Server Manager (Server Manager/LineMode) provides a line mode interface.

Server Manager and Database Administration

Server Manager is designed to replace SQL*DBA and provide administrative functionality through an easy-to-use interface. You can use Server Manager to:
  1. Perform traditional administrative tasks, such as database startup, shutdown, backup, and recovery. Rather than manually entering the SQL commands to perform these tasks, you can use Server Manager's graphical interface to execute the commands quickly and conveniently.
  2. Concurrently perform multiple tasks. Because you can open multiple windows simultaneously in Server Manager, you can perform multiple administrative and non-administrative tasks concurrently.
  3. Administer multiple databases. You can use Server Manager to administer a single database or to simultaneously administer multiple databases.
  4. Centralize database administration tasks. You can administer both local and remote databases running on any Oracle platform at any location worldwide. In addition, these Oracle platforms can be connected by any network protocol(s) supported by SQL*Net and the MultiProtocol Interchange.
  5. Dynamically execute SQL, PL/SQL, and Server Manager commands. You can use Server Manager to enter, edit, and execute statements. Server Manager also maintains a history of statements executed. Thus, you can re-execute statements without retyping them, a particularly useful feature if you need to execute lengthy statements repeatedly.
  6. Perform administrative tasks using Server Manager's line mode interface when a graphical user interface is unavailable or undesirable.

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:
  1. A real-time monitoring function
  2. GUI screens to create and modify users, tables, indexes, tablespaces, and so forth.

Oracle is slowly winding down support for Server Manager, and is promoting Enterprise Manager as the GUI tool of choice for managing Oracle databases.
The command-line functionality of Server Manager has been folded into SQL*Plus, and Server Manager is no longer shipped or supported in Oracle.
In this course we will be using SQL *Plus because it can be used with all current releases of Oracle. If you are using release Oracle 9i or above, the same commands should work from SQL*Plus as well.