Preface

This chapter describes the purpose and organization of this guide. The following information is discussed:

Purpose of this Guide

This guide describes the Oracle Enterprise ManagerTM, Oracle's system management Console, common services, and integrated platform graphical tool. Oracle Enterprise Manager (OEMGR) includes database administration tools (DBA), plus it allows you to:

Monitor network and database objects
Schedule jobs
Monitor events
Manage and troubleshoot networks
Integrate participating third-party tools

This guide also describes Oracle Server ManagerTM, the line mode component of Oracle Enterprise Manager. Information in this guide applies to Oracle Enterprise Manager running on the Windows NT and Windows 95 32-bit platforms.

While using the Enterprise Manager products, you should refer to the online help for specific information on the displayed dialog box, menu, or window. You can display the online help by pressing F1 or selecting a Help button if present.

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

Audience

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

This guide assumes you are familiar with the administrative tasks you wish to perform. If you are not, refer to the Oracle server documentation set. The Oracle server documentation set contains specific and thorough descriptions of the database administration tasks you can perform with Enterprise Manager tools. In addition, the Oracle server documentation set provides recommendations on how to administer your database optimally. If you have not yet read the introductory chapters of the Oracle 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 this Guide Is Organized

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

Part I: Oracle Enterprise Manager and Console

Chapter 1, "Overview of Oracle 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, and the Daemon Manager.

Part II: The Database Administration 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, "Managing 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 Backup and Recovery"

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 Load functions.

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.

How to Use This Guide

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

Before using Enterprise Manager, you should read Chapter 1, "Overview of Oracle 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 administration tools, you should read Chapter 7, "Overview of the Database Tools". This chapter provides an overview of the organization and user interface elements of the tools.

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

Conventions Used in This Guide

The following sections explain the conventions used in this guide.

Examples

This guide contains code examples. Note that the text of examples appears in a different font than the text of the guide. This is an example of a SELECT statement:

SELECT * FROM emp

Examples in this guide follow these case conventions:

Keywords, such as CREATE and NUMBER, appear in uppercase. Keywords have special meanings. When you specify them, they can be in uppercase or lowercase, but they must be used exactly as they appear in the code example.
Names of database objects and their parts, such as emp and empno, appear in lowercase. However, in the text of this guide, names of database objects and their parts appear in uppercase.
Parameters act as place holders in examples. 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.

Special Text

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

Note:

This indicates important information related to Enterprise Manager.

Additional Information:

Where necessary, this refers you to your operating system-specific Oracle documentation for additional information.

Attention:

This highlights information that is important when performing the described task.

Suggestion:

This signifies suggestions and practical hints that can be helpful when using Enterprise Manager.

Warning:

This indicates information that you should be aware of before you perform the action described in the current section.

Product Documentation

The Oracle Enterprise Manager product documentation includes the following:

The Oracle Enterprise Manager Readme provides important notes regarding the updates to the software, documentation, and late-breaking news.
The Oracle Enterprise Manager Installation Guide provides information about installing Oracle Enterprise Manager components. This guide is in an insert in the Enterprise Manager CDRom.
The Oracle Enterprise Manager Configuration Guide provides information about configuring Oracle Enterprise Manager components.
The Oracle Enterprise Manager Concepts Guide provides an overview of the Enterprise Manager system.
The Oracle Enterprise Manager Administrator's Guide describes the components and features of the Oracle Enterprise Manager system.
The Oracle Performance Monitoring User's Guide, Oracle Expert User's Guide, Oracle Trace Developer's Guide, and Oracle Trace User's Guide provide information about performance monitoring applications.
The Oracle Enterprise Manager Messages Manual describes the Oracle Enterprise Manager error messages and methods for diagnosing the messages.
The Oracle Enterprise Manager Application Developer's Guide provides information on programming external interfaces to Oracle Enterprise Manager. The guide includes information on using Tcl and OraTcl to write custom job and event scripts.

The guides are available on the Oracle Enterprise Manager CD in HTML format for viewing with a web browser. In addition to the Enterprise Manager documentation, extensive online help is provided for Oracle Enterprise Manager components.

Related Publications

The Oracle Enterprise Manager Administrator's Guide refers to important information in the related publications. Depending on the version of the Oracle database, you would refer to the Oracle7 or Oracle8 documentation. The related books referred to in this guide are listed below:

For general information about the Oracle Server and how it works, see the Oracle Server Concepts Guide.
For information about administering the Oracle Server, see the Oracle Server Administrator's Guide.
For information about administering Oracle Parallel Servers, see the Oracle Parallel Server Support for the Oracle Enterprise Manager Console Guide.
For information about developing database applications within the Oracle Server, see the Oracle Server Application Developer's Guide.
For the procedures for migrating a previous version of Oracle to Oracle, see the Oracle Server Migration.
For information on Oracle's SQL commands and functions, see the Oracle Server SQL Reference.
For information about Oracle's procedural language extension to SQL, PL/SQL, see the PL/SQL User's Guide and Reference.
For information about Oracle messages and codes, refer to Oracle Server Messages.
For information about the utilities bundled with the Oracle Server, including Export, Import, and SQL*Loader, refer to the Oracle Server Utilities.
For information about distributing and replicating data, refer to the Oracle server distributed database systems and replication documentation.
For information about the Oracle networking system for Oracle8, see the Net8 documentation, which includes the Net8 Administrator's Guide. For information about SQL*Net, see the SQL*Net documentation, which includes the Oracle Network Manager Administrator's Guide.
For information specific to the Oracle Server working on your host operating system, see your operating system-specific Oracle documentation (specific book titles vary by operating system) and system release bulletins, if available.

Oracle Corporation also publishes several files that are available on your distribution media. These files are usually named README, RELNOTE, BUGHST, and RESTRICT and have extensions such as .WRI, .DOC, and .TXT. Read these files to learn about changes to the software or documentation that has not been described in the guides. The exact names and locations of the files mentioned above may vary, depending on your operating system.

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. Included in our 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.
Documentation Manager
Systems Management Products
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.