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

This chapter covers the following topics:

Overview

 Enterprise Manager has an open architecture that allows software tools to be integrated with the Console. The design of these integrated applications allows you to:

Database Administration Applications

 A standard package of integrated applications, which automate and simplify DBA tasks, are shipped with Oracle Enterprise Manager. The applications are:

Refer to the Oracle Enterprise Manager Adminstrator's Guide for further information on the DBA applications.

Common Features

The integrated applications share some common features:

Tree Lists

 In the standard suite of database applications all the tools have a tree list of managed objects similar to the Navigator tree list in the Console. For example, in the Security Manager the tree list has containers for users, roles, and profiles. These containers can be expanded or collapsed by clicking the + or - icons to the left of the container.

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. A property sheet 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.

Instance Manager

With the Instance Manager you can start up and shut down databases, examine and edit initialization parameters, manage in-doubt transactions, and manage users' sessions. The Instance application manages initialization parameters, in-doubt transactions, stored configurations, and sessions.

Schema Manager

With the Schema Manager you can create, edit, and examine the following schema objects:

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

Security Manager

With the Security Manager you can create, alter, and drop users, roles, and profiles. The Security application manages the following groups:

Adequate database security is a major concern in client-server environments. Enterprise Manager's Security Manager effectively controls the security of Oracle databases. Using the dialog boxes provided, authorized administrators can quickly 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 what profiles and roles 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

With the Backup Manager you can perform tablespace backups and create backup scripts guided by a backup wizard. You can also administer redo logs.

The Backup Manager manages the following groups:

The Backup Manager simplifies backups through the use of a backup wizard. The Backup Wizard allows you to specify

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 is Oracle's management tool for complete software management across the enterprise. Software Manager provides key services that allow all software to be managed from a central location.

This product addresses the fundamental problems faced by application software administrators by offering:

The Oracle Enterprise Manager/Oracle Software Manager (OSM) network is comprised of one or more OEMGR/OSM installations each administering host servers that contain Oracle Intelligent Agents. The Intelligent Agent may have clients that are administered as part of the network.

Oracle Software Manager uses a lightweight store-and-forward messaging system that keeps network traffic to a minimum. In the event of network problems, any message that is waiting to be sent, either from the Console or the agent, is held until the network is back online. Communications between the Console and agents are not resource intensive; they require only one connection per agent. If a host becomes unavailable, the connection is freed.


Go to previous file in sequence Go to next file in sequence
Prev Next		 Oracle
Copyright © 1996 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