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

OPatch in Oracle 11g


You should be aware that OPatch is tool sensitive to the version. You cannot use the OPatch tool from one release to patch another release. Oracle 11g introduced several new options. The next three images show the OPatch syntax in 11g, how it changed from the 10g release, and which options were added in this release.

Here you can see from the syntax summary that there were many more options added, and in the next two images, the syntax of the new options is shown. The util commands are depicted in the next image. The commands available are used to apply SQL commands, clean up the backup, perform file copies, restore an Oracle Home, or perform other remove or rollback actions.

In the next image the detailed options of the prereq command are shown. The prereq command listed is used to check the central inventory, look for conflicting patches, verify the Oracle home, OUI, and Oracle installer locations, among other checking operations. These options are particularly useful...