Jak jsem psal v článku Problém 26Z Grid controlu jsem dostával neustále chybové hláškyMessage=Access violation errors have been found in the alert log. Poté co jsem požádal Oracle product support o backport, byl mě poskytnut patch.Přikládám tedy příklad jak aplikovat patch na rdbms databázi.
Patch jsem nahrál na server a rozbalil.
oracle@server:/opt/source> unzip p9594372_112010_LINUX.zipArchive: p9594372_112010_LINUX.zip creating: 9594372/ creating: 9594372/files/ creating: 9594372/files/lib/ creating: 9594372/files/lib/libserver11.a/ inflating: 9594372/files/lib/libserver11.a/koks3.o creating: 9594372/etc/ creating: 9594372/etc/config/ inflating: 9594372/etc/config/inventory.xml inflating: 9594372/etc/config/actions.xml
inflating: 9594372/etc/config/deploy.xml creating: 9594372/etc/xml/ inflating: 9594372/etc/xml/GenericActions.xml inflating: 9594372/etc/xml/ShiphomeDirectoryStructure.xml inflating: 9594372/README.txt
Zkontroloval jsem verzi perlu.
oracle@server:/opt/source> perl -vThis is perl, v5.10.0 built for i586-linux-thread-multi
Nastavil si cestu pro opatch. Opatch je utilita pomocí které se patchuje.
oracle@server:/opt/source> export PATH=$PATH:$ORACLE_HOME/OPatchoracle@server:/opt/source> which opatch/opt/oracle/product/11gR1/db/OPatch/opatch
Zkontroloval jsem inventory.
oracle@server:/opt/source> opatch lsinventoryInvoking OPatch 11.1.0.6.6Oracle Interim Patch Installer version 11.1.0.6.6Copyright (c) 2009, Oracle Corporation. All rights reserved.Oracle Home : /opt/oracle/product/11gR1/dbCentral Inventory : /opt/oraInventory from : /etc/oraInst.locOPatch version : 11.1.0.6.6OUI version : 11.2.0.1.0OUI location : /opt/oracle/product/11gR1/db/ouiLog file location : /opt/oracle/product/11gR1/db/cfgtoollogs/opatch/opatch2010-06-21_06-11-10AM.logPatch history file: /opt/oracle/product/11gR1/db/cfgtoollogs/opatch/opatch_history.txtLsinventory Output file location : /opt/oracle/product/11gR1/db/cfgtoollogs/opatch/lsinv/lsinventory2010-06-21_06-11-10AM.txt——————————————————————————–Installed Top-level Products (1):Oracle Database 11g 11.2.0.1.0There are 1 products installed in this Oracle Home.There are no Interim patches installed in this Oracle Home.——————————————————————————–OPatch succeeded.Poznámka: Posledni verzi opatch získáte z metalinku Note 224346.1 – Opatch – Where Can I Find the Latest Version of Opatch?
Vlastní palikace patche. Před patchováním musíte databázi zastavit.
oracle@server:/opt/source/9594372> opatch applyInvoking OPatch 11.1.0.6.6Oracle Interim Patch Installer version 11.1.0.6.6Copyright (c) 2009, Oracle Corporation. All rights reserved.Oracle Home : /opt/oracle/product/11gR1/dbCentral Inventory : /opt/oraInventory from : /etc/oraInst.locOPatch version : 11.1.0.6.6OUI version : 11.2.0.1.0OUI location : /opt/oracle/product/11gR1/db/ouiLog file location : /opt/oracle/product/11gR1/db/cfgtoollogs/opatch/opatch2010-06-21_06-15-03AM.logPatch history file: /opt/oracle/product/11gR1/db/cfgtoollogs/opatch/opatch_history.txtApplySession applying interim patch ‘9594372’ to OH ‘/opt/oracle/product/11gR1/db’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 = ‘/opt/oracle/product/11gR1/db’)Is the local system ready for patching? [y|n]yUser Responded with: YBacking up files and inventory (not for auto-rollback) for the Oracle HomeBacking up files affected by the patch ‘9594372’ for restore. This might take a while…Backing up files affected by the patch ‘9594372’ for rollback. This might take a while…Patching component oracle.rdbms, 11.2.0.1.0…Updating archive file “/opt/oracle/product/11gR1/db/lib/libserver11.a” with “lib/libserver11.a/koks3.o”Running make for target ioracleApplySession adding interim patch ‘9594372’ to inventoryVerifying the update…Inventory check OK: Patch ID 9594372 is registered in Oracle Home inventory with proper meta-data.Files check OK: Files from Patch ID 9594372 are present in Oracle Home.The local system has been patched and can be restarted.OPatch succeeded.Databáze je opatchovaná. Nastarujte ji a chybové hlšení by se již nemělo objevovat.