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

Troubleshooting OPatch


There may be several circumstances that cause OPatch to fail in the patch apply task. The DBA must always read the instructions and make sure they are fully understood and the prerequisites are fully met. This reduces the number of possible failures during the patch apply process.

Let's assume a scenario; the DBA tries to apply a patch but it is only partially applied, OPatch works in an idempotent way, that is, the steps required by OPatch to apply a patch are executed only once. It doesn't matter how many times the user manually restarts the patch apply task. So if the user wants to rollback a partially applied patch the only way to start the rollback procedure is by first finishing the started patch apply task.

PATH environment variable

The PATH environment variable is critical. You must always make sure it is properly set and the OS commands required by OPatch are visible; otherwise, the patch process will fail.

OPatch log files

The OPatch log files are located under...