Chapter 3: Getting Started with Oracle Enterprise Manager

Purpose

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.

Topics

This chapter discusses the following:

Starting the Enterprise Manager dbconsole Process
Accessing Enterprise Manager Database Control
Granting EM Administrative Privileges to Other Users
Defining Blackout Periods
Setting Preferred Credentials

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.

Starting the Enterprise Manager dbconsole Process

Back to Topic List

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

Move your mouse over this icon to see the image

 

2.

You can check the status of the dbconsole process by issuing the following command:


emctl status dbconsole

Move your mouse over this icon to see the image

 

Accessing Enterprise Manager (EM) Database Control

Back to Topic List

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.

Move your mouse over this icon to see the image

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.

Move your mouse over this icon to see the image

 

Back to Topic List

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.

Move your mouse over this icon to see the image

 

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.

Move your mouse over this icon to see the image

 

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.

Move your mouse over this icon to see the image

 

4.

The Create Administrator: Review page appears. Click Finish.

Move your mouse over this icon to see the image

 

5.

The Administrators page appears again and your new administrator is included in the administrator list.

Move your mouse over this icon to see the image

 

Defining Blackout Periods

Back to Topic 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.

Move your mouse over this icon to see the image

 

2.

The Setup page appears. Click Blackouts in the left hand pane.

Move your mouse over this icon to see the image

 

3.

The Blackouts page appears. Click Create to start the Create Blackout wizard.

Move your mouse over this icon to see the image

 

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.

Move your mouse over this icon to see the image

 

5.

Your database is now listed as a Selected Target. Click Next.

Move your mouse over this icon to see the image

 

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.

Move your mouse over this icon to see the image

 

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.

Move your mouse over this icon to see the image

 

8.

You receive a confirmation message that your blackout has been defined.

Move your mouse over this icon to see the image

 

Setting Preferred Credentials

Back to Topic List

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.

Move your mouse over this icon to see the image

 

2.

The Preferences page appears. Click Preferred Credentials in the left hand pane.

Move your mouse over this icon to see the image

 

3.

The Preferred Credentials page appears. Click the icon under Set Credentials for the Database Instance Target Type.

Move your mouse over this icon to see the image

 

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.

Move your mouse over this icon to see the image

 

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 see the image

 

Move your mouse over this icon to hide all screenshots

Copyright © 2004, Oracle Corporation. All rights reserved. Contact Us Legal Notices and Terms of UsePrivacy Statement