Setting Database Control Preferences

Set : Database Control Preferences

It contains :

1. About Database Control Preferences
2. Defining Blackout Periods
3. Setting Preferred Credentials

About Database Control Preferences

Set User Preferences -

Notification : Enable Database Control to e-mail you alerts. Alerts are notifications that the database is in an undesirable state and needs your attention. By default, the Database Home page lists all alerts. However, setup is required for e-mail notification.

Blackout Administration : Suspend the collection of database monitoring data and the sending of alerts by Database Control. Blackouts enable you to perform scheduled maintenance on the database without receiving needless alerts and without skewing the monitoring data.

Preferred Credentials : Database Control can automatically execute many routine administrative tasks, such as backups. Use a job scheduling system that is built into Database Control for these routine tasks.

To keep your environment secure, setting up tasks for automatic execution in Enterprise Manager requires you to provide login information for the host computer and database. To avoid entering this information every time you create or run a job or task, Database Control enables you to save this information as preferred credentials.

Preferred credentials are stored in the database in encrypted mode to protect them from unauthorized use.

-----xXx-----

 

Defining Blackout Periods

You can define one or more one-time or repeating blackout periods during which collection of database monitoring information and the sending of alerts are suspended.

To define a blackout period :

1. On any Database Control page, at the top of the page, click Setup.

The Enterprise Manager Configuration page appears, showing the Overview of Setup page.

2. In the left-hand pane, click Blackouts.

The Blackouts page appears.

3. Click Create to start the Create Blackout wizard.

The Create Blackout : Properties page appears.

 

Optional :

i. Replace the default blackout name with one of your choosing.
ii. In the Comments field, enter text that describes the purpose of the blackout.

4. In the Reason list, select the blackout reason that is most appropriate.

5. In the Available Targets section, in the Type list, select Database Instance.

The fully qualified name for your database instance appears in the Available Targets list.

6. In the Available Targets list, select your instance, and then click the Move icon.

Note :
You can also double-click the instance name.

The instance name is moved from the Available Targets list to the Selected Targets list.

7. Click Next.

The Create Blackout Schedule page appears.

 

8. On the Create Blackout Schedule page, do the following:

a. In the Start section, schedule the blackout either immediately or for a later date and time.

b. In the Duration section, indicate the duration of the blackout.

c. To repeat the blackout periodically, in the Repeating section, select a repeat frequency from the Repeat list. Otherwise, use the default value of Do Not Repeat.

9. Click Next.

The review page appears.
Review what you have entered. You can click Back to change a setting.

10. Click Finish.

The Confirmation heading appears on the Blackouts page, and the new blackout period is shown in the list.

-----xXx-----

Setting Preferred Credentials

When you set preferred credentials, Database Control automatically fills in host computer and database login credentials for you at times when it usually prompts for these credentials. Database Control also fills in these credentials when it is about to run a job that requires credentials.

To set preferred credentials for the database:

1. From any Database Control page, at the top of the page, click Preferences.
The Preferences page appears.

2. Click Preferred Credentials in the left-hand pane.
The Preferred Credentials page appears, showing a table of targets.

 

3. In the table row for the Database Instance, click the icon under Set Credentials.
The Database Preferred Credentials page appears.

4. 

i. Database credentials for Username/Password and SYSDBA Username/SYSDBA Password.

ii. Host credentials for Host Username/Host Password.

5. Click Test to test your credentials.
A confirmation message is displayed if your credentials can be verified.

6. Click Apply to apply the changes.

-----xXx-----