Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Checking database patch level

Checking database patch level

0 Comments

Checking database patch level


  • You can check patched applied to Database home using below opatch command.

$ORACLE_HOME/OPatch lsinventory

  • You should validate it by running below sql. It will confirm post steps

SET LINESIZE 200 PAGESIZE 200
COL COMMENTS FORMAT A40
COL VERSION FORMAT A25
COL BUNDLE_SERIES FORMAT A20
COL ACTION_TIME FORMAT A35
SELECT COMMENTS,
VERSION,
BUNDLE_SERIES,
TO_CHAR(ACTION_TIME,'DD-MON-YYYY HH24:MI:SS') ACTION_TIME
FROM SYS.REGISTRY$HISTORY;



Posted on : 11/2/2017 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Oracle Database 19c is available via LiveSQL
Posted on :   1/21/2019

How Do I Find the Exadata Documentation, Such as Owner and User Guide
Posted on :   5/31/2018

Exachk 18.2.0_20180518 is available now…
Posted on :   5/20/2018

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved © 2013 Oracle-12c