Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Using Enterprise Manager for software maintenance


Enterprise Manager can be used to perform software maintenance tasks. EM can be configured to access Metalink, query the patches required by the database, download them, and store them in a reserved area known as the Patch Cache; the DBA can take them from this region and schedule them to be applied at a later time. You must remember that there are licensing concerns; you require the Configuration Management Pack.

Enterprise Manager Metalink configuration

There are a couple of requirements the DBA must meet to have Enterprise Manager connected to Metalink and perform the Patch download process.

Configure the Metalink Credentials: This can be done by clicking on the setup link.

  1. 1. There will be a link named Patching Setup.

  2. 2. Here we will find the form where the Metalink credentials are stored.

  3. 3. In this form, there is a section to configure the Patch Cache.

  4. 4. Make sure to reserve enough space to store the patches to be downloaded.

The URL,...