How to Validate Applied Patch in Oracle

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**$$$$$$$

Click here for “Step by Step Apply Patch in Oracle.”

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

DBsGuru

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!

dbsguru.com/