Oracle Enterprise Manager Concepts Guide

Contents Index Home Previous Next

Preface

This section describes the purpose and organization of this guide: the Oracle Enterprise Manager Administrator's Guide. This section also illustrates the conventions used in this guide.

The Preface contains the following information:

Purpose of this Guide

This guide describes how to use Oracle Enterprise ManagerTM, Oracle's systems management console, common services, and integrated platform tool. Enterprise Manager includes the database administration tools of Oracle Server ManagerTM, plus it allows you to:

This guide describes both the graphical component (GUI) and line mode component of Enterprise Manager. Information in this guide applies to Enterprise Manager running on the Windows NT 32 Bit platforms.

Note: For an overview of the Enterprise Manager system, see Oracle Enterprise Manager Concepts.

Audience

This guide is written for those who wish to use Oracle Enterprise Manager to perform system administration tasks.

Knowledge Assumed of the Reader

This guide assumes you are familiar with the administrative tasks you wish to perform. If you are not, refer to the Oracle7 Server documentation set. The Oracle7 Server documentation set contains specific and thorough descriptions of the database administration tasks you can perform with Enterprise Manager tools. In addition, the Oracle7 Server documentation set provides recommendations on how to administer your database optimally.

If you have not yet read the introductory chapters of the Oracle7 Server Administrator's Guide, we recommend that you do so. These chapters describe the specific responsibilities of a database administrator.

This guide also assumes that you are familiar with the operation of Microsoft Windows. Refer to the Windows documentation for your system, if necessary.

How the Oracle Enterprise Manager Administrator's Guide Is Organized

This guide is divided into parts and chapters, as described below.

Part I: Overview of the Enterprise Manager and Console

Chapter 1: Overview of Enterprise Manager

This chapter describes the overall organization and features of Enterprise Manager and the Console.

Chapter 2: Navigator

This chapter explains how to use the Navigator component of Enterprise Manager.

Chapter 3: Map

This chapter explains how to use the Map component of Enterprise Manager.

Chapter 4: Job Scheduling

This chapter explains how to use the Job Scheduling component of Enterprise Manager.

Chapter 5: Event Management

This chapter explains how to use the Event Management component of Enterprise Manager.

Chapter 6: Agents and Communication Daemon

This chapter discusses the intelligent agents, the communication daemon, the Daemon Monitor, and sample configuration files.

Part II: The Database Tools

Chapter 7: Overview of the Database Tools

This chapter introduces the Database Tools. It also describes the user interface elements used in the Database Tools.

Chapter 8: Managing Database Storage

This chapter explains how to use the Storage Manager to manage the datafiles, tablespaces, and rollback segments in your database.

Chapter 9: Controlling Database Security

This chapter describes how to use the Security Manager to manage users, roles, and profiles.

Chapter 10: Managing Instances and Sessions

This chapter describes how to use the Instance Manager to start up or shut down your database, and examine the values of the initialization parameters used to start up the instance. It also describes how to manage in-doubt transactions and users' sessions.

Chapter 11: Managing Schema Objects

This chapter describes how to use the Schema Manager to examine and modify various objects in your database.

Chapter 12: Managing Backups and Archiving

This chapter describes the database Backup Manager.

Chapter 13: Using the SQL Worksheet

This chapter describes how to use the SQL Worksheet.

Chapter 14: Managing and Moving Data

This chapter describes how to manage and move Oracle database data with the Import, Export, and SQL*Loader tools.

Chapter 15: Managing Software Distribution

This chapter describes how to use the Software Manager to distribute software packages in the network system.

Part III: Reference

Appendix A: Using Server Manager in Line Mode

This appendix describes how to use Server Manager in line mode.

Appendix B: DBA Command Reference

This appendix describes the DBA commands available in the SQL Worksheet and in Server Manager Line Mode.

Appendix C: Compatibility with SQL*DBA

This appendix describes the differences in functionality and behavior between Server Manager/Line Mode and SQL*DBA.

Appendix D: Starting Enterprise Manager

This appendix describes how to start Oracle Enterprise Manager under Microsoft Windows NT.

Appendix E: Predefined Job Tasks

This appendix lists the predefined job tasks and their parameters. These job tasks are used in the Job Scheduling services.

Appendix F: Predefined Events

This appendix lists all predefined events and their parameters. These events are used in the Event Management system.

How to Use This Guide

The Oracle Enterprise Manager Administrator's Guide has been designed to be used closely with the Oracle7 Server documentation set. While this guide teaches you how to use Enterprise Manager to perform database administration tasks, the Oracle7 Server documentation set describes the reasons for and the implications of performing these tasks. Consequently, you should refer to the Oracle7 Server documentation set while using Enterprise Manager to perform your administrative tasks.

Before using Enterprise Manager, you should read "Overview of Enterprise Manager." After reading the chapter, you may choose to proceed directly to those chapters that are relevant to the tasks you plan to perform using Enterprise Manager.

Before using the Database Tools, you should read "Overview of the Database Tools." This chapter provides an overview of the organization and user interface elements of the tools.

Note: For an overview of the Enterprise Manager system, see Oracle Enterprise Manager Concepts.

Conventions Used in This Guide

The following sections explain the conventions used in this guide.

Syntax Diagrams

The syntax diagrams in this guide show the complete syntax for the Enterprise Manager commands. Syntax diagrams are composed of these items:

Keywords Keywords are words that have special meanings. In the syntax diagrams in this guide, keywords appear in uppercase. When you specify them, they can be in uppercase or lowercase, but they must be used exactly as they appear in the syntax diagram.

Parameters Parameters act as place holders in syntax diagrams. They appear in lowercase. Parameters are usually names of schema objects, Oracle datatypes, or expressions. When you see a parameter in a syntax diagram, you should substitute an object or expression of the appropriate type. Note that parameter names appear in italics in the text of this guide.

Graphic Components Syntax diagrams use lines and arrows to show syntactic structure. The following list shows combinations of lines and arrows and their meanings within railroad diagrams:

Examples

This guide also contains examples. This is an example of a SELECT statement: 

SELECT * FROM emp

Note that the text of examples appears in a different font than the text of the guide.

Examples in this guide follow these case conventions:

Special Icons

Special icons are provided to alert you to particular information within the body of this guide and within other manuals.

Additional Information: Operating System-Specific Documentation Where necessary, this guide refers you to your operating system-specific Oracle documentation for additional information.

Attention: The attention icon highlights information that is important to remember when performing the described task.

Suggestion: The suggestion icon signifies suggestions and practical hints that can be helpful when using Enterprise Manager.

Warning: The warning icon indicates information that you should be aware of before you perform the action described in the current section.

Documentation Set

The Oracle Enterprise Manager products documentation set consists of the following:

Note: The Oracle Enterprise Manager Application Developer's Guide will be available at a future release of Oracle Enterprise Manager.

Related Publications

The Oracle Enterprise Manager Administrator's Guide refers to important information in the related publications. The related books referred to in this guide are listed below:

Oracle Corporation also publishes several ASCII files, which are available on your distribution media. These files describe differences between minor releases of Oracle software that are not accompanied by new manuals. These files are usually named README.DOC, BUGFIX.DOC, BUGHST.DOC, and RESTRICT.DOC. Read these files to learn about changes to the software that are not described in the regular manuals.

The release notes for Enterprise Manager are also available on your distribution media. The file is commonly called README.TXT.

Additional Information: The exact names and locations of the files mentioned above may vary, depending on your operating system. See your operating system-specific Oracle documentation for information about these files.

Your Comments Are Welcome

We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. At the back of our printed manuals is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. If the form is not available, please use the following address.

Systems Management Products Documentation Manager

Oracle Corporation

500 Oracle Parkway

Redwood Shores, CA  94065

U.S.A.

Contents Index Home Previous Next

<Oracle Enterprise Manager Concepts GuideOracle Enterprise Manager Concepts Guide