which patchset update is installed on my oracle database ?

August 23, 2013 — 1 Comment

a question which pops up regulary is how one can find out which psu is installed on an oracle database. there are at least two possibilities.

if you have access to the server use opatch:

$ORACLE_HOME/OPatch/opatch lsinventory | grep "Database Patch Set Update"
Patch description:  "Database Patch Set Update : 11.2.0.2.8 (14275621)"
Sub-patch  13923804; "Database Patch Set Update : 11.2.0.2.7 (13923804)"
Sub-patch  13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"

if you don’t have access to the server but can connect as sys:

col comments for a60
col version for a30
set lines 264
select version,comments from registry$history where comments like '%PSU%';

VERSION 		       COMMENTS
------------------------------ ------------------
11.2.0.2		       PSU 11.2.0.2.3
11.2.0.2		       PSU 11.2.0.2.4
11.2.0.2		       PSU 11.2.0.2.8

you may even check if the database was upgraded from a previous release:

select version,comments from registry$history where comments like '%Upgraded%';

VERSION 		       COMMENTS
------------------------------ ------------------------
11.2.0.3.0		       Upgraded from 11.2.0.2.0
Advertisements

Trackbacks and Pingbacks:

  1. dbms_qopatch « Daniel Westermann's Blog - November 9, 2013

    […] time ago I blogged on how to list the installed patches for an oracle database. if you are on 12c there is another […]

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