Release 1.6.0
A63730-01
Library |
Product |
Contents |
Index |
| Oracle
Enterprise Manager Concepts Guide
Release 1.6.0 A63730-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 do the following tasks:
This chapter contains the following topics on DBA applications:
| Topic | See Page |
|---|---|
For detailed information on the DBA applications refer to
the Oracle Enterprise Manager Administrator's Guide.
This section discusses the following common elements shared by the DBA applications:
| Topic | See Page |
|---|---|
|
Record and Play-Back |
|
In the standard suite of database applications included in
Oracle Enterprise Manager, all the tools provide a navigator tree list
for organizing groups and instances associated with the application. The
tree list is similar to the Navigator tree list in the Console.
Each application's navigator tree displays on the left side
of the application window after the application has successfully connected
to a database. A database's groups and instances are usually contained
in the database folder which is the root of the navigator and displays
the name of the database that the application is connected to. For example,
in the Oracle Security Manager application, the tree list has containers
for users, roles, and profiles.
When you select a container, a multi-column list of rows
displays on the right side of the application window. Each row in the list
provides a quick summary of information about an object in the selected
container.
When you select a container's object in the tree list, the
object's property sheet appears on the right side of the application. A
property sheet is a dialog box with one or more tabbed pages and is used
to specify options for an object when you are creating or altering a composite
instance such as a user or a tablespace.
The standard DBA applications 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 Oracle Security Manager
and the logging mechanism to record the granting of the privileges, and
then use the Job system to perform the assignment at the ten databases.
The Advanced Mode option in the View menu displays or hides
additional property sheets that allow you to access an application's advanced
database administration features.
This section explains each of the standard DBA tools included in Oracle Enterprise Manager.
Additional applications can be purchased to allow you to
diagnose your database system and manage a replication environment.
With Oracle 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, Sessions,
and In-Doubt Transactions folders display in a navigator tree on the left
side of the Instance Manager window. These folders are contained in the
root 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 containers and objects selected on the left side of the screen.
The right side may contain a multi-column scrolling list or a property
sheet.
A new Oracle8 option, SHUTDOWN TRANSACTION <time-out>,
gives the user only the length of the specified time-out period to finish
transactions. During this time, no users can start new transactions on
the instance. Instead, users must failover to a backup instance to start
a transaction. If time-out is not specified, users are not disconnected
until the last transaction completes.
Another new Oracle8 option, DISCONNECT POST_TRANSACTIONAL,
is useful if the database administrator wants to disconnect a session but
not until its current transaction has been finished. This option is possible
when choosing Disconnect from the Sessions menu in Instance Manager.
In Instance Manager, you can also change the archivelog mode
for a database. By selecting Archive Log in the Database menu, you enable
or disable archivelog mode. The database is shut down and restarted whenever
the archivelog mode is changed.
With Oracle 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 the application window.
The navigator consists of a series of schema object containers which are
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 containers and objects selected on the left side of the screen.
The right side may contain a multi-column scrolling list or property sheet.
The scrolling lists contain information about each schema object, such
as status, owner, creation date and last date modified.
Oracle Security Manager allows you to control the security
of Oracle databases and manage 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 users'
profiles and roles are in constant change. Oracle Security Manager simplifies
making these necessary changes by providing security lists which an administrator
can access to see the profiles and roles that have been assigned to a set
of users. Property sheets can then be used to quickly specify the security
parameters for each database.
With Oracle Storage Manager you can perform DBA tasks associated
with managing database storage. The navigator tree in the Storage Manager
consists of Tablespaces, Datafiles, and Rollback Segments containers. By
selecting these containers and their contents you can perform storage management
tasks which include managing tablespaces and rollback segments and adding
and renaming datafiles. You can also launch other database tools and utilities
from the application.
With Oracle 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; so you can use SQL Worksheet to edit and re-execute an earlier
command without having to re-type it. You can also 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.
Oracle Backup Manager is used to manage your database backup
and recovery environment. The subsystem availability of Backup Manager
depends on the version of the database you are attempting to back up. When
logging into 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 automates the transfer of data to and
from an Oracle database and provides Data Manager Wizards to guide you
through the steps. Data Manager also provides job tasks that can be submitted
with the Job Scheduling system.
The Data Manager Wizards can be accessed in the Data menu and include Export, Import, and Load wizard options for performing the following tasks:
This option transfers data from an Oracle database to an Oracle binary operating system file. The import operation can then transfer the data from this file to an Oracle database.
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.
The Oracle Software Manager application allows all software in a network to be managed from a central location. This product addresses the problems faced by application software administrators by offering the following features:
The Oracle Enterprise Manager/Oracle Software Manager network
is made up of one or more Oracle Enterprise Manager/Oracle Software Manager
installations, each of which administers a host server containing an Intelligent
Agent.
Oracle Net8 Assistant is a tool for configuring and managing
your Oracle network environment with Net8. Net8 is Oracle's interface to
standard communications protocols that allows for the proper transmission
of data between computers. Using Net8 assistant, you can configure and
manage profiles, service names, listeners, and Oracle names servers.
