【RAC】oracle11g_rac_auto_update_opatch

最新推荐文章于 2021-01-25 22:01:11 发布
最新推荐文章于 2021-01-25 22:01:11 发布
阅读量116 收藏
点赞数
前段时间测试单机数据库升级补丁，那么在RAC中怎么自动为集群软件、数据库升级补丁呢，下面让我们来看看。

环境：redhat6.3_x64+Oracle11g RAC (11.2.0.4.0)

所需补丁包：p6880880_112000_Linux-x86-64.zip  p20996923_112040_Linux-x86-64.zip

补丁信息： p20996923_112040_Linux-x86-64.zip==>  GI PSUs are cumulative and include the Database PSU and associated CPU program security content
              p6880880_112000_Linux-x86-64.zip==> You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. (11.2.0.3.10)

将两个包上传至RAC各节点，解压。

                    unzip  p6880880_112000_Linux-x86-64.zip   | unzip p20996923_112040_Linux-x86-64.zip

温馨提示：在做数据库的任何操作，都建议在操作前备份数据库，以免造成不必要损失。

将新的目录 OPatch 分别拷贝到各个节点的GRID、Oracle主目录中，cp -rf OPatch $GRID_HOME、$ORACLE_HOME(建议提前备份）
查看opatch 信息：

点击(此处)折叠或打开

  1. [grid@rac01 OPatch]$ ./opatch lsinventory
  2. Oracle Interim Patch Installer version 11.2.0.3.10
  3. Copyright (c) 2015, Oracle Corporation. All rights reserved.


  6. Oracle Home : /grid/crs_home/product/11.2.0
  7. Central Inventory : /grid/oraInventory
  8.    from : /grid/crs_home/product/11.2.0/oraInst.loc
  9. OPatch version : 11.2.0.3.10
  10. OUI version : 11.2.0.4.0
  11. Log file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/opatch2015-07-31_14-31-35PM_1.log

  13. Lsinventory Output file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2015-07-31_14-31-35PM.txt

  15. --------------------------------------------------------------------------------
  16. Local Machine Information::
  17. Hostname: rac01
  18. ARU platform id: 226
  19. ARU platform description:: Linux x86-64

  21. Installed Top-level Products (1):

  23. Oracle Grid Infrastructure 11g 11.2.0.4.0
  24. There are 1 products installed in this Oracle Home.


  27. There are no Interim patches installed in this Oracle Home.


  30. Rac system comprising of multiple nodes
  31.   Local node = rac01
  32.   Remote node = rac02

  34. --------------------------------------------------------------------------------

  36. OPatch succeeded.
通过grid用户创建ocm配置文件，各个节点都需要（也可以拷贝到其他节点）：

点击(此处)折叠或打开

  1. [grid@rac01 bin]$ pwd
  2. /grid/crs_home/product/11.2.0/OPatch/ocm/bin
  3. [grid@rac01 bin]$ ./emocmrsp -no_banner -output /grid/soft/ocm.rsp

检查每个节点grid、oracle的patch的相容性。例如

点击(此处)折叠或打开

  1. [grid@rac01 ~]$ cd /grid/crs_home/product/11.2.0/OPatch/
  2. [grid@rac01 OPatch]$ ./opatch lsinventory -detail -oh $ORACLE_HOME
  3. Oracle Interim Patch Installer version 11.2.0.3.10
  4. Copyright (c) 2015, Oracle Corporation. All rights reserved.


  7. Oracle Home : /grid/crs_home/product/11.2.0
  8. Central Inventory : /grid/oraInventory
  9.    from : /grid/crs_home/product/11.2.0/oraInst.loc
  10. OPatch version : 11.2.0.3.10
  11. OUI version : 11.2.0.4.0
  12. Log file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/opatch2015-07-31_15-05-07PM_1.log

  14. Lsinventory Output file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2015-07-31_15-05-07PM.txt

  16. --------------------------------------------------------------------------------
  17. Local Machine Information::
  18. Hostname: rac01
  19. ARU platform id: 226
  20. ARU platform description:: Linux x86-64

  22. Installed Top-level Products (1):

  24. Oracle Grid Infrastructure 11g 11.2.0.4.0
  25. There are 1 products installed in this Oracle Home.


  28. Installed Products (89):

  30. Agent Required Support Files 10.2.0.4.5
  31. Assistant Common Files 11.2.0.4.0
  32. Automatic Storage Management Assistant 11.2.0.4.0
  33. Bali Share 1.1.18.0.0
  34. Buildtools Common Files 11.2.0.4.0
  35. Character Set Migration Utility 11.2.0.4.0
  36. Cluster Ready Services Files 11.2.0.4.0
  37. Cluster Verification Utility Common Files 11.2.0.4.0
  38. Cluster Verification Utility Files 11.2.0.4.0
  39. Database SQL Scripts 11.2.0.4.0
  40. Deinstallation Tool 11.2.0.4.0
  41. Enterprise Manager Common Core Files 10.2.0.4.5
  42. Enterprise Manager Common Files 10.2.0.4.5
  43. Enterprise Manager plugin Common Files 11.2.0.4.0
  44. Expat libraries 2.0.1.0.1
  45. HAS Common Files 11.2.0.4.0
  46. HAS Files for DB 11.2.0.4.0
  47. Installation Common Files 11.2.0.4.0
  48. Installation Plugin Files 11.2.0.4.0
  49. Installer SDK Component 11.2.0.4.0
  50. Java Development Kit 1.5.0.51.10
  51. LDAP Required Support Files 11.2.0.4.0
  52. OLAP SQL Scripts 11.2.0.4.0
  53. Oracle Advanced Security 11.2.0.4.0
  54. Oracle Clusterware RDBMS Files 11.2.0.4.0
  55. Oracle Configuration Manager Deconfiguration 10.3.1.0.0
  56. Oracle Containers for Java 11.2.0.4.0
  57. Oracle Core Required Support Files 11.2.0.4.0
  58. Oracle Database 11g 11.2.0.4.0
  59. Oracle Database 11g Multimedia Files 11.2.0.4.0
  60. Oracle Database Deconfiguration 11.2.0.4.0
  61. Oracle Database User Interface 2.2.13.0.0
  62. Oracle Database Utilities 11.2.0.4.0
  63. Oracle DBCA Deconfiguration 11.2.0.4.0
  64. Oracle Extended Windowing Toolkit 3.4.47.0.0
  65. Oracle Globalization Support 11.2.0.4.0
  66. Oracle Globalization Support 11.2.0.4.0
  67. Oracle Grid Infrastructure 11g 11.2.0.4.0
  68. Oracle Help For Java 4.2.9.0.0
  69. Oracle Ice Browser 5.2.3.6.0
  70. Oracle Internet Directory Client 11.2.0.4.0
  71. Oracle Java Client 11.2.0.4.0
  72. Oracle JDBC/OCI Instant Client 11.2.0.4.0
  73. Oracle JDBC/THIN Interfaces 11.2.0.4.0
  74. Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
  75. Oracle JVM 11.2.0.4.0
  76. Oracle LDAP administration 11.2.0.4.0
  77. Oracle Locale Builder 11.2.0.4.0
  78. Oracle Multimedia 11.2.0.4.0
  79. Oracle Multimedia Client Option 11.2.0.4.0
  80. Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
  81. Oracle Multimedia Locator 11.2.0.4.0
  82. Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
  83. Oracle Net 11.2.0.4.0
  84. Oracle Net Listener 11.2.0.4.0
  85. Oracle Net Required Support Files 11.2.0.4.0
  86. Oracle Netca Client 11.2.0.4.0
  87. Oracle Notification Service 11.2.0.3.0
  88. Oracle Notification Service (eONS) 11.2.0.4.0
  89. Oracle One-Off Patch Installer 11.2.0.3.4
  90. Oracle Quality of Service Management (Client) 11.2.0.4.0
  91. Oracle Quality of Service Management (Server) 11.2.0.4.0
  92. Oracle RAC Deconfiguration 11.2.0.4.0
  93. Oracle RAC Required Support Files-HAS 11.2.0.4.0
  94. Oracle Recovery Manager 11.2.0.4.0
  95. Oracle Security Developer Tools 11.2.0.4.0
  96. Oracle Text Required Support Files 11.2.0.4.0
  97. Oracle Universal Installer 11.2.0.4.0
  98. Oracle USM Deconfiguration 11.2.0.4.0
  99. Oracle Wallet Manager 11.2.0.4.0
  100. Parser Generator Required Support Files 11.2.0.4.0
  101. Perl Interpreter 5.10.0.0.2
  102. Perl Modules 5.10.0.0.1
  103. PL/SQL 11.2.0.4.0
  104. PL/SQL Embedded Gateway 11.2.0.4.0
  105. Platform Required Support Files 11.2.0.4.0
  106. Precompiler Required Support Files 11.2.0.4.0
  107. RDBMS Required Support Files 11.2.0.4.0
  108. RDBMS Required Support Files for Instant Client 11.2.0.4.0
  109. RDBMS Required Support Files Runtime 11.2.0.4.0
  110. Required Support Files 11.2.0.4.0
  111. Secure Socket Layer 11.2.0.4.0
  112. SQL*Plus 11.2.0.4.0
  113. SQL*Plus Files for Instant Client 11.2.0.4.0
  114. SQL*Plus Required Support Files 11.2.0.4.0
  115. SSL Required Support Files for InstantClient 11.2.0.4.0
  116. Universal Storage Manager Files 11.2.0.4.0
  117. XDK Required Support Files 11.2.0.4.0
  118. XML Parser for Java 11.2.0.4.0
  119. There are 89 products installed in this Oracle Home.


  122. There are no Interim patches installed in this Oracle Home.


  125. Rac system comprising of multiple nodes
  126.   Local node = rac01
  127.   Remote node = rac02

  129. --------------------------------------------------------------------------------

  131. OPatch succeeded.
  132. [grid@rac01 OPatch]$
检查通过后，停止数据库： srvctl stop database -d racdb

以root用户开始执行下面语句，每个节点都需要执行（依次）:

点击(此处)折叠或打开

  1. [root@rac01 ~]# export GI_HOME=/grid/crs_home/product/11.2.0
  2. [root@rac01 ~]# $GI_HOME/OPatch/opatch auto /grid/soft/20996923 -ocmrf /grid/soft/ocm.rsp
  3. Executing /grid/crs_home/product/11.2.0/perl/bin/perl /grid/crs_home/product/11.2.0/OPatch/crs/patch11203.pl -patchdir /grid/soft -patchn 20996923 -ocmrf /grid/soft/ocm.rsp -paramfile /grid/crs_home/product/11.2.0/crs/install/crsconfig_params

  5. This is the main log file: /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto2015-08-03_09-20-46.log

  7. This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
  8. /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto2015-08-03_09-20-46.report.log

  10. 2015-08-03 09:20:46: Starting Clusterware Patch Setup
  11. Using configuration parameter file: /grid/crs_home/product/11.2.0/crs/install/crsconfig_params

  13. Stopping RAC /oracle/app/oracle/product/11.2.0 ...
  14. Stopped RAC /oracle/app/oracle/product/11.2.0 successfully

  16. patch /grid/soft/20996923/20760982 apply successful for home /oracle/app/oracle/product/11.2.0
  17. patch /grid/soft/20996923/20831122/custom/server/20831122 apply successful for home /oracle/app/oracle/product/11.2.0

  19. Stopping CRS...
  20. Stopped CRS successfully

  22. patch /grid/soft/20996923/20760982 apply successful for home /grid/crs_home/product/11.2.0
  23. patch /grid/soft/20996923/20831122 apply successful for home /grid/crs_home/product/11.2.0
  24. patch /grid/soft/20996923/20299019 apply successful for home /grid/crs_home/product/11.2.0

  26. Starting CRS...
  27. Installing Trace File Analyzer
  28. CRS-4123: Oracle High Availability Services has been started.

  30. Starting RAC /oracle/app/oracle/product/11.2.0 ...
  31. Started RAC /oracle/app/oracle/product/11.2.0 successfully

  33. opatch auto succeeded.
  34. [root@rac01 ~]#
下面是后台输出日志，由于日志太多，截取部分日志信息：

点击(此处)折叠或打开

  1. ...................
  2. Verifying environment and performing prerequisite checks...
  3.  OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982
  4.  
  5.  Do you want to proceed? [y|n]
  6.  Y (auto-answered by -silent)
  7.  User Responded with: Y
  8.  All checks passed.
  9.  
  10.  Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
  11.  (Oracle Home = '/oracle/app/oracle/product/11.2.0')
  12.  Is the local system ready for patching? [y|n]
  13.  Y (auto-answered by -silent)
  14.  User Responded with: Y
  15.  Backing up files...
  16.  Applying sub-patch '17478514' to OH '/oracle/app/oracle/product/11.2.0'
  17.  
  18.  Patching component oracle.rdbms, 11.2.0.4.0...
  19. ...........
  20. ..........
  21. 2015-08-03 09:30:30: Unlock crshome...
  22. 2015-08-03 09:30:30: crshome passed is
  23. 2015-08-03 09:30:30: Exclude file used is /grid/crs_home/product/11.2.0/OPatch/crs/installPatch.excl
  24. 2015-08-03 09:30:30: Home location in olr.loc is /grid/crs_home/product/11.2.0
  25. 2015-08-03 09:30:30: unlock crs home is /grid/crs_home/product/11.2.0
  26. 2015-08-03 09:30:30: Executing /grid/crs_home/product/11.2.0/bin/crsctl stop crs -f
  27. 2015-08-03 09:30:30: Executing cmd: /grid/crs_home/product/11.2.0/bin/crsctl stop crs -f
  28. 2015-08-03 09:34:05: Command output:
  29. > CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac01'
  30. > CRS-2673: Attempting to stop 'ora.crsd' on 'rac01'
  31. > CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac01'
  32. > CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac01'
  33. .............

下面是后台执行具体操作

点击(此处)折叠或打开

  1. [grid@rac01 opatch]$ tail -f /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto2015-08-03_09-20-46.report.log
  2. crs_home=/grid/crs_home/product/11.2.0 version=11.2.0.4.0 owner=grid opatch_ver=11.2.0.3.10
  3. rac_home=/oracle/app/oracle/product/11.2.0 version=11.2.0.4.0 owner=oracle opatch_ver=11.2.0.3.10

  5. *********** Steps to be executed as owner unless specified as root ***********


  8. 1: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20760982 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  10. 2: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20831122/custom/server/20831122 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  12. 3: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20760982 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  14. 4: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20831122/custom/server/20831122 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  16. 5: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20760982 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  18. 6: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20831122 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  20. 7: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20299019 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  22. 8: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20760982 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  24. 9: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20831122 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  26. 10: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20299019 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  28. 11: /oracle/app/oracle/product/11.2.0/bin/emctl stop dbconsole

  30. 12: /oracle/app/oracle/product/11.2.0/bin/emctl stop agent

  32. 13: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20760982 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  34. 14: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20831122/custom/server/20831122 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  36. 15: /oracle/app/oracle/product/11.2.0/bin/srvctl stop home -o /oracle/app/oracle/product/11.2.0 -s /oracle/app/oracle/product/11.2.0/srvm/admin/stophome.txt -n rac01 -f

  38. 16: /grid/soft/20996923/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/app/oracle/product/11.2.0

  40. 17: /oracle/app/oracle/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20760982 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /oracle/app/oracle/product/11.2.0 -invPtrLoc /oracle/app/oracle/product/11.2.0/oraInst.loc

  42. 18: /oracle/app/oracle/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20831122/custom/server/20831122 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /oracle/app/oracle/product/11.2.0 -invPtrLoc /oracle/app/oracle/product/11.2.0/oraInst.loc

  44. 19: /grid/soft/20996923/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/app/oracle/product/11.2.0

  46. 20: /grid/crs_home/product/11.2.0/crs/install/rootcrs.pl -unlock : run as root

  48. 21: /sbin/fuser -k /grid/crs_home/product/11.2.0/bin/crsctl.bin : run as root

  50. 22: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20760982 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  52. 23: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20831122 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  54. 24: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20299019 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core

  56. 25: /grid/crs_home/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20760982 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /grid/crs_home/product/11.2.0 -invPtrLoc /grid/crs_home/product/11.2.0/oraInst.loc

  58. 26: /grid/crs_home/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20831122 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /grid/crs_home/product/11.2.0 -invPtrLoc /grid/crs_home/product/11.2.0/oraInst.loc

  60. 27: /grid/crs_home/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20299019 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /grid/crs_home/product/11.2.0 -invPtrLoc /grid/crs_home/product/11.2.0/oraInst.loc

  62. 28: /grid/crs_home/product/11.2.0/bin/emctl start dbconsole

  64. 29: /grid/crs_home/product/11.2.0/rdbms/install/rootadd_rdbms.sh : run as root

  66. 30: /grid/crs_home/product/11.2.0/crs/install/rootcrs.pl -patch : run as root

  68. 31: /oracle/app/oracle/product/11.2.0/bin/emctl start dbconsole

  70. 32: /oracle/app/oracle/product/11.2.0/bin/emctl start agent

  72. 33: /oracle/app/oracle/product/11.2.0/bin/srvctl start home -o /oracle/app/oracle/product/11.2.0 -s /oracle/app/oracle/product/11.2.0/srvm/admin/stophome.txt -n rac01

再各个节点执行完自动升级后，启动数据库:srvctl start database -d racdb

执行下面语句，在每个节点

点击(此处)折叠或打开

  1. SQL> @?/rdbms/admin/catbundle.sql psu apply

  3. PL/SQL procedure successfully completed.


  6. Function created.


  9. Function created.


  12. PL/SQL procedure successfully completed.
  13. ..............
  14. SQL> INSERT INTO registry$history
  15.   2 (action_time, action,
  16.   3 namespace, version, id,
  17.   4 bundle_series, comments)
  18.   5 VALUES
  19.   6 (SYSTIMESTAMP, 'APPLY',
  20.   7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  21.   8 '11.2.0.4',
  22.   9 7,
  23.  10 'PSU',
  24.  11 'PSU 11.2.0.4.7');

  26. 1 row created.

  28. SQL> COMMIT;

  30. Commit complete.

  32. SQL> SPOOL off
  33. SQL> SET echo off
  34. Check the following log file for errors:
  35. /oracle/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_RACDB_APPLY_2015Aug03_09_58_09.log

检查数据库信息：

点击(此处)折叠或打开

  1. SQL> select * from dba_registry_history;

  3. ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
  4. ------------------------------ ---------------- ---------- ---------- ---------- --------------- --------------------------
  5. 2014-09-28 05:52:58.357412 APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
  6. 2015-08-03 09:59:48.521212 APPLY SERVER 11.2.0.4 7 PSU PSU 11.2.0.4.7
  7. 2015-08-03 10:00:11.433233 APPLY SERVER 11.2.0.4 7 PSU PSU 11.2.0.4.7

查看grid 版本信息

点击(此处)折叠或打开

  1. [grid@rac01 OPatch]$ ./opatch lsinventory -detail -oh $ORACLE_HOME | grep -i patch
  2. Oracle Interim Patch Installer version 11.2.0.3.10
  3. OPatch version : 11.2.0.3.10
  4. Log file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/opatch2015-08-03_10-49-36AM_1.log
  5. Lsinventory Output file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2015-08-03_10-49-36AM.txt
  6. Oracle One-Off Patch Installer 11.2.0.3.4
  7. Interim patches (3) :
  8. Patch 20299019 : applied on Mon Aug 03 09:43:14 CST 2015
  9. Unique Patch ID: 18573450
  10. Patch description: "ACFS Patch set update : 11.2.0.4.6 (20299019)"
  11.    Patch Location in Inventory:
  12.    Patch Location in Storage area:
  13.      /grid/crs_home/product/11.2.0/.patch_storage/20299019_Mar_27_2015_15_26_30
  14. Patch 20831122 : applied on Mon Aug 03 09:41:03 CST 2015
  15. Unique Patch ID: 18923533
  16. Patch description: "OCW Patch Set Update : 11.2.0.4.7 (20831122)"
  17.      crspatch.pm --> ORACLE_HOME/crs/install/crspatch.pm
  18.    Patch Location in Inventory:
  19.    Patch Location in Storage area:
  20.      /grid/crs_home/product/11.2.0/.patch_storage/20831122_Jul_1_2015_06_26_45
  21. Patch 20760982 : applied on Mon Aug 03 09:39:05 CST 2015
  22. Unique Patch ID: 18908105
  23. Patch description: "Database Patch Set Update : 11.2.0.4.7 (20760982)"
  24. Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
  25. Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
  26. Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
  27. Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
  28. Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
  29. Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
  30.      bug16595641.sql --> ORACLE_HOME/patch/scripts/bug16595641.sql
  31.      bug17088068.sql --> ORACLE_HOME/patch/scripts/bug17088068.sql
  32.      bug17381384.sql --> ORACLE_HOME/patch/scripts/bug17381384.sql
  33.      bug19289642.sql --> ORACLE_HOME/patch/scripts/bug19289642.sql
  34.      sdopatch.sql --> ORACLE_HOME/md/admin/sdopatch.sql
  35.    Patch Location in Inventory:
  36.    Patch Location in Storage area:
  37.      /grid/crs_home/product/11.2.0/.patch_storage/20760982_Jun_4_2015_00_23_20
  38. OPatch succeeded.
  39. [grid@rac01 OPatch]$
至此，oracle11g rac 打补丁完成，通过一条命令，我们就可以为gird、database升级，方面高效，通过后台日志，我们可以看到，它的每一步操作，能够让我们更好的掌握升级、了解其过程。

文盲筱烨，2015年8月3日

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29487349/viewspace-1760397/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29487349/viewspace-1760397/

crygaj7140
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle 11g rac update
bjibm1188的博客
07-09 211
root身份执行（两节点）  cd /grid/racmv OPatch OPatch_oldcd /u01/oracle/product/11.2/db_1/mv OPatch OPatch_oldcp -R OPatch /grid/rac/cd /grid/rac/chown -R grid:oinstall OPatchcp -R OPatch /u01/oracle/product/11...
oracle 11g 单机asm+db psu补丁安装（一）
hzcyhujw的博客
09-11 1305
概述：准备写个数据库补丁集更新系列片，现有的环境是11g asm +db 模式的后续推出其他类型的补丁更新集； 准备介质：OPatch 11.2.0.3.16版本，补丁集 grid psu 180717 实验步骤： 1、升级OPatch版本： [root@cube2 tmp]# su - grid [grid@cube2 ~]$ cd /u01/app/11.2.0/grid/OPatch...
Oracle11g（RAC）20210119补丁安装（32131250）
君子不怨天的博客
01-25 2648
Oracle11gRAC——20210119补丁安装 21年1月19日和20年10月20的补丁安装命令基本一致 注意事项： 关闭数据库 先打GI psu 再打DB psu grid打 acfs 打ojvm之前停集群 一定要仔细阅读readme！ 打补丁要指定补丁安装目录 opatch auto -oh $ORACLE_HOME root用户上传补丁到/u01/software并授权和更改属主 授权： # chmod 755 /u01/software/p32131250_112040_Linux-x
【PSU】Oracle11g_psu_include_grid
crygaj7140的博客
10-27 197
环境介绍： Oracle11.2.0.4+GRID（ASM) redhat6.7 单机版 为数据库环境打补丁 命令很简单，首先下载相关补丁包，请阅读补丁包中readme.html 首先升级OPatch...
Oracle RAC系列：11gR2数据库安装&Opatch RAC ONE NODE
yusiyu的技术专栏
12-07 1644
Download Opatch: https://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=224346.1     Patch Processing: '/bin/hostname -s'-> /u01/product/11.2.0/dbhome_1/OPatch/opatch apply Invoki
Oracle 11g RAC PSU 从 11.2.0.3.0 升级到 11.2.0.3.6 示例
04-20
在Oracle 11g RAC环境中，PSU（Patch Set Update）是用于提升系统安全性和性能的重要升级。本篇文章将详细阐述如何将Oracle 11g RAC PSU从11.2.0.3.0升级到11.2.0.3.6的过程。 首先，了解Oracle RAC的升级背景：...
RAC环境打补丁步骤12.2.0.1.docx
08-05
【Oracle RAC 12.2.0.1 打补丁步骤】 在Oracle RAC环境中，打补丁是一项关键任务，确保系统的稳定性和安全性。本文档详细介绍了12.2.0.1版本的补丁应用过程，包括补丁准备、系统检查以及补丁的安装。 **1. 补丁...
oracle 11.2.0.2版本的最后的GI（包含DB）psu补丁：p17272753_112020_Linux-x86.zip
01-13
Oracle 11g数据库是Oracle公司推出的企业级关系型数据库管理系统的一个重要版本，而PSU（ Patch Set Update）则是Oracle为了提供及时的安全更新和性能改进而发布的一种补丁集。在Oracle 11.2.0.2版本中，"GI"通常指...
Oracle 11.2.0.4打补丁的方法
01-19
[oracle@localhost OPatch]$ ./opatch version OPatch Version: 11.2.0.3.16 OPatch succeeded. 检查环境是否需要打补丁，opatch版本安装环境可以看mos和readme 查看组件信息 12:40:47 SYS@std> set linesize 500 ...
p6880880_112000_Linux-x86
08-31
"p6880880_112000_Linux-x86"这个压缩包文件与Oracle数据库的11g Release 2 (11.2.0)版本的维护和更新密切相关。主要涉及的是Oracle Patch Set Update (PSU)的安装以及OPatch工具的使用，这两个元素在Oracle数据库...
oracle rac 自动打补丁Opatch auto
数据库
05-14 737
1，安装最新的Optach版本 补丁程序6880880: OPatch patch of version 11.2.0.3.4 for Oracle software releases 11.2.0.x (APRIL 2013)2，更新gird和oracle用户的Opatch文件 unzip p6880880_112000_Linux-x86-64.zip -d /oracle/11.2.0/...
psu遇到The opatch minimum version
crcz16618的博客
05-05 851
现象： [root@ora1 OPatch]# ./opatch auto /software/psu/21523375/ -ocmrf /software/ocm.rsp Executing /u01/app/11.2....
Oracle 11.2.0.4.3 PSU For 11.2.0.4 RAC LINUX X86-64 installation
jarry_gao的专栏
08-06 3499
安装文件 p18706472_112040_Linux-x86-64.zip 大小居然已经500M
Oracle11g（RAC）补丁安装（31718723，31668908）
君子不怨天的博客
12-15 7133
Oracle11g 20201020补丁安装，31718723、31668908补丁
ORACEL 11.2.0.4 - RAC打补丁最佳实践
makef的博客
10-02 1030
一、概述 1、本章介绍ORACLE 如何下载补丁和打补丁。 2、本章介绍生成环境上 Oracle 11GR2 11.2.0.4 版本如何打补丁。 二、如何下载补丁 登录MOS，查阅（ID 2118136.2）,下载最新补丁包。前提是公司购买Oracle服务。如果购买Oracle服务，在合同上有编号 https://support.oracle.com/portal/# 选择PSU 选择数据库版本 选择 补丁号GI PUS (Grid Infrastructure Pa...
b050闲置图书分享-springboot+vue+elementui.zip（可运行源码+sql文件+文档）
07-23
本次开发的闲置图书分享平台实现了收货地址管理、字典管理、公告管理、留言板管理、图书管理、图书收藏管理、图书评价管理、图书订单管理、用户管理、管理员管理等功能。系统用到了关系型数据库中王者MySql作为系统的数据库，有效的对数据进行安全的存储，有效的备份，对数据可靠性方面得到了保证。并且程序也具备程序需求的所有功能，使得操作性还是安全性都大大提高，让闲置图书分享平台更能从理念走到现实，确确实实的让人们提升信息处理效率。 管理图书的数据，此页面主要实现图书的增加、修改、删除、查看的功能。公告信息管理页面提供的功能操作有：新增公告，修改公告，删除公告操作。公告类型管理页面显示所有公告类型，在此页面既可以让管理员添加新的公告信息类型，也能对已有的公告类型信息执行编辑更新，失效的公告类型信息也能让管理员快速删除。
《大学生职业生涯规划与就业指导》大一阶段课程作业
最新发布
07-24
《大学生职业生涯规划与就业指导》大一阶段课程作业
开题报告潮汕特产直销系统 已通过开题答辩的.doc
07-23
随着互联网的高速发展，人们的生活方式发生了翻天覆地的变化，在过去，人们想要购买很远地方的东西会非常麻烦，因为是通信和交通都不是十分的方便，而现在网络购物成为了人们日常生活中不可或缺的一部分。在这样的背景下，互联网与传统行业的融合已经成为了一种不可阻挡的趋势。对于中国特色的潮汕特产来说，这一趋势也带来了巨大的变革和发展机遇[1]。
Python性能优化：掌握性能分析工具的实战指南
07-23
Python是一种广泛使用的高级编程语言，由Guido van Rossum于1989年底发明，第一个公开发行版发行于1991年。Python的设计哲学强调代码的可读性和简洁的语法（尤其是使用空格缩进来区分代码块，而不是使用大括号或关键词）。这使得Python被认为是一种易于学习的语言，同时具备强大的功能，适合初学者和经验丰富的程序员。 Python的主要特点包括： 1. **易于学习**：Python有相对较少的关键字，结构简单，和一个明确定义的语法。 2. **易于阅读**：Python代码定义的清晰度使得它像可执行伪代码。 3. **易于维护**：Python的成功在于它的源代码是相当容易维护的。 4. **广泛的标准库**：Python的标凑库很庞大，包含用于互联网通信、网络通信、数据压缩、加密、系统管理等的模块。 5. **跨平台**：Python可以在多种操作系统上运行，包括但不限于Windows、Mac OS X、Linux等。 6. **解释型语言**：Python是一种解释型语言，这意味着开发过程中没有编译步骤。 7. **动态类型系统**：Python不会在编写
VMware下Linux安装Oracle10g_RAC详细教程
"手把手教你如何在Linux环境下使用VMware安装Oracle 10g RAC" 在IT领域，Oracle数据库的Real Application Clusters (RAC) 是一种高可用性解决方案，它允许多台服务器共享同一个数据库实例，从而提供容错能力和负载...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值