Validate Applied Patches in Oracle 12c Onward
Whenever we do patch apply before / after, need to validate all applied patches in Oracle home & databases. Below are commands to validate patches in Oracle.
Command to validate applied patches on Oracle home. Click here to get sample output.
cd $ORACLE_HOME/OPatch/ or $ORACLE_HOME/OPatch/opatch lsinventory
SQL Command to validate applied patches in Oracle database. Click here to get sample output.
SET LINESIZE 400 COLUMN ACTION_TIME FORMAT A20 COLUMN ACTION FORMAT A10 COLUMN STATUS FORMAT A10 COLUMN DESCRIPTION FORMAT A40 COLUMN VERSION FORMAT A10 COLUMN BUNDLE_SERIES FORMAT A10 SELECT TO_CHAR(ACTION_TIME, 'DD-MON-YYYY HH24:MI:SS') AS ACTION_TIME, ACTION,STATUS,DESCRIPTION, VERSION,PATCH_ID,BUNDLE_SERIES FROM SYS.DBA_REGISTRY_SQLPATCH ORDER BY ACTION_TIME; prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.
118 total views, 1 views today
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?
Hello and welcome to DBsGuru,
DBsGuru is a group of experienced DBA professionals and serves databases and its related community by providing technical blogs, projects, training.
Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on.
Thanks for the visits!
Share Learn Grow!