How to Validate Applied Patch in Oracle

0 Comments

0
(0)

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.

 

 238 Total Views,  1 Views Today

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Spread the love

Leave a Reply

Your email address will not be published. Required fields are marked *

two × four =

Follow us on Social Media
Open chat
1
Contact Us:
Hi,

Greetings of the day! How can we help you?

Thanks.
Team DBsGuru
Direct Call:+91-9310167776
Email: info@dbsguru.com