经验首页 前端设计 程序设计 Java相关 移动开发 数据库/运维 软件/图像 大数据/云计算 其他经验
当前位置：技术经验 » 数据库/运维 » Oracle » 查看文章
OPATCH在线补丁
来源：cnblogs　　作者：九命猫幺　　时间：2019/8/27 9:48:30　　对本文有异议

如果补丁中有online目录就是在线补丁，不需要数据库停机，在线的又分集群和非集群，如下

image查看readme可以得知在线补丁打法

  1. $ cat README.txt 
  2. Oracle Database 11g Release 11.2.0.3.0
  3. ORACLE DATABASE Patch for Bug# 12834800 for Linux-x86 Platforms
  4.  
  5. (RAC Rolling Installable and Online Installable Patch)
  6.  
  7. (DG Rolling Installable)
  8.  
  9. Released: Sat Jan 28 10:03:32 2012
  10.  
  11. This document describes how you can install the ORACLE DATABASE combo patch for bug#  12834800 on your Oracle Database 11g Release 11.2.0.3.0.
  12.  
  13. A combo patch is a patch that can be applied either in offline mode or in online mode. For information about offline and online modes of patching, see My Oracle Support note 761111.1 available at:
  14. https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=761111.1
  15.  
  16. (1) Prerequisites
  17. ------------------
  18. Before you install or deinstall the patch, ensure that you meet the following requirements:
  19. Note: In case of an Oracle RAC environment, meet these prerequisites on each of the nodes.
  20.  
  21. 1.      Ensure that the Oracle Database on which you are installing the patch or from which you are rolling back the patch is Oracle Database 11g Release (11.2.0.3.0).
  22.  
  23. 2.      Oracle recommends you to use the latest version of OPatch. 
  24.         If you do not have the latest version, then follow the instructions outlined in the My Oracle Support note 224346.1 available at:
  25.         https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1 
  26.  
  27. 3.      Ensure that you set the ORACLE_HOME environment variable to the Oracle home of the Oracle Database.
  28.  
  29. 4.      Ensure that you set the PATH environment variable to include the location of the unzip executable, and the /bin and the /OPatch directories present in the Oracle home of the Oracle Database.
  30.  
  31. 5.      Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command. If the command displays some errors, then contact Oracle Support and resolve the issue.
  32.         $ opatch lsinventory 
  34. 6.      (Only for Offline Patching) Ensure that you shut down all the services running from the Oracle home.
  36. 7.      (Only for Online Patching) Ensure that all the services in the Oracle home are up and running.
  38. 8.      (Only for Online Patching) Ensure that you maintain adequate memory on your system to apply this online patch. To calculate the amount of memory required for this online patch, use the following formula:
  39.         Memory Consumed = (Number of Oracle Processes + 1) X (Size of Patched .pch File) 
  41. Note:
  42. -       For UNIX, the number of Oracle processes is determined by checking the parameter "processes" in the database by querying v$parameter. For Microsoft Windows, the number of Oracle processes is always zero (0).
  43. -       The .pch file is available under /files/hpatch/ directory.
  45. (2) Installation
  46. -----------------
  47. This section describes the following modes you can use to install the combo patch. Use the one that best suits your requirement. 
  48. -       Installing in Offline Mode
  49. -       Installing in Online Mode
  51. (2.1) Installing in Offline Mode
  52. -----------------------------------
  53. To  install the patch in offline mode, follow these steps:
  54. Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
  56. 1.      Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as .
  58. 2.      Extract the contents of the patch ZIP file to the location you created in Step (1). To do so, run the following command:
  59.         $ unzip -d  p12834800_112030_LINUX.zip
  61. 3.      Navigate to the /12834800 directory:
  62.         $ cd /12834800
  64. 4.      Install the patch by running the following command:
  65.         $ opatch apply
  67.         Note: 
  68.         When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME of the Oracle Database. OPatch categorizes conflicts 
  69.         into the following types: 
  70.         -       Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
  71.         -       Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply  - In this case, continue with the patch installation because the new patch 
  72.                 contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
  74. 5.      Start the services from the Oracle home.
  77. (2.2) Installing in Online Mode
  78. -----------------------------------
  79. To  install the patch in online mode, follow these steps:
  80. Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
  82. 1.      Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as .
  84. 2.      Extract the contents of the patch ZIP file to the location you created in Step (1). To do so, run the following command:
  85.         $ unzip -d  p12834800_112030_LINUX.zip
  87. 3.      Navigate to the /12834800 directory:
  88.         $ cd /12834800
  90. 4.      Install the patch by running the following command:
  91.         -       For Non-RAC Environments (Standalone Databases):  
  92.                 $ opatch apply online -connectString ::: 
  93.         -       For RAC Environments: 
  94.                 $ opatch apply online -connectString :::,:::,:::
  96.         Note:
  97.         -       Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NodeN refers to the different nodes of the 
  98.                 Oracle RAC system. Once the patch is applied on the first node, OPatch automatically moves over and patches the next node you have specified in the comamnd. 
  99.         -       When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME of the Oracle Database. OPatch categorizes conflicts 
  100.                 into the following types: 
  101.         -       Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply  - In this case, continue with the patch installation because the new patch 
  102.                 contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
  103.         -       Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
  105. 5.      Start the services from the Oracle home.
  108. (3) Deinstallation
  109. --------------------
  110. This section describes the following modes you can use to deinstall the combo patch. Use the one that best suits your requirement. 
  111. -       Deinstalling in Offline Mode
  112. -       Deinstalling in Online Mode
  114. (3.1) Deinstalling in Offline Mode
  115. -------------------------------------
  116. To deinstall the patch in offline mode, follow these steps:
  117. Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
  119. 1.      Navigate to the /12834800 directory:
  120.         $ cd /12834800
  122. 2.      Deinstall the patch by running the following command:
  123.         $ opatch rollback -id 12834800
  125. 3.      Start the services from the Oracle home.
  128. (3.2) Deinstalling in Online Mode
  129. --------------------------------------
  130. To deinstall the patch in online mode, follow these steps:
  131. Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
  133. 1.      Navigate to the /12834800 directory:
  134.         $ cd /12834800
  136. 2.      Deinstall the patch by running the following command:
  137.         -       For Non-RAC Environments (Standalone Databases):  
  138.                 $ opatch rollback -id 12834800 -connectString :::
  139.         -       For RAC Environments: 
  140.                 $ opatch rollback -id 12834800 -connectString :::,:::,:::
  142.         Note:
  143.         Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NODEn refers to the different nodes of the 
  144.         Oracle RAC system. Once the patch is rolled back from the first node, OPatch automatically moves over and rolls back the patch from the next node you have specified in the comamnd. 
  146. 3.      Start the services from the Oracle home.
  149. (4) Bugs Fixed by This Patch
  150. ---------------------------------
  151. The following are the bugs fixed by this patch:
  152.   12834800: ORA-7445 [QKXRPXFORMUNM()+92]
  155. --------------------------------------------------------------------------
  156. Copyright 2012, Oracle and/or its affiliates. All rights reserved.

打个补丁

  1. $ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply online -connectString PROD4:sys:oracle:
  2. Invoking OPatch 11.2.0.1.7
  3.  
  4. Oracle Interim Patch Installer version 11.2.0.1.7
  5. Copyright (c) 2011, Oracle Corporation.  All rights reserved.
  6.  
  7.  
  8. Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
  9. Central Inventory : /u01/app/oraInventory
  10.    from           : /etc/oraInst.loc
  11. OPatch version    : 11.2.0.1.7
  12. OUI version       : 11.2.0.3.0
  13. Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-04-01_16-45-58PM.log
  14.  
  15.  
  16. The patch should be applied/rolled back in '-all_nodes' mode only.
  17. Converting the RAC mode to '-all_nodes' mode.
  18. Applying interim patch '12834800' to OH '/u01/app/oracle/product/11.2.0/db_1'
  19. Verifying environment and performing prerequisite checks...
  20.  
  21. Do you want to proceed? [y|n]
  22. y
  23. User Responded with: Y
  24. All checks passed.
  25. Backing up files...
  26.  
  27. Patching component oracle.rdbms, 11.2.0.3.0...
  28. The patch will be installed on active database instances.
  29. Installing and enabling the online patch 'bug12834800.pch', on database 'PROD4'.
  30.  
  31. Patch 12834800 successfully applied
  32. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-04-01_16-45-58PM.log
  33.  
  34. OPatch succeeded.
  1. $ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory
  2. Invoking OPatch 11.2.0.1.7
  3.  
  4. Oracle Interim Patch Installer version 11.2.0.1.7
  5. Copyright (c) 2011, Oracle Corporation.  All rights reserved.
  6.  
  7.  
  8. Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
  9. Central Inventory : /u01/app/oraInventory
  10.    from           : /etc/oraInst.loc
  11. OPatch version    : 11.2.0.1.7
  12. OUI version       : 11.2.0.3.0
  13. Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-04-01_16-48-44PM.log
  14.  
  15. Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-04-01_16-48-44PM.txt
  16.  
  17. --------------------------------------------------------------------------------
  18. Installed Top-level Products (1): 
  19.  
  20. Oracle Database 11g                                                  11.2.0.3.0
  21. There are 1 products installed in this Oracle Home.
  22.  
  23.  
  24. Interim patches (1) :
  25.  
  26. Patch (online) 12834800: applied on Mon Apr 01 16:47:17 CST 2019
  27. Unique Patch ID:  14522435
  28.    Created on 28 Jan 2012, 10:16:59 hrs PST8PDT
  29.    Bugs fixed:
  30.      12834800
  31.  
  32.  
  33.  
  34. --------------------------------------------------------------------------------
  35.  
  36. OPatch succeeded.

原文链接：http://www.cnblogs.com/yongestcat/p/11413431.html

 友情链接：直通硅谷 　点职佳 　北美留学生论坛

Oracle热门文章

  • 【Oracle学习笔记】Oralce随机数与随机取样
  • java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
  • .NET多种数据库大数据批量插入、更新（支持SqlServer、MySql、PgSql和Oracle）
  • Navicat Premium 连接oracle ORA-01017：用户名/口令无效；登陆被拒绝
  • oracle - for in loop 循环更新
  • oracle json 解析函数
  • expdp导出时报错ora-16000
  • WARNING OGG-01519
  • ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务
  • oracle数据库与其他数据库区别

    • Oracle推荐文章

  • 在RockyLinux 9.3环境中采用RPM模式部署Oracle 19C
  • 你真会判断DataGuard的延迟吗？
  • Oracle rac环境的数据库导入操作记录
  • 使用Oracle进行数据库备份与还原
  • 从零写一个兼容MySQL/Oracle的Proxy中件间（一）《初识Oracle的通信协议》
  • 一文详解TDSQL PG版Oracle兼容性实践
  • 达梦与Oracle逻辑备份与还原性能对比
  • [20211213]提示precompute_subquery.txt
  • ORA-01536: space quota exceeded for tablespace案例
  • ORACLE如何查看当前账号的相关信息总结

    • 本站QQ群：前端 618073944 | Java 606181507 | Python 626812652 | C/C++ 612253063 | 微信 634508462 | 苹果 692586424 | C#/.net 182808419 | PHP 305140648 | 运维 608723728

    W3xue 的所有内容仅供测试，对任何法律问题及风险不承担任何责任。通过使用本站内容随之而来的风险与本站无关。
    关于我们  |  意见建议  |  捐助我们  |  报错有奖  |  广告合作、友情链接（目前9元/月）请联系QQ：27243702 沸活量
    皖ICP备17017327号-2　皖公网安备34020702000426号