---查看数据库版本:
[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.
#由于没有安装补丁,所以显示没有安装。