ITPub博客

首页 > 数据库 > Oracle > 查看数据库版本与补丁的版本信息

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

原创 Oracle 作者:skyin_1603 时间:2016-12-24 13:39:25 0 删除 编辑

---查看数据库版本:

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

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

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31392094/viewspace-2131313/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: AIX topas命令详解
请登录后发表评论 登录
全部评论

注册时间:2016-09-06

  • 博文量
    231
  • 访问量
    215103