ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > 【RAC】oracle11g_rac_auto_update_opatch

【RAC】oracle11g_rac_auto_update_opatch

原创 Oracle 作者：xysoul_云龙 时间：2015-08-03 14:37:46 0 删除 编辑
前段时间测试单机数据库升级补丁，那么在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博客 ” ，链接：https://blog.itpub.net/29487349/viewspace-1760397/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： 【OGG】hpux系统nfs异常造成OGG无法应用归档日志
下一篇： 【BUG】Oracle12c CDB:EM EXPRESS::ORA-07445
请登录后发表评论 登录
全部评论
xysoul_云龙
专家姓名：杨云龙
主要从事Oracle数据库 DBA相关工作，其他操作系统、中间件等也有涉及，热衷分享。岁月老将至，如有幸在江湖中留点踪迹，也是欣慰。 【文盲筱烨】好读书爱运动的IT技术爱好者 微博：文盲筱烨 微信公众号：筱烨视点

注册时间：2014-02-15

  • 博文量
    412
  • 访问量
    1104554

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593