Tuesday, May 3, 2011

Checking Oracle db patch level ...


Opatch is the tool.
You first find out the location of OPatch folder and then:

/oracle/my_oracle_home/OPatch>opatch lsinventory


Below is the result:
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Invoking OPatch 11.2.0.1.3

Oracle Interim Patch Installer version 11.2.0.1.3
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/WIP/112_64
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.3
OUI version       : 11.2.0.2.0
OUI location      : /oracle/WIP/112_64/oui
Log file location : /oracle/WIP/112_64/cfgtoollogs/opatch/opatch2011-05-03_11-39-20AM.log

Patch history file: /oracle/WIP/112_64/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /oracle/WIP/112_64/cfgtoollogs/opatch/lsinv/lsinventory2011-05-03_11-39-20AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.
===================================

Output from /oracle/WIP/112_64/cfgtoollogs/opatch/opatch2011-05-03_11-39-20AM.log


Date & Time : Tue May 03 11:38:10 CDT 2011
Oracle Home : /oracle/WIP/112_64
OPatch Ver. : 11.2.0.1.3
Current Dir : /oracle/my_oracle_home/OPatch
Command     : lsinventory
Log File    : /oracle/WIP/112_64/cfgtoollogs/opatch/opatch2011-05-03_11-38-10AM.log


Date & Time : Tue May 03 11:39:20 CDT 2011
Oracle Home : /oracle/WIP/112_64
OPatch Ver. : 11.2.0.1.3
Current Dir : /oracle/my_oracle_home/OPatch
Command     : lsinventory
Log File    : /oracle/WIP/112_64/cfgtoollogs/opatch/opatch2011-05-03_11-39-20AM.log

No comments:

Post a Comment