oracle 如何检查Oracle补丁是否安装？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22861503/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to check Oracle patches are installed?
提问by user3497717
How do I check that all services and patches are installed in Oracle?
如何检查 Oracle 中是否安装了所有服务和补丁？
I have an Oracle 10.2.0.2.0db version and want to install patches. Also I want to get a list with all services and patches.
我有一个Oracle 10.2.0.2.0db 版本，想安装补丁。我也想得到一个包含所有服务和补丁的列表。
回答by Up_One
Here is an article on how to check and or install new patches :
To find the OPatch tool setup your database enviroment variables and then issue this comand:
要找到 OPatch 工具，请设置您的数据库环境变量，然后发出以下命令：
cd $ORACLE_HOME/OPatch
> pwd
/oracle/app/product/10.2.0/db_1/OPatch
To list all the patches applies to your database use the lsinventoryoption:
要列出适用于您的数据库的所有补丁，请使用以下lsinventory选项：
[oracle@DCG023 8828328]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u00/product/11.2.0/dbhome_1
Central Inventory : /u00/oraInventory
from : /u00/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.1.0
Log file location : /u00/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-11-13_13-55-22PM_1.log
Lsinventory Output file location : /u00/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-11-13_13-55-22PM.txt
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 8405205 : applied on Mon Aug 19 15:18:04 BRT 2013
Unique Patch ID: 11805160
Created on 23 Sep 2009, 02:41:32 hrs PST8PDT
Bugs fixed:
8405205
OPatch succeeded.
To list the patches using sql :
要使用 sql 列出补丁：
select * from registry$history;
回答by bobdobbs
I understand the original post is for Oracle 10 but this is for reference by anyone else who finds it via Google.
我知道原来的帖子是针对 Oracle 10 的，但这是供任何通过 Google 找到它的人参考。
Under Oracle 12c, I found that that my registry$history is empty. This works instead:
在 Oracle 12c 下，我发现我的 registry$history 是空的。这可以代替：
select * from registry$sqlpatch;
回答by Steve
Maybe you need "sys." before:
也许你需要“系统”。前：
select * from sys.registry$history;
