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

Oracle maintenance using OPatch


There are several situations when an interim patch is required. The most common one is to apply patches that correct specific bugs which you have encountered. Another situation where software maintenance is required is when Oracle releases the quarterly Critical Patch Update bundle. The patch task can consist of applying a single patch or several patches at once. Specific detailed instructions are always available in the companion README file.

Note

Never skip the README file and never take a patch for granted; you may face particular circumstances that, if neglected, may leave your software in an unstable condition.

In case something goes wrong or you want to uninstall the patch OPatch, always performs a backup of the affected files so you can apply a rollback procedure to return things to how they were when OPatch session has started.

Note

It is strongly suggested to have an Oracle Home, Oracle Inventory, and a backup of the database handy just in case something...