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:
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 OEMGR 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.
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 this Guide Is Organized
This guide is divided into parts and chapters, as described below.
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.
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 Load functions.
Chapter 15, Managing Software Distribution
This chapter describes how to use the Software Manager to distribute software packages in the network system.
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 Oracle7 Server documentation set. While this guide describes 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 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.
While using the OEMGR 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 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 are words that 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 OEMGR.
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 guides are available on the Oracle Enterprise Manager CD in HTM format for viewing with a web browser. In addition to the OEMGR 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. The related books referred to in this guide are listed below:
- For general information about the Oracle7 Server and how it works, see the Oracle7 Server Concepts Guide.
- For information about administering the Oracle7 Server, see the Oracle7 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 Oracle7 Server, see the Oracle7 Server Application Developer's Guide.
- For the procedures for migrating a previous version of Oracle to Oracle7, see the Oracle7 Server Migration.
- For information on Oracle's SQL commands and functions, see the Oracle7 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 Oracle7 Server Messages.
- For information about the utilities bundled with the Oracle Server, including Export, Import, and SQL*Loader, refer to the Oracle7 Server Utilities.
- For information about distributing and replicating data, refer to Oracle7 Distributed Systems Volume I: Distributed Data and Volume II: Replicated Data.
- 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.
- For information about SQL*Net, see the SQL*Net documentation, which includes Understanding SQL*Net, the Oracle Network Manager Administrator's Guide, the Oracle Names Administrator's Guide, the Oracle Network Products Messages Manual, and the Oracle MultiProtocol Interchange Administrator's Guide.
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.
Note:
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. 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.
