Oracle OPatch工具-小记

最新推荐文章于 2021-12-24 09:39:49 发布
转载 最新推荐文章于 2021-12-24 09:39:49 发布 · 250 阅读 · 0
标签
#数据库 #java #runtime
本文详细介绍了Oracle OPatch工具的使用方法，包括如何查看OPatch版本、列出已安装的产品及补丁等操作，并展示了正确的命令语法。
Oracle OPatch工具
oracle@linux-u72z:~/product/10.2.0/db_1/OPatch> pwd
/opt/oracle/product/10.2.0/db_1/OPatch
# version
oracle@linux-u72z:~/product/10.2.0/db_1/OPatch> ./opatch version
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
#opatch lsinvertory
oracle@linux-u72z:~/product/10.2.0/db_1/OPatch> ./opatch lsinvertory
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
Syntax Error... Unrecognized Command or Option (lsinvertory): 1st argument must be one of the following:
      apply
      napply
      rollback
      nrollback
      lsinventory
      lsinv
      query
      util
      prereq
      version
      -help
      -h
Please use the option 'opatch  -help' to get correct syntax
OPatch failed with error code 14
# opatch lsinventory -detail
oracle@linux-u72z:~/product/10.2.0/db_1/OPatch> $ORACLE_HOME/OPatch/opatch lsinventory -detail
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.

Oracle Home       : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-10-21_13-11-32PM.log
Patch history file: /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2012-10-21_13-11-32PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4                           10.2.0.5.0a
There are 2 products installed in this Oracle Home.

Installed Products (193):
Agent Required Support Files                                         10.2.0.1.0
Agent Required Support Files Patch                                   10.2.0.5.0
Assistant Common Files                                               10.2.0.1.0
Assistant Common Files Patch                                         10.2.0.5.0
Bali Share                                                           1.1.18.0.0
Bali Share                                                           1.1.19.0.0
Buildtools Common Files                                              10.2.0.1.0
Buildtools Common Files                                              10.2.0.5.0
Character Set Migration Utility                                      10.2.0.1.0
Character Set Migration Utility Patch                                10.2.0.5.0
Database Configuration and Upgrade Assistants                        10.2.0.1.0
Database Configuration and Upgrade Assistants Patch                  10.2.0.5.0
Database SQL Scripts                                                 10.2.0.1.0
Database SQL Scripts Patch                                           10.2.0.5.0
Database Workspace Manager                                           10.2.0.1.0
Database Workspace Manager                                           10.2.0.5.0
DBJAVA Required Support Files                                        10.2.0.1.0
DBJAVA Required Support Files Patch                                  10.2.0.5.0
Enterprise Edition Options                                           10.2.0.1.0
Enterprise Manager Agent Core                                        10.2.0.1.0
Enterprise Manager Agent Core Patch                                 10.2.0.5.0a
Enterprise Manager Agent DB                                          10.2.0.1.0
Enterprise Manager Agent DB                                          10.2.0.5.0
Enterprise Manager Baseline                                          10.2.0.1.0
Enterprise Manager Baseline                                          10.2.0.5.0
Enterprise Manager Common Core Patch                                10.2.0.5.0a
Enterprise Manager Common Files                                      10.2.0.1.0
Enterprise Manager Minimal Integration                               10.2.0.1.0
Enterprise Manager Minimal Integration                               10.2.0.5.0
Enterprise Manager plugin Common Files                               10.2.0.1.0
Enterprise Manager plugin Common Files                               10.2.0.1.0
Enterprise Manager plugin Common Files Patch                         10.2.0.5.0
Enterprise Manager Repository Core                                   10.2.0.1.0
Enterprise Manager Repository Core patch                            10.2.0.5.0a
Enterprise Manager Repository DB                                     10.2.0.1.0
Enterprise Manager Repository DB                                     10.2.0.5.0
Generic Connectivity Common Files                                    10.2.0.1.0
Generic Connectivity Common Files Patch                              10.2.0.5.0
HAS Common Files                                                     10.2.0.1.0
HAS Common Files Patch                                               10.2.0.5.0
HAS Files for DB                                                     10.2.0.1.0
HAS Files for DB Patch                                               10.2.0.5.0
Installation Common Files                                            10.2.0.1.0
Installation Common Files Patch                                      10.2.0.5.0
Installer SDK Component                                              10.2.0.5.0
iSQL*Plus                                                            10.2.0.1.0
iSQL*Plus                                                            10.2.0.5.0
Java Runtime Environment                                             1.4.2.14.0
JDBC Common Files                                                    10.2.0.1.0
JDBC Common Files                                                    10.2.0.5.0
LDAP Required Support Files                                          10.2.0.1.0
LDAP Required Support Files Patch                                    10.2.0.5.0
OLAP SQL Scripts                                                     10.2.0.1.0
OLAP SQL Scripts Patch                                               10.2.0.5.0
Oracle Advanced Security                                             10.2.0.1.0
Oracle Advanced Security Patch                                       10.2.0.5.0
Oracle Call Interface (OCI)                                          10.2.0.1.0
Oracle Call Interface (OCI) Patch                                    10.2.0.5.0
Oracle Clusterware RDBMS Files                                       10.2.0.1.0
Oracle Clusterware RDBMS Files Patch                                 10.2.0.5.0
Oracle Code Editor                                                   1.2.1.0.0I
Oracle Configuration Manager                                         10.3.2.1.0
Oracle Containers for Java                                           10.2.0.1.0
Oracle Containers for Java                                           10.2.0.5.0
Oracle Core Required Support Files                                   10.2.0.1.0
Oracle Core Required Support Files Patch                             10.2.0.5.0
Oracle Data Mining RDBMS Files                                       10.2.0.1.0
Oracle Data Mining RDBMS Files Patch                                 10.2.0.5.0
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g interMedia Files                                 10.2.0.1.0
Oracle Database 10g interMedia Files Patch                           10.2.0.5.0
Oracle Database 10g Patch                                            10.2.0.5.0
Oracle Database 10g Patch                                            10.2.0.5.0
Oracle Database 10g Release 2 Patch Set 4                           10.2.0.5.0a
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            10.2.0.1.0
Oracle Database Utilities Patch                                      10.2.0.5.0
Oracle Display Fonts                                                  9.0.2.0.0
Oracle Enterprise Manager Console DB                                 10.2.0.1.0
Oracle Enterprise Manager Console DB                                 10.2.0.5.0
Oracle Extended Windowing Toolkit                                    3.4.38.0.0
Oracle Globalization Support                                         10.2.0.1.0
Oracle Globalization Support Patch                                   10.2.0.5.0
Oracle Help For Java                                                  4.2.6.1.0
Oracle Help for the  Web                                             1.1.10.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle interMedia                                                    10.2.0.1.0
Oracle interMedia Annotator                                          10.2.0.1.0
Oracle interMedia Annotator                                          10.2.0.5.0
Oracle interMedia Client Option                                      10.2.0.1.0
Oracle interMedia Client Option Patch                                10.2.0.5.0
Oracle interMedia Java Advanced Imaging                              10.2.0.1.0
Oracle interMedia Java Advanced Imaging Patch                        10.2.0.5.0
Oracle interMedia Locator                                            10.2.0.1.0
Oracle interMedia Locator Patch                                      10.2.0.5.0
Oracle interMedia Locator RDBMS Files                                10.2.0.1.0
Oracle interMedia Locator RDBMS Files Patch                          10.2.0.5.0
Oracle interMedia Patch                                              10.2.0.5.0
Oracle Internet Directory Client                                     10.2.0.1.0
Oracle Internet Directory Client Patch                               10.2.0.5.0
Oracle Java Client                                                   10.2.0.1.0
Oracle Java Client Patch                                             10.2.0.5.0
Oracle JDBC Thin Driver for JDK 1.2                                  10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2 Patch                            10.2.0.5.0
Oracle JDBC Thin Driver for JDK 1.4                                  10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.4 Patch                            10.2.0.5.0
Oracle JDBC/OCI Instant Client                                       10.2.0.1.0
Oracle JDBC/OCI Instant Client Patch                                 10.2.0.5.0
Oracle JFC Extended Windowing Toolkit                                4.2.33.0.0
Oracle JVM                                                           10.2.0.1.0
Oracle JVM Patch                                                     10.2.0.5.0
Oracle LDAP administration                                           10.2.0.1.0
Oracle LDAP administration patch                                     10.2.0.5.0
Oracle Locale Builder                                                10.2.0.1.0
Oracle Message Gateway Common Files                                  10.2.0.1.0
Oracle Message Gateway Common Files Patch                            10.2.0.5.0
Oracle Net                                                           10.2.0.1.0
Oracle Net Listener                                                  10.2.0.1.0
Oracle Net Listener Patch                                            10.2.0.5.0
Oracle Net Patch                                                     10.2.0.5.0
Oracle Net Required Support Files                                    10.2.0.1.0
Oracle Net Required Support Files Patch                              10.2.0.5.0
Oracle Net Services                                                  10.2.0.1.0
Oracle Notification Service                                          10.1.0.3.0
Oracle Notification Service Patch                                    10.2.0.5.0
Oracle ODBC Driver                                                   10.2.0.1.0
Oracle ODBC Driver Patch                                             10.2.0.5.0
Oracle OLAP                                                          10.2.0.1.0
Oracle OLAP API                                                      10.2.0.1.0
Oracle OLAP API Patch                                                10.2.0.5.0
Oracle OLAP Patch                                                    10.2.0.5.0
Oracle OLAP RDBMS Files                                              10.2.0.1.0
Oracle OLAP RDBMS Files Patch                                        10.2.0.5.0
Oracle One-Off Patch Installer                                       10.2.0.4.2
Oracle Partitioning                                                  10.2.0.1.0
Oracle Programmer                                                    10.2.0.1.0
Oracle RAC Required Support Files-HAS                                10.2.0.1.0
Oracle RAC Required Support Files-HAS Patch                          10.2.0.5.0
Oracle Real Application Testing                                      10.2.0.5.0
Oracle Recovery Manager                                              10.2.0.1.0
Oracle Recovery Manager Patch                                        10.2.0.5.0
Oracle Spatial                                                       10.2.0.1.0
Oracle Starter Database                                              10.2.0.1.0
Oracle Starter Database Patch                                        10.2.0.5.0
Oracle Text                                                          10.2.0.1.0
Oracle Text Patch                                                    10.2.0.5.0
Oracle UIX                                                           2.1.22.0.0
Oracle UIX                                                           2.2.24.6.0
Oracle Universal Installer                                           10.2.0.5.0
Oracle Wallet Manager                                                10.2.0.1.0
Oracle Wallet Manager Patch                                          10.2.0.5.0
Oracle XML Development Kit                                           10.2.0.1.0
Oracle XML Development Kit Patch                                     10.2.0.5.0
Parser Generator Required Support Files                              10.2.0.1.0
Parser Generator Required Support Files                              10.2.0.5.0
Perl Interpreter                                                      5.8.3.0.2
PL/SQL                                                               10.2.0.1.0
PL/SQL                                                               10.2.0.5.0
PL/SQL Embedded Gateway                                              10.2.0.1.0
PL/SQL Embedded Gateway Patch                                        10.2.0.5.0
Platform. Required Support Files                                      10.2.0.1.0
Platform. Required Support Files                                      10.2.0.5.0
Precompiler Common Files                                             10.2.0.1.0
Precompiler Common Files Patch                                       10.2.0.5.0
Precompiler Required Support Files                                   10.2.0.1.0
Precompiler Required Support Files Patch                             10.2.0.5.0
RDBMS Required Support Files                                         10.2.0.1.0
RDBMS Required Support Files for Instant Client                      10.2.0.1.0
RDBMS Required Support Files for Instant Client Patch                10.2.0.5.0
RDBMS Required Support Files Patch                                   10.2.0.5.0
regexp                                                                2.1.9.0.0
Required Support Files                                               10.2.0.1.0
Sample Schema Data                                                   10.2.0.1.0
Sample Schema Data Patch                                             10.2.0.5.0
Secure Socket Layer                                                  10.2.0.1.0
Secure Socket Layer Patch                                            10.2.0.5.0
SQL*Plus                                                             10.2.0.1.0
SQL*Plus                                                             10.2.0.5.0
SQL*Plus Required Support Files                                      10.2.0.1.0
SQL*Plus Required Support Files Patch                                10.2.0.5.0
SQLJ Runtime                                                         10.2.0.1.0
SQLJ Runtime Patch                                                   10.2.0.5.0
SSL Required Support Files for InstantClient                         10.2.0.1.0
SSL Required Support Files for InstantClient Patch                   10.2.0.5.0
Sun JDK                                                             1.4.2.14.05
Sun JDK extensions                                                   10.1.2.0.0
XDK Required Support Files                                           10.2.0.1.0
XDK Required Support Files Patch                                     10.2.0.5.0
XML Parser for Java                                                  10.2.0.1.0
XML Parser for Java Patch                                            10.2.0.5.0
XML Parser for Oracle JVM                                            10.2.0.1.0
XML Parser for Oracle JVM Patch                                      10.2.0.5.0
There are 193 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------
OPatch succeeded.

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

转载于:http://blog.itpub.net/17252115/viewspace-747032/

cuilian2013
关注
OPatch 的更新，以及安装oracle的小补丁
wll的专栏
10-18 6695
1、根据数据库的版本下载最新的OPatch 2、把旧的$ORACLE_HOME/OPatch目录备份，然后把最新下载的OPatch 拷贝到$ORACLE_HOME下 3、应用新的补丁    从9.2版开始，Oracle公司实现了个别补丁安装工具opatch. opatch使用一个称为inventory的系统数据结构（严格说是与oui共享inventory），集中管理所
oracle patch查看,如何查看Oracle补丁 - opatch 的使用
weixin_39919089的博客
04-03 331
pldfmsqcdb$opatchInvoking OPatch 10.2.0.4.2Oracle Interim Patch Installer version 10.2.0.4.2Copyright (c) 2007, Oracle Corporation. All rights reserved.Syntax Error... No command specified.Usage: opa...
oracle在opatch lsinventory时报错OPatch failed with error code 73
脑子进水养啥鱼？的博客
05-21 3856
报错信息如下：[oracle@p2:/oracle/app/oracle/product/10.2.0/db_1/OPatch]$./opatch lsinventoryInvoking OPatch 10.2.0.4.3Oracle Interim Patch Installer version 10.2.0.4.3Copyright (c) 2007, Oracle Corporation. ...
Oracle 更新Opatch、打补丁
堅持╅信念★
06-29 1213
1.更新Opatch; 2.打补丁; 3.grid 打补丁; 1.更新Opatch(实验版本:oracle:11.2.0.3.0):  默认安装数据库后,在ORACLE_HOME 下会有个OPatch 文件夹,更新前先检查当前Opatch 版本:  [oracle@sywu2 OPatch]$ ./opatch lsinventory  Invoking OPatch 11.2
安装oraInventory和使用opatch给Oracle打补丁
conghuan4367的博客
01-27 339
opatch是给Oracle打补丁的工具，命令使用起来简单方便。他默认地址在$ORACLE_HOME/OPatch/opatch,直接运行会显示所有可用命令。 > $ORACLE_HOME/OPatch/opat...
oracle补丁冲突,oracle 打补丁常见问题
weixin_35762250的博客
04-02 1056
oracle 打补丁常见问题发布时间：2020-07-17 23:57:26来源：51CTO阅读：2562作者：春秋小记psu下载文档 ID Master Note for Database Proactive Patch Program (文档 ID 756671.1)url：https://support.oracle.com/epmos/faces/DocumentDisplay?_ad...
Oracle11.2.0.3 RAC打PSU补丁
clv18753的博客
03-05 557
导读：oracle 11.2.0.3.0集群打补丁一、概要本篇主要介绍一下如何在11.2.0.3.0集群环境下使用OPatch进行打补丁。二、准备工作1. 检查系统环境根据cpu型号和oracle版本号选取相应的补丁包（注意是3...
oracle opatch 工具的使用(oracle小补丁安装)（转）
congrang4672的博客
03-15 440
从9.2版开始，Oracle公司设计实现了个别补丁安装管理工具opatch.opatch使用一 个称为inventory的系统数据结构（严格说是与oui共享inventory），集中管理所有已安装的个别补丁；个别 补丁的...
Oracle的Opatch升级 11.2.0.4.0 到 11.2.0.4.7
翔之天空的专栏
09-25 7533
1、查看数据库版本 进入Oracle安装的opatch目录： [oracle@localhost OPatch]$ pwd /u01/app/oracle/product/11.2.0/db_1/OPatch 查询opatch版本： [oracle@localhost OPatch]$ ./opatch version OPatch Version: 11.2.
em管理器的BUG
coolfire1977的博客
12-18 380
背景环境：操作系统：suse linux 11 sp1数据库：oracle 10.2.0.5问题：不能使用em管理器，但是10.2.0.1是可以用的，打了补丁就不行了。[@more@]问题解决办法：此为oracle数据库在该版本...
安装指定版本 GCC 编译器 error: unrecognized command line option 解决方案
TJDFDG的博客
12-24 3万+
GCC的安装 Linux下gcc编译器升级 make时出现 error: unrecognized command line option 错误升级gcc解决
ORACLE查看补丁出现“OPatch failed with error code 1”
weixin_34273046的博客
04-12 1460
案例场景：               在Oracle Linux Server release 5.7上安装完ORACLE 10g后，顺便将PSR（Patch Set Release）p6810189_10204_Linux-x86-64.zip也安装了。结果在查看补丁时出现了下面情况 [oracle@DB-Server OPatch]$ ./opatch lsinventory Invo...
OPatch failed with error code 2
乡下人
07-30 1551
在检查补丁冲突时报错code 2 [oracle@DBMONITOR01 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2018, Oracle Corporation. All rights ...
OPatch failed with error code 104报错
AwenStyle
02-18 2923
 1、执行opatch apply打补丁的时候，报OPatch failed with error code 104错误， 找不到有效的oraInst.loc文件，具体如下所示： oracle@kevin.example.com:~/linux_patch/12419384> opatch apply Invoking OPatch 11.1.0.8.5 Oracle Inter
OPatch failed with error code 73
09-14 1132
安装Grid psu补丁，安装的过程中报下面73的错误 [root@zxdb01 OPatch]# ./opatch auto /tools/21150904/20996944 -oh /u01/app/11.2.0/grid...
解决OPatch failed with error code 73错误
cuiji5713的博客
02-16 7143
在打oracle补丁时候有时会报OPatch failed with error code 73错误 这里记录了两种常见的错误 第一种： [oracle@odd-PROD1 147273...
【ERROR】OPatch failed with error code 73
civbl2961的博客
09-06 2557
一、问题描述 今天要给Oracle数据库软件打补丁，操作过程中报错 “OPatch failed with error code 73” ，通过具体报错信息后得知是libclntsh.so.11.1...
check database patch with opatch tools
cr147369的博客
07-20 202
当给数据库打完patch以后，如何查询是否打patch成功？ 或者，刚刚接到一个数据库服务器，如何查询这个数据库服务器都曾经打过哪些patch？ 1. 下载并安装opatch工具 下载：p6880880...
opatch报错OPatch failed with error code 2
立格技术专栏
11-29 5691
安装补丁前进行补丁冲突检查，首先进到已解压的补丁目录，如： [grid@md01 ~]$ cd 21523375/ [grid@md01 21523375]$ opatch prereq CheckConflictAgainstOHWithDetail  -phBaseDir ./ Oracle Interim Patch Installer version 11.2.0.3.12 C
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值