Oracle Enterprise Manager Concepts Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

DBA Applications


A standard package of database applications is shipped with the Oracle Enterprise Manager. These applications are the primary administrative components of the Oracle Enterprise Manager and can be used to perform most of your DBA administration tasks.

The design of the applications allows you to:

The DBA Applications chapter contains the following topics.

Topic   See Page  

Common Features

 

4-2

 

The Database Tools

 

4-4

 

Refer to the Oracle Enterprise Manager Administrator's Guide for detailed information on the DBA applications.

Common Features

The Common Features section discusses the following common elements shared by the DBA applications.

Topic   See Page  

Tree Lists of Managed Objects

 

4-2

 

Multi-Column Lists

 

4-2

 

Property Sheets

 

4-3

 

Record and Play Back

 

4-3

 

Basic/Advanced User Modes

 

4-3

 

Tree Lists of Managed Objects

In the standard suite of database applications all the tools provide a navigator tree list of groups and instances to organize the objects associated with the application. The tree list is similar to the Navigator tree list in the Console.

The navigator displays on the left side of an application window after the application has successfully connected to a database.

The groups and instances are usually contained in a database folder. The database folder is the root of the Navigator and displays the name of the database that the application is connected to.

For example, in the Security Manager the tree list has containers for users, roles, and profiles.

Folders hold other objects and display a '+' or '-' to the left of the object's icon and name. A folder can be expanded or collapsed to show or hide its contents. Objects that do not contain other objects do not display a '+' or '-' to the left of the object's icon or name.

Multi-Column Lists

A multi-column list is displayed when you select a group container. Each row in the list provides a quick view of summary information about objects in the selected container. Additionally, you can select and alter items through their respective property sheets.

Property Sheets

A property sheet is a dialog box used to specify options when you are creating or altering a composite instance, such as a user or tablespace.

It consists of one or more pages that are labeled with page tabs. By default, one page is open when the sheet is entered, but all pages show page tabs. To access another page, select its page tab.

Record and Play Back

The integrated applications also provide a "record and play back" mechanism that makes it easy to record a task and perform it at multiple locations.

For example, if you want to assign several privileges to a set of users who exist on ten databases, you could use the Security Manager and the logging mechanism to record the granting of the privileges, and then use the Job Control System to perform the assignment at the ten databases.

Basic/Advanced User Modes

Advanced Mode displays additional property sheets that allow you to access an application's advanced database administration features.

The Database Tools

The Oracle Enterprise Manager provides easy-to-use DBA tools for administrative tasks. The Database Tools section contains the following topics.

DBA Tool   Task   See Page  

Instance Manager

 

Manages instances and sessions

 

4-5

 

Schema Manager

 

Manages schema objects

 

4-6

 

Security Manager

 

Controls security

 

4-6

 

Storage Manager

 

Manages storage

 

4-7

 

SQL Worksheet

 

Enters and executes DBA commands, SQL statements, and PL/SQL commands

 

4-7

 

Backup Manager

 

Manages database backup and recovery environment

 

4-8

 

Data Manager

 

Exports, imports, and loads data in and out of an Oracle database

 

4-9

 

Software Manager

 

Distributes, installs, and de-installs software packages on servers and clients throughout the network

 

4-9

 

Additional applications can be purchased to allow you to:

Instance Manager

With Instance Manager, you can start up and shut down a database, view and edit the values of initialization parameters, resolve in-doubt transactions, and manage users' sessions.

When the Instance Manager has successfully connected to a database, the Initialization parameters, Stored Configurations, In-Doubt Transactions, and Sessions folders display in a navigator on the left side of the Instance window. These folders are contained in the database folder which displays the name of the database the application is currently connected to.

The display on the right side of the window is determined by the objects selected on the left side of the screen. The right side may contain a multi-column scrolling list, property sheet, or dialog box.

The Instance Manager includes the three standard menus, File, View, and Help, plus the Database, Sessions, Transactions, and Configuration menus.

The Instance Manager menus are described below.

Menus   Function  

Database Menu

 

Provides access to all options pertaining to Oracle instance startup and shutdown

 

Sessions Menu

 

Provides access to all options that apply to database session management

 

Transaction Menu

 

Provides access to all options that apply to in-doubt transactions

 

Configuration Menu

 

Allows you to manage any configurations selected from the Stored Configurations folder in the navigator

 

Schema Manager

With Schema Manager, you can create, alter, or drop schema objects such as clusters, database links, execution plans, PL/SQL, sequences, snapshots, snapshot logs, synonyms, tables, and views.

When Schema Manager successfully connects to a database, the schema navigator displays on the left side of Schema Manager window. The navigator consists of a series of schema object containers, one for each type schema object contained in the main Schema Objects folder. The name of the connected database is displayed next to the Schema Objects folder.

The display on the right side of the window is determined by the objects selected on the left side of the screen. The right side may contain a multi-column scrolling list, property sheet.

Schema manager includes four standard menus, File, View, Log, and Help, plus the Object menu.

Summary lists contain significant information about each schema object, such as status, owner, creation date and last date modified.

Security Manager

Security Manager controls the security of Oracle databases. The Security application manages users, roles, and profiles. Using the dialog boxes provided, authorized administrators can create, alter and drop users, roles and profiles and add multiple privileges and roles for database users.

In a dynamic environment, security parameters such as profiles and roles that have been assigned to a set of users are in constant change.

The Security Manager simplifies making the necessary changes by providing security lists which an administrator can use to determine the profiles and roles that have been assigned to a set of users and then use property sheets to determine the security parameters for each database. Required changes can then be made quickly.

Storage Manager

With the Storage Manager you can perform DBA tasks associated with managing database storage. These tasks include managing tablespaces and rollback segments, and adding and renaming datafiles. You can also launch other database tools and utilities from the application.

The Storage Manager manages the following groups:

SQL Worksheet

With SQL Worksheet you can enter SQL statements, PL/SQL code, and Oracle Enterprise Manager DBA commands dynamically, and run scripts which are stored as files.

SQL Worksheet maintains a history of the commands you have entered. Thus, you can use SQL Worksheet to edit and re-execute an earlier command without having to retype it. You can drag a SQL file from the File Manager and drop it into a worksheet to load it.

You can have multiple SQL Worksheets open at a time, each of which is separate from the others. So, you can commit or roll back work in each worksheet independently.

Backup Manager

The Oracle Enterprise Backup Manager are used to manage your database backup and recovery environment. Subsystem availability depends on the version database you are attempting to back up. For Oracle7 databases, you can select Operating System Backup or the Enterprise Backup Utility. For Oracle8 databases, you can select Operating System Backup or Oracle8 Recovery Manager.

The Three available subsystems are listed below:

Subsystems   Function  

Oracle8 Recovery Manager

 

Provides an intuitive graphical interface for Recovery Manager, an extremely powerful and flexible command line backup and recover utility designed expressly for the Oracle8 database.

 

Operating System Backup

 

Provides automated tablespace backup and recovery script generation for submission to the Oracle Enterprise Manager job system for Oracle7 databases. Operating System Backup also provides limited backup and recover capability for Oracle8 databases.

 

Enterprise Backup Utility

 

Provides backup and recovery functionality for Oracle7 databases only. See your Enterprise Backup Utility documentation for further information. Note: Enterprise Backup Utility is not compatible with Oracle running on Windows NT systems.

 

Data Manager

Oracle Data Manager provides wizards to automate the transfer of data to and from an Oracle database. Data Manager also provides job tasks that can be submitted with the Job Scheduling system.

The Data menu of Data Manager includes Export, Import, and Load wizard options for:

Software Manager

Oracle Software Manager provides key services that allow all software to be managed from a central location. This product addresses the problems faced by application software administrators by offering:

The Oracle Enterprise Manager/Oracle Software Manager network is made up of one or more Oracle Enterprise Manager/Oracle Software Manager installations, each administering host servers that contain Oracle Intelligent Agents.




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index