檢視資料庫版本與補丁的版本資訊

---檢視資料庫版本：

[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.

#由於沒有安裝補丁，所以顯示沒有安裝。