Release 1.4.0
A53707_01
 Library |
 Product |
 Contents |
 Index |
| Oracle Enterprise Manager Concepts Guide Release 1.4.0 A53707_01 |
|
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 |
|---|---|
Refer to the Oracle Enterprise Manager Administrator's Guide for detailed information on the DBA applications.
The Common Features section discusses the following common elements shared by the DBA applications.
| Topic | See Page |
|---|---|
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.
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.
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.
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.
Advanced Mode displays additional property sheets that allow you to access an application's advanced database administration features.
The Oracle Enterprise Manager provides easy-to-use DBA tools for administrative tasks. The Database Tools section contains the following topics.
Additional applications can be purchased to allow you to:
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.
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 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.
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:
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.
The Oracle Enterprise backup and recovery subsystems 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:
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:
This option transfers data from an Oracle database to an Oracle binary operating system file. The file can then be used with the import operation.
This option transfers data to an Oracle database that has been exported from an Oracle database.
This option loads data from operating system files, such as text files, to an Oracle database.
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.
