Patch Set Update 11.2.0.4.190115 will not be installed on the GI home using opatch auto

NeilZhang
NeilZhang
管理员
140
文章
106.8千
浏览
Oracle评论1,258字数 1109阅读3分41秒阅读模式

First of all, let me show you the installation log:

  1. [root@node2 tmp]# /u01/app/11.2.0/grid/OPatch/opatch auto 28813878 -ocmrf /u01/ocm.rsp
  2. Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir . -patchn 28813878 -ocmrf /u01/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
  3.  
  4. This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2019-02-18_09-14-41.log
  5.  
  6. This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
  7. /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2019-02-18_09-14-41.report.log
  8.  
  9. 2019-02-18 09:14:41: Starting Clusterware Patch Setup
  10. Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
  11.  
  12. Stopping RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
  13. Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully
  14.  
  15. patch ./28813878/28729234/custom/server/28729234  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1 
  16. patch ./28813878/28729262  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1 
  17.  
  18. Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
  19. Started RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully
  20.  
  21. opatch auto succeeded.

Perfect! Right? No any error, and even the message said 'succeeded'.

When I got almost the same log the third time, I knew there was something wrong as I could not find the related log of the GI home.

(Note: below logs are from both customer system and my own test machines so they are mixed. Sorry)

And the result could be confirmed easily:

  1. [grid@rac11g1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
  2. Oracle Interim Patch Installer version 11.2.0.3.20
  3. Copyright (c) 2019, Oracle Corporation.  All rights reserved.
  4.  
  5.  
  6. Oracle Home       : /oracle/app/cluster/11.2.0
  7. Central Inventory : /oracle/app/oraInventory
  8.    from           : /oracle/app/cluster/11.2.0/oraInst.loc
  9. OPatch version    : 11.2.0.3.20
  10. OUI version       : 11.2.0.4.0
  11. Log file location : /oracle/app/cluster/11.2.0/cfgtoollogs/opatch/opatch2019-02-21_12-11-30PM_1.log
  12.  
  13. Lsinventory Output file location : /oracle/app/cluster/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2019-02-21_12-11-30PM.txt
  14.  
  15. --------------------------------------------------------------------------------
  16. Local Machine Information::
  17. Hostname: rac11g1.dbcloudsvc.com
  18. ARU platform id: 226
  19. ARU platform description:: Linux x86-64
  20.  
  21. Installed Top-level Products (1):
  22.  
  23. Oracle Grid Infrastructure 11g                                       11.2.0.4.0
  24. There are 1 products installed in this Oracle Home.
  25.  
  26.  
  27. There are no Interim patches installed in this Oracle Home.
  28.  
  29.  
  30. --------------------------------------------------------------------------------
  31.  
  32. OPatch succeeded.
  33. [grid@rac11g1 ~]$ exit
  34. logout
  35. [root@rac11g1 oracle]# su - oracle
  36. [oracle@rac11g1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
  37. Oracle Interim Patch Installer version 11.2.0.3.20
  38. Copyright (c) 2019, Oracle Corporation.  All rights reserved.
  39.  
  40.  
  41. Oracle Home       : /oracle/app/oracle/product/11.2.0
  42. Central Inventory : /oracle/app/oraInventory
  43.    from           : /oracle/app/oracle/product/11.2.0/oraInst.loc
  44. OPatch version    : 11.2.0.3.20
  45. OUI version       : 11.2.0.4.0
  46. Log file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2019-02-21_12-12-22PM_1.log
  47.  
  48. Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2019-02-21_12-12-22PM.txt
  49.  
  50. --------------------------------------------------------------------------------
  51. Local Machine Information::
  52. Hostname: rac11g1.dbcloudsvc.com
  53. ARU platform id: 226
  54. ARU platform description:: Linux x86-64
  55.  
  56. Installed Top-level Products (1):
  57.  
  58. Oracle Database 11g                                                  11.2.0.4.0
  59. There are 1 products installed in this Oracle Home.
  60.  
  61.  
  62. Interim patches (2) :
  63.  
  64. Patch  28729262     : applied on Thu Feb 21 07:05:30 NZDT 2019
  65. Unique Patch ID:  22664181
  66. Patch description:  "Database Patch Set Update : 11.2.0.4.190115 (28729262)"
  67.    Created on 19 Dec 2018, 22:33:21 hrs PST8PDT
  68. Sub-patch  28204707; "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
  69. Sub-patch  27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
  70. Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
  71. Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
  72. Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
  73. Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
  74. Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
  75. Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
  76. Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
  77. Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
  78. Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
  79. Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
  80. Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
  81. Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
  82. Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
  83. Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
  84. Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
  85. Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
  86. Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
  87. Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
  88.    Bugs fixed:
  89.      17184721, 21174504, 21538558, 16091637, 18092127, 17381384, 15979965
  90.      20671094, 16731148, 16314254, 13837378, 18441944, 23105538, 17291347

I tried to install it directly on the GI home:

  1. [root@rac11g1 oracle]# /oracle/app/cluster/11.2.0/OPatch/opatch auto 28813878 -oh /oracle/app/cluster/11.2.0 -ocmrf /oracle/ocm.rsp
  2. Executing /oracle/app/cluster/11.2.0/perl/bin/perl /oracle/app/cluster/11.2.0/OPatch/crs/patch11203.pl -patchdir . -patchn 28813878 -oh /oracle/app/cluster/11.2.0 -ocmrf /oracle/ocm.rsp -paramfile /oracle/app/cluster/11.2.0/crs/install/crsconfig_params
  3.  
  4. This is the main log file: /oracle/app/cluster/11.2.0/cfgtoollogs/opatchauto2019-02-21_12-18-28.log
  5.  
  6. This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
  7. /oracle/app/cluster/11.2.0/cfgtoollogs/opatchauto2019-02-21_12-18-28.report.log
  8.  
  9. 2019-02-21 12:18:29: Starting Clusterware Patch Setup
  10. Using configuration parameter file: /oracle/app/cluster/11.2.0/crs/install/crsconfig_params
  11.  
  12. Stopping CRS...
  13. Stopped CRS successfully
  14.  
  15. Error : The opatch Applicable check failed.  The patch ./28813878/28729234 is not applicable to /oracle/app/cluster/11.2.0
  16. Error:Patch Applicable check failed for /oracle/app/cluster/11.2.0
  17.  
  18. Starting CRS...
  19. ERROR: Prereq checkApplicable failed. Refer log file for more details.
  20.  
  21.  
  22. opatch auto failed.

Its better that at least I knew it failed.

Next I continued to install it as GI owner and it worked.

  1. /oracle/app/cluster/11.2.0/perl/bin/perl /oracle/app/cluster/11.2.0/crs/install/rootcrs.pl -unlock
  2. /oracle/app/cluster/11.2.0/OPatch/opatch napply -oh /oracle/app/cluster/11.2.0 -ocmrf /oracle/ocm.rsp -local /tmp/28813878/28729245
  3. /oracle/app/cluster/11.2.0/rdbms/install/rootadd_rdbms.sh
  4. /oracle/app/cluster/11.2.0/perl/bin/perl /oracle/app/cluster/11.2.0/crs/install/rootcrs.pl -patch

Attached the patch log here: GI_Patch_Log

In RHEL7, we have to use the perl from the GI home or we will get below error:

  1. Can't locate Env.pm in @INC

And now we could make sure it was installed:

  1. [grid@rac11g1 ~]$ /oracle/app/cluster/11.2.0/OPatch/opatch lsinv
  2. Oracle Interim Patch Installer version 11.2.0.3.20
  3. Copyright (c) 2019, Oracle Corporation.  All rights reserved.
  4.  
  5.  
  6. Oracle Home       : /oracle/app/cluster/11.2.0
  7. Central Inventory : /oracle/app/oraInventory
  8.    from           : /oracle/app/cluster/11.2.0/oraInst.loc
  9. OPatch version    : 11.2.0.3.20
  10. OUI version       : 11.2.0.4.0
  11. Log file location : /oracle/app/cluster/11.2.0/cfgtoollogs/opatch/opatch2019-02-21_13-03-38PM_1.log
  12.  
  13. Lsinventory Output file location : /oracle/app/cluster/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2019-02-21_13-03-38PM.txt
  14.  
  15. --------------------------------------------------------------------------------
  16. Local Machine Information::
  17. Hostname: rac11g1.dbcloudsvc.com
  18. ARU platform id: 226
  19. ARU platform description:: Linux x86-64
  20.  
  21. Installed Top-level Products (1):
  22.  
  23. Oracle Grid Infrastructure 11g                                       11.2.0.4.0
  24. There are 1 products installed in this Oracle Home.
  25.  
  26.  
  27. Interim patches (3) :
  28.  
  29. Patch  28729262     : applied on Thu Feb 21 12:45:36 NZDT 2019
  30. Unique Patch ID:  22664181
  31. Patch description:  "Database Patch Set Update : 11.2.0.4.190115 (28729262)"
  32.    Created on 19 Dec 2018, 22:33:21 hrs PST8PDT
  33. Sub-patch  28204707; "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
  34. Sub-patch  27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
  35. Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
  36. Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
  37. Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
  38. Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
  39. Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
  40. Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
  41. Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
  42. Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
  43. Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
  44. Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
  45. Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
  46. Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
  47. Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
  48. Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
  49. Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
  50. Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
  51. Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
  52. Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
  53.    Bugs fixed:
  54.      17184721, 21174504, 21538558, 16091637, 18092127, 17381384, 15979965

 

 
  • 本文由 NeilZhang 发表于22/02/2019 02:28:06
  • Repost please keep this link: https://www.dbcloudsvc.com/blogs/oracle/patch-set-update-11-2-0-4-190115-will-not-be-installed-on-the-gi-home-using-opatch-auto/
Could I ignore the SID clause in command 'alter system'?

加载中...

匿名

发表评论

匿名网友
:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:
确定