This chapter introduces you to Oracle Enterprise Manager Database
Control. The Oracle Universal Installer installs Oracle Enterprise Manager Database
Control when you install the Oracle software. Enterprise Manager Database Control
provides a Web-based interface that you can use to manage your Oracle instance
and database.
Move your mouse over this icon to show all screenshots.
You can also move your mouse over each individual icon to see only the screenshot
associated with it.
The dbconsole process must be started for you to access Oracle
Enterprise Manager Database Control from a client browser. The dbconsole process
is automatically started after installation. If the process is not started,
you can manually start it at the command line as follows:
1.
Log on to the operating system as the oracle
user. Issue the following command to start the dbconsole process:
emctl start dbconsole
2.
You can check the status of the dbconsole process by
issuing the following command:
You can access the Oracle Enterprise Manager Database Control
as follows:
1.
Open your Web browser and enter the following URL:
http://<hostname>:1158/em
2.
The Database Control Login page is displayed
if the instance is started. Enter a username and password for a user that
is authorized to access the Oracle Enterprise Manager Database Control.
Click Login.
Note: If this is the first time you have accessed
Enterprise Manager Database Control, you may see a page concerning licensing.
Review the information and respond appropriately to your situation.
Refer to Chapter 5 for detailed instructions on starting
the instance and opening the database.
3.
The Database Home page is displayed. You can
access the Performance, Administration, and Maintenance
property pages from the Database Home page.
Granting EM Administrative Privileges to
Other Users
In this section you will learn how to grant management privileges
to other database users. Administrators are database users defined in the Management
Repository who can log in to Enterprise Manager to perform management tasks.
The breadth of management tasks available in Enterprise Manager depends on the
privileges and roles assigned to the administrators.
Perform the steps listed below to grant management privileges
to other database users:
1.
Click Setup at the top of the Database Home
page.
2.
The Administrators list is displayed. Click Create
to create a new Enterprise Manager user by assigning the management privileges
to an existing database user. The Create Administrator: Properties
page is displayed.
3.
In this step you will grant administrative privileges
to the HR user. Enter the
following values:
Name: HR
Password: HR
Note: You can click the flashlight icon next
to the Name field to select an existing database user from the
pop-up window.
Click Finish.
4.
The Create Administrator: Review page appears.
Click Finish.
5.
The Administrators page appears again and your
new administrator is included in the administrator list.
When you plan to bring your database down for maintenance,
you can indicate that you do not want alert notifications to be sent to you
by defining a blackout period. Blackouts also allow you to suspend monitoring
in order to perform other maintenance operations. You can define a blackout
time period in Enterprise Manager Database Control by performing the following
steps:
1.
Click Setup at the top of the Database Home
page.
2.
The Setup page appears. Click Blackouts
in the left hand pane.
3.
The Blackouts page appears. Click Create
to start the Create Blackout wizard.
4.
Enter a name for your blackout in the Name field.
You can also add comments in the Comments field although it is
not a required a field. Select Enter a new reason and enter a reason
for your blackout. Select Database Instance in the type drop-down
menu in the Available Targets region. Select your database and
click Move to add it to the Selected Targets list.
5.
Your database is now listed as a Selected Target. Click Next.
6.
The Create Blackout: Schedule page appears. Enter
the start time of your planned blackout, or choose immediately if you
are shutting down the database now. Select the duration of the blackout,
either as indefinite, as a length or time, or until a time in the future.
Accept the default of "Do Not Repeat" or select a repeat
frequency in the Repeat pull down menu. Click Next.
7.
The Create Blackout: Review page appears. Review
what you have entered and click Finish. You can click Back if you
need to change a setting.
8.
You receive a confirmation message that your blackout
has been defined.
You can set Preferred Credentials so that Enterprise Manager
will automatically supply host and database login credentials for you when you
schedule jobs and tasks to perform administrative operations like backup and
recovery. For security, Oracle stores preferred credentials in encrypted mode.
You can set preferred credentials in Enterprise Manager Database Control by
performing the following steps:
1.
Click Preferences at the top of the Database
Home page.
2.
The Preferences page appears. Click Preferred
Credentials in the left hand pane.
3.
The Preferred Credentials page appears. Click
the icon under Set Credentials for the DatabaseInstanceTarget Type.
4.
The Database Preferred Credentials page appears.
Enter the credentials in the form of username and password
for normal, SYSDBA and host connections. Click Test.
5.
You receive a confirmation message that your credentials
have been verified. Click Apply to save your preferred credentials.
Move your mouse over this icon to hide all screenshots
Bookmark
