查看mysql补丁版本_查看数据库版本与补丁的版本信息

---查看数据库版本：

[oracle@susu ~]$ sqlplus -v

SQL*Plus: Release 11.2.0.4.0 Production

[oracle@susu ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 24 13:44:19 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

---查看补丁版本信息：

--查看DB的home目录：

[oracle@susu ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/dbhome_1

--进入DB的home目录：

[oracle@susu ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1

[oracle@susu dbhome_1]$ ls

apex         config  dc_ocm       susu.oracle.com_PROD  j2ee    lib      oc4j         ord      racg          sqlj             uix

assistants   crs     deinstall    has                   javavm  log      odbc         oui      rdbms         sqlplus          usm

bin          csmig   demo         hs                    jdbc    md       olap         owb      relnotes      srvm             utl

ccr          css     diagnostics  ide                   jdev    mesg     OPatch       owm      root.sh       suptools         wwg

cdata        ctx     dv           install               jdk     mgw      opmn         perl     scheduler     sysman           xdk

cfgtoollogs  cv      emcli        instantclient         jlib    network  oracore      plsql    slax          timingframework

clone        dbs     EMStage      inventory             ldap    nls      oraInst.loc  precomp  sqldeveloper  ucp

[oracle@susu dbhome_1]$ cd OPatch/

--执行./opatch lsinventory查看：

[oracle@susu OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-12-24_12-00-30PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-24_12-00-30PM.txt

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

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.4.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

#由于没有安装补丁，所以显示没有安装。