oracle opatch命令,Opatch常用命令测试日志及Opatch工具下载

一、操作系统平台:AIX 5L

二、Opatch常用命令测试日志

-----------------------------------------------------------------------------------------

Opatch用户指南中提示的命令

-----------------------------------------------------------------------------------------

$ 'opatch apply ...' is to apply a patch

$ 'opatch rollback ...' is to roll back a patch

$ 'opatch lsinventory' is to show installed patches

$ 'opatch lsinventory -detail' is to show installed products

$ 'opatch lsinventory -all' is to show all products on all Oracle Homes

$ 'opatch version' is to show version of OPatch

-----------------------------------------------------------------------------------------

Opatch需要解压在ORACLE_HOME下

-----------------------------------------------------------------------------------------

oracle@TSLP5096:/home/oracle>cd $ORACLE_HOME

oracle@TSLP5096:/home/oracle/product/9i>cd OP*

oracle@TSLP5096:/home/oracle/product/9i/OPatch>pwd

/home/oracle/product/9i/OPatch

oracle@TSLP5096:/home/oracle/product/9i/OPatch>ls

README.txt    emdpatch.pl   opatch        opatch.pl

docs          jlib          opatch.bat    perl_modules

-----------------------------------------------------------------------------------------

查看Opatch的版本

-----------------------------------------------------------------------------------------

oracle@TSLP5096:/home/oracle>opatch version

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

OPatch Version: 1.0.0.0.57

-----------------------------------------------------------------------------------------

因9206及9208的opatch存在bug,需要修改相关配置文件

-----------------------------------------------------------------------------------------

----------------------------不修改配置的情况下显示错误信息-------------------------------

oracle@TSLP5096:/bak/4523125>opatch apply

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /home/oracle/product/9i

Oracle Home Inventory : /home/oracle/product/9i/inventory

Central Inventory     : /home/oracle/oraInventory

from               : /etc/oraInst.loc

OUI location          : /home/oracle/product/9i/oui

OUI shared library    : /home/oracle/product/9i/oui/lib/aix/liboraInstaller.so

Java location         : /home/oracle/product/9i/jre/1.4.2/bin/java

Log file location     : /home/oracle/product/9i/.patch_storage//*.log

Creating log file "/home/oracle/product/9i/.patch_storage/4523125/Apply_4523125_

06-20-2007_16-06-25.log"

Invoking fuser to check for active processes.

Invoking fuser on "/home/oracle/product/9i/bin/oracle"

OPatch detects your platform as 610 while this patch 4523125 supports platforms:

212 (AIX-Based Systems (64-bit) 5L)

This patch is not suitable for this operating system.

Please contact support for the correct patch.

ERROR: OPatch failed during pre-reqs check.

-------------------------------修改配置文件--------------------------------

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>pwd

/home/oracle/product/9i/inventory/ContentsXML

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>ls

comps.xml                      oraclehomeproperties.xml

config.xml                     oraclehomeproperties.xml.fwei

libs.xml

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>echo "cat old xml"

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>cat old xml

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>cat oraclehomeproperties.xml.fwei

610

IBM_AIX

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>echo "cat modified xml"

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>cat modified xml

oracle@TSLP5096:/home/oracle/product/9i/inventory/ContentsXML>cat oraclehomeproperties.xml

212

IBM_AIX

-----------------------------------------------------------------------------------------

应用Opatch安装临时补丁

-----------------------------------------------------------------------------------------

oracle@TSLP5096:/bak/4523125>ls

README.txt  etc         files

oracle@TSLP5096:/bak/4523125>opatch apply

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /home/oracle/product/9i

Oracle Home Inventory : /home/oracle/product/9i/inventory

Central Inventory     : /home/oracle/oraInventory

from               : /etc/oraInst.loc

OUI location          : /home/oracle/product/9i/oui

OUI shared library    : /home/oracle/product/9i/oui/lib/aix/liboraInstaller.so

Java location         : /home/oracle/product/9i/jre/1.4.2/bin/java

Log file location     : /home/oracle/product/9i/.patch_storage//*.log

Creating log file "/home/oracle/product/9i/.patch_storage/4523125/Apply_4523125_

06-20-2007_15-24-37.log"

Invoking fuser to check for active processes.

Invoking fuser on "/home/oracle/product/9i/bin/oracle"

Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the lo

cal system only.

Please shut down Oracle instances running out of this ORACLE_HOME

(Oracle Home = /home/oracle/product/9i)

Is this system ready for updating?

Please respond Y|N >

y

Applying patch 4523125...

Patching archive files...

Running make for target ioracle.

Inventory is good and does not have any dangling patches.

Updating inventory...

Verifying patch...

Backing up comps.xml ...

OPatch succeeded.

-----------------------------------------------------------------------------------------

应用Opatch安装临时补丁的版本情况

-----------------------------------------------------------------------------------------

oracle@TSLP5096:/bak/4523125>opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /home/oracle/product/9i

Oracle Home Inventory : /home/oracle/product/9i/inventory

Central Inventory     : /home/oracle/oraInventory

from               : /etc/oraInst.loc

OUI location          : /home/oracle/product/9i/oui

OUI shared library    : /home/oracle/product/9i/oui/lib/aix/liboraInstaller.so

Java location         : /home/oracle/product/9i/jre/1.4.2/bin/java

Log file location     : /home/oracle/product/9i/.patch_storage//*.log

Creating log file "/home/oracle/product/9i/.patch_storage/LsInventory__06-20-200

7_15-26-20.log"

Result:

Installed Patch List:

=====================

1) Patch 4523125 applied on Wed Jun 20 15:25:20 GMT+08:00 2007

[ Base Bug(s): 4523125  ]

OPatch succeeded.

-----------------------------------------------------------------------------------------

应用Opatch卸载临时补丁

-----------------------------------------------------------------------------------------

oracle@TSLP5096:/bak/4523125>opatch rollback -id 4523125

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /home/oracle/product/9i

Oracle Home Inventory : /home/oracle/product/9i/inventory

Central Inventory     : /home/oracle/oraInventory

from               : /etc/oraInst.loc

OUI location          : /home/oracle/product/9i/oui

OUI shared library    : /home/oracle/product/9i/oui/lib/aix/liboraInstaller.so

Java location         : /home/oracle/product/9i/jre/1.4.2/bin/java

Log file location     : /home/oracle/product/9i/.patch_storage//*.log

Creating log file "/home/oracle/product/9i/.patch_storage/4523125/RollBack_45231

25_06-20-2007_15-59-46.log"

Invoking fuser to check for active processes.

Invoking fuser on "/home/oracle/product/9i/bin/oracle"

Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the lo

cal system only.

Please shut down Oracle instances running out of this ORACLE_HOME

(Oracle Home = /home/oracle/product/9i)

Is this system ready for updating?

Please respond Y|N >

y

Removing patch 4523125...

Restoring archive files...

Running make for target  ioracle.

Updating inventory...

Backing up comps.xml ...

Inventory is good and does not have any dangling patches.

OPatch succeeded.

oracle@TSLP5096:/bak/4523125>opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.57

Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under

OPatch/docs for usage reference. We also recommend using

the latest OPatch version. For the latest OPatch version

and other support related issues, please refer to document

293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /home/oracle/product/9i

Oracle Home Inventory : /home/oracle/product/9i/inventory

Central Inventory     : /home/oracle/oraInventory

from               : /etc/oraInst.loc

OUI location          : /home/oracle/product/9i/oui

OUI shared library    : /home/oracle/product/9i/oui/lib/aix/liboraInstaller.so

Java location         : /home/oracle/product/9i/jre/1.4.2/bin/java

Log file location     : /home/oracle/product/9i/.patch_storage//*.log

Creating log file "/home/oracle/product/9i/.patch_storage/LsInventory__06-20-200

7_16-00-52.log"

Result:

There is no Interim Patch

OPatch succeeded.

-----------------------------------------------------------------------------------------

三、Opatch工具下载

756574a0034eb45c503d9a82cc52f5dc.gif

2007-6-21 08:42 上传

点击文件名下载附件

305.39 KB, 下载次数: 773

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle OPatch P2400611 是一个用于 Oracle 数据库软件的补丁包。112040 表示该补丁包适用于 Oracle 数据库软件的版本为 11.2.0.x,其中 x 表示具体的版本号,可以是 0、1、2 等。 要下载这个补丁包,首先需要登录到 Oracle 官方网站,然后找到 Patch 平台。在 Patch 平台上,可以搜索补丁包编号 P2400611。找到该补丁包后,可以点击下载按钮进行下载下载补丁包之前,需要确认当前系统的操作系统是 Linux,并且版本符合 11.2.0.x 的要求。检查数据库版本和操作系统版本的方法可以在数据库控制台中运行相关命令来查询。 在下载补丁包之后,需要将补丁包解压到合适的目录中。然后,需要使用 Oracle OPatch 工具进行补丁的安装。在安装补丁之前,可以先检查一下当前系统上已经安装的补丁的情况,以确保不会产生冲突或者覆盖之前的补丁。 安装补丁之前,最好先备份数据库,以免发生意外。然后,使用 OPatch 命令进行补丁的安装。在安装过程中,可能会需要提供一些必要的参数,如 ORACLE_HOME 等。 补丁安装完成之后,可以使用 OPatch 命令进行验证,以确保补丁已成功安装。可以检查数据库的日志文件、警告日志和 alert.log 文件来确认补丁的安装情况。 总结起来,Oracle OPatch P2400611 是一个适用于 Oracle 数据库软件版本为 11.2.0.x 的 Linux 补丁包。要下载和安装该补丁包,首先需要登录 Oracle 官方网站,找到 Patch 平台,并搜索补丁包编号进行下载。安装补丁时需谨慎,并备份数据库,以确保顺利完成。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值