Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.



Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |


Lesson 09

"The average person thinks he isn't." - Father Larry Lorenzoni


Read first then play the video:

   OEM-VIDEO -Managing Groups and Events


Managing Groups and Events using OEM



As a DBA, you are responsible for managing a groupís item and an eventís item. The following is a summary of your task:


Creating a Group

Obtaining a background picture

Assigning databases to a group

Creating an Oracle Event

Assigning Access Privileges of an Event

Assigning target database to an Event

Testing a created event

Scheduling a frequent run of an Event

Notifying users

Registering an Event

Adding an Event to the Repository Library

Refreshing the CONSOLE

Obtaining a Red Flag



In this exercise you will learn how to create a group and assign a databases to it, create an event to check the databases if they are up or down using the Oracle Enterprise Management tool (OEM).

Expand the Group item. Notice that there are no groups.

Highlight "Group", and click on the "Create" icon.

In the create window, make sure that the Group item is highlighted then click "Create."

In the Create Group window, enter the group name.

Select your background picture.

Select the databases to the "Targets" window.

On the "Access" tab, make sure the right user has full access.

On the "View" tab, locate the database icon on where they physically are placed.

Then create the Group item.

The group was created.

Highlight the ISELFSCHOOLING group.

On the Event menu, click "Create Event"

Enter the event name, then select the database to have a red flag if the database is down and have a green flag if the database if up and running.

On the Tests tab, expand the fault item and select the "Database UpDown" test.

On the "Parameters" tab, notice that no parameter is needed.

On the "Schedule" tab, check the event every minute.

On the "Access" tab, notify the supper user (SYSMAN). Then, click on the Show Notification Schedule" button.

On the "Notification Schedule" window, notify the SYSMAN user from 6:00a.m to 7:00pm every day.

Then close the window.

Now, register the event and add it to the repository library.

To enforce to see the green or red flag, refresh the console.

Notice that the green flag were displayed. The green flag indicates the database is up and running.