learn-oracle





Setting Up Enterprise Manager Preferences


PREVIOUS CHAPTER | NEXT CHAPTER

Setting Up Enterprise Manager Preferences

Enterprise manager enables Oracle DBA to set up preferences that help Oracle DBA manage the database. These include the following:

Notification---These are settings that enable Oracle to email Oracle DBA alert notifications. Alerts are notifications of when a database is in an undesirable state and needs your attention. By default, the Enterprise Manager home page lists all alerts. However, set up is required for email notification.

Blackout Administration---When Oracle DBA have planned downtime for database maintenance, you can indicate to Oracle that you do not want false alerts to be sent to you. To do so, you define a black out period. See Defining Blackout Time Periods in this section.



Preferred Credentials---Enterprise Manager can automatically execute many routine administrative tasks, such as backups on your behalf. This is done using sophisticated job scheduling system built into the Enterprise. To keep your environment secure, setting up tasks for automatic execution in Enterprise Manger requires Oracle DBA to provide login information for the machine and database. In order to avoid having to enter this information every time Oracle DBA create a job or task, Enterprise Manager enables Oracle DBA to save this information as preferred credentials. Preferred credentials are stored in the database in encrypted mode to protect it from unauthorized use. See Setting Preferred Credentials in this section.

Defining Blackout Time Periods

When Oracle DBA plan to bring your database down for maintenance, you can indicate that you do not want alert notifications to be sent to Oracle DBA. Alerts are notifications of when the database is in an undesirable state and needs your attention.

To define a blackout time period, follow these steps

1. From the home page, click Setup at the top of the page. The Setup page appears.

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

3. Click Create. This starts the Create Blackout wizard. On the Properties page, name your blackout, and select the target that has planned downtime. Click Next.

4. On the Schedule page, enter the start time of your planned blackout, or choose immediately if you are bringing the database down now. Also select the duration of the blackout, either as indefinite, as a length or time, or until a time in the future. Under Repeating, accept the default of Do Not Repeat. If you want to repeat the blackout periodically, Oracle DBA can select a repeat frequency in the pull down menu. Click Next.

5. The review page appears. Review what you have entered, and if satisfied, click Finish. If not, you can click Back to change a setting.

Setting Preferred Credentials

Oracle DBA can have Enterprise Manager automatically fill in host and database login credentials for you, such as when you schedule jobs and tasks to perform administrative operations like backup and recovery. For security, Oracle stores preferred credentials in encrypted mode.

To set preferred credentials for the database, do the following:

1. From the home page, click Preferences at the top of the page. The Preferences page appears.

2. Click Preferred Credentials in the left hand pane. The Preferred Credentials page appears. For the Database target, click the icon under Set Credentials. The Database Preferred Credentials page appears.

3. For your database, enter the credentials for Normal Username/Password, SYSDBA Username/Password, and Host Username/Password.

4. Click Test to test your credentials. Oracle DBA should get a confirmation message if your credentials can be verified.

5. Click Apply to apply the changes.

PREVIOUS CHAPTER | NEXT CHAPTER

STEP 3 - Next Topics
This introduces Oracle DBA to the Oracle Enterprise Manager, the Web-based interface for managing an Oracle database. Understanding this tool is essential to managing the Oracle database. Learn Oracle DBA Step 3 by clicking links below:
Starting the Oracle Enterprise Manager ConsoleOracle DBA
Accessing the Oracle Enterprise Manager DatabaseOracle DBA
Granting Database Control Administrative PrivilegeOracle DBA
Setting Up Enterprise Manager PreferencesOracle DBA

More Tutorials on Oracle dba ...

Source : Oracle Documentation

Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information




Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info