Database Administration (MOSC)

MOSC Banner

PSU patch applied?

edited Sep 19, 2017 3:58PM in Database Administration (MOSC) 9 commentsAnswered

opatch says I applied the last psu to 11.2.0.4, but OEM says it is not applied.  How do you query 11.2.0.4 and 12.1.0.2 to and read what is and isn't applied?

> opatch lsinventory | grep -i description

ARU platform description:: Linux x86-64

Patch description:  "OJVM PATCH SET UPDATE 11.2.0.4.170718"

Patch description:  "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

select version, comments from sys.registry$history where comments like '%PSU%';

VERSION        COMMENTS

------------------------------ ----------------------------------------

11.2.0.4        PSU 11.2.0.4.160119

11.2.0.4.6OJVMBP        OJVM PSU post-install

11.2.0.4        PSU 11.2.0.4.160419

11.2.0.4.160419OJVMPSU        OJVM PSU post-install

11.2.0.4        PSU 11.2.0.4.160719

11.2.0.4.160719OJVMPSU        OJVM PSU post-install

11.2.0.4        PSU 11.2.0.4.161018

11.2.0.4.161018OJVMPSU        OJVM PSU post-install

11.2.0.4.170117OJVMPSU        OJVM PSU post-install

11.2.0.4        PSU 11.2.0.4.170418

11.2.0.4.170418OJVMPSU        OJVM PSU post-install

11.2.0.4        PSU 11.2.0.4.170718

11.2.0.4.170718OJVMPSU        OJVM PSU post-install

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center