Oracle Server Manager User's Guide

Using Server Manager

To use Server Manager to administer a database, you must install Server Manager on your personal computer. You must also install several views on the databases you wish to administer

Additional Information: For instructions on installing Server Manager, see your operating system-specific Oracle documentation. For example, for instructions on installing Server Manager on a Windows system, see the Oracle Server Manager for Windows Installation Guide.

Installing Server Manager Views

You must install the Server Manager views on each database you wish to administer. Even if you use one copy of Server Manager to administer several databases, the Server Manager views must be installed on each database.

The script CATSVRMG.SQL creates the views used by Server Manager, as well as a public synonym called SM$VERSION. SM$VERSION contains the script's version number, which appears in Server Manager's version banner. The CATSVRMG.SQL script is included with Server Manager on your distribution media.

In Oracle7 release 7.1 and later, the CATSVRMG.SQL script is run automatically by CATALOG.SQL.

If you wish to use Server Manager to administer a database running Oracle7 release 7.0, you must run the CATSVRMG.SQL script manually. You can run this script from a SQL Worksheet or while using Server Manager in line mode.

When running the CATSVRMG.SQL script, you must be connected with the schema SYS. So, in a release 7.0 database, you must connect as either SYS or INTERNAL. In a release 7.1 or later database, you can connect with either SYSDBA or SYSOPER privileges.

To verify that the Server Manager views have been installed, you can examine the version banner in the Administration window or query SM$VERSION (SELECT * FROM sm$version). Figure 1 - 1 illustrates the version banner in the Administration window.

Dropping Server Manager Views

The script CATNOSVM.SQL drops all the objects created by CATSVRMG.SQL.

Other Scripts Needed for Server Manager

Server Manager also relies on other scripts. For information about Server Manager and the UTLXPLAN.SQL script, see Chapter 7, "Viewing Schema Objects." For information about Server Manager and the UTLMONTR.SQL script, see Chapter 10, "Overview of the System Monitors."

Additional Information: The script names given above are the standard names. On some operating systems, the names and locations of these scripts may differ. See your operating system-specific Oracle documentation for details.

Figure 1 - 1. Administration Window Version Banner

Privileged Operations

To perform an operation or task using Server Manager, you must have the appropriate privileges. For example, to create a tablespace using Server Manager, you must have the CREATE TABLESPACE system privilege.

Because many of Server Manager's windows include information selected from data dictionary tables, you need the SELECT ANY TABLE system privilege to fully utilize Server Manager's interface. The SELECT ANY TABLE system privilege is also part of the DBA role.

Server Manager does not enable any additional roles, so any privileges you need must be part of your default role(s) and privileges.

For information about privileges and roles, refer to the Oracle7 Server Concepts and Oracle7 Server Administrator's Guide.