Q

Was OPatch applied successfully?

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

How to know that OPatch is applied successfully or not on a 9.2.0.7 database?
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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close