SQL*Plus (MOSC)

MOSC Banner

query latest patch level (PSU and OJVM). How to do that?

edited Mar 3, 2016 4:08AM in SQL*Plus (MOSC) 1 commentAnswered

Hi.

Is there any way to extract current patchlevel from sqlplus ?
I'm interested to know the latest/newest PSU and OJVM patchset (marked in red).

For example:

set linesize 150

set pagesize 100

col ACTION_TIME format a25

col VERSION format a20

col ID format 9,999,999

col COMMENTS format a30

col BUNDLE_SERIES format a15

col NAMESPACE format a15

col ACTION format a20
select to_char(ACTION_TIME, 'DD-Mon-YYYY HH24:MI:SS') AS "ACTION_TIME", ACTION, VERSION, COMMENTS, BUNDLE_SERIES from registry$history;


ACTION_TIME           ACTION           VERSION          COMMENTS                   BUNDLE_SERIES

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

01-Oct-2013 22:55:45  APPLY            11.2.0.4         Patchset 11.2.0.2.0        PSU
13-Nov-2014 15:56:24  APPLY            11.2.0.4         Patchset 11.2.0.2.0        PSU

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