How to know that OPatch is applied successfully or not on a 9.2.0.7 database?

    Requires Free Membership to View

Generally speaking, opatch will output error messages to the screen when applying a patch if it encounters problems or conflicts. If you did not see any errors displayed while applying the patch and the last message on the screen was that opatch succeeded, then you can be fairly certain that it completed successfully. You can, however, view log files that are created by opatch. Prior to running opatch, you should have created a hidden directory under $ORACLE_HOME called .patch_storage. This is where opatch will create log files each time it runs, even if only running an 'opatch lsinventory' command. Failing that, you could run an 'opatch lsinventory' command at any time to determine whether the patch shows as being installed.

This was first published in February 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.