Q
Manage Learn to apply best practices and optimize your operations.

How to use the OPatch Utility in Oracle

Expert Brian Peasland explains how to use the OPatch Utility to find the CPU patch level applied to the particular database.

Aside from OPatch, we can check $ORACLE_HOME/cpu to also verify the CPU patch level applied in the defined home. How can I find the CPU patch level applied to the particular database? Let's say I can't find the log file when catcpu.sql was run. What can I do?
The only tool I know of to use is the OPatch Utility. Basically, OPatch updates the oraInventory contents. When you use OPatch to see what has been applied, it queries the Inventory. Keep in mind that this does not show you if the catcpu.sql script was run against the database. I know of no view in Oracle that will tell you if this script was run.

Dig Deeper on Oracle database administration

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close