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

Considerations after applying a patch


After a patch has been applied, there will be things that will change. It is a good idea to perform a backup after the patch has been applied and keep it in a safe place in case the Oracle Home or the Oracle Inventory get compromised due to a media failure or accidental deletion in future.

Oracle databases can still be created using DBCA, but if the patch modified the structure or contents of the database dictionary, then you must be aware that these changes are not replicated against the seed databases. So if you are using DBCA to create a new database using the current seeds, the scripts or other post apply procedures must be manually applied against the new database. If you create a new database using the CREATE DATABASE command, there is no need to apply the scripts that modify the database dictionary. These are already considered when the catproc.sql or catalog.sql scripts are run.

You should have a test plan so that after applying a patch you ensure...