Find Oracle patch set applied

Every once in a while you’ll need to find the patch level of your database.   With what I do on a daily basis, there are times when I need to gather this for many databases while on site somewhere. 

The easiest way to get this information is from the OPatch utility.  The OPatch utility can be found under $ORACLE_HOME/OPatch.

Example:

$ORACLE_HOME/OPatch/opatch lsinventory

The above command will list out all the currently applied patches to your Oracle environment using the files in the oraInventory.

To find this same information from inside the database, there are a two views that can be used.

Example:

SQL>select * from sys.v$version ;

SQL>select * from sys.registry$history;

I really like the sys.registry$history because if gives you a running history of your applied patches and upgrades.  Check it out next time you do an upgrade on your database.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Mrs. Jaye's Class Blog

Coordinate Algebra & Advanced Algebra

Pardy DBA

ORA-00001: unique constraint (ORA.BLOG_TAGLINE_PK) violated

Martin Widlake's Yet Another Oracle Blog

Oracle performance, Oracle statistics and VLDBs

HeliFromFinland

Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.

Julian Dontcheff's Database Blog

The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes

Martins Blog

Trying to explain complex things in simple terms

The Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet.com

Stuff that interests me, if not you!

%d bloggers like this: