oracledb打one-off-patch一例

2014-11-24 11:43:50 · 作者: · 浏览: 0
因为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