首页 > 代码库 > oracle db打one-off-patch 一例

oracle db打one-off-patch 一例

2024-07-08 07:59:00   227人阅读

由于EBS form界面有一个报错，是一个小bug，以下打一个小patch修补一下。
【以下的过程没有停库】

解压p8496830_111070_Linux-x86-64.zip
cd 8496830
$ORACLE_HOME/OPatch/opatch apply -invPtrLoc /u01/ERPT1/db/tech_st/11.1.0/oraInst.loc

[ora@erpt1 8496830]$ $ORACLE_HOME/OPatch/opatch apply -invPtrLoc /u01/ERPT1/db/tech_st/11.1.0/oraInst.loc
Invoking OPatch 11.1.0.6.2
Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/ERPT1/db/tech_st/11.1.0
Central Inventory : /u01/oraInventory
   from : /u01/ERPT1/db/tech_st/11.1.0/oraInst.loc
OPatch version : 11.1.0.6.2
OUI version : 11.1.0.7.0
OUI location : /u01/ERPT1/db/tech_st/11.1.0/oui
Log file location : /u01/ERPT1/db/tech_st/11.1.0/cfgtoollogs/opatch/opatch2014-04-21_10-48-52AM.log
ApplySession applying interim patch ‘8496830‘ to OH ‘/u01/ERPT1/db/tech_st/11.1.0‘
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/ERPT1/db/tech_st/11.1.0‘)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch ‘8496830‘ for restore. This might take a while...
Backing up files affected by the patch ‘8496830‘ for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating archive file "/u01/ERPT1/db/tech_st/11.1.0/lib/libserver11.a" with "lib/libserver11.a/kxtt.o"
Running make for target ioracle
ApplySession adding interim patch ‘8496830‘ to inventory
Verifying the update...
Inventory check OK: Patch ID 8496830 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8496830 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.


检验是否成功实施
$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc /u01/ERPT1/db/tech_st/11.1.0/oraInst.loc | grep 8496830


联系
我们