第一部分:检查oracle数据库补丁版本
1. 查看所有版本信息:
oracle@NDMCDB03:~/product/11g/db/OPatch> ./opatch lsinventory
Invoking OPatch 11.1.0.8.2
Oracle Interim Patch Installer version 11.1.0.8.2
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/11g/db
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.8.2
OUI version : 11.1.0.7.0
OUI location : /opt/oracle/product/11g/db/oui
Log file location : /opt/oracle/product/11g/db/cfgtoollogs/opatch/opatch2011-09-13_15-34-15PM.log
Patch history file: /opt/oracle/product/11g/db/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/oracle/product/11g/db/cfgtoollogs/opatch/lsinv/lsinventory2011-09-13_15-34-15PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 11g 11.1.0.6.0
Oracle Database 11g Patch Set 1 11.1.0.7.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 9352179 : applied on Tue Aug 09 12:09:19 CST 2011
Unique Patch ID: 12289084
Created on 1 Apr 2010, 01:07:34 hrs PST8PDT
Bugs fixed:
7378322, 9068088, 8348