• PSU 19.19安装

    参考文档：
    https://updates.oracle.com/Orion/Services/download?type=readme&aru=25183811
    OPatch lsinventory or Apply New Patch With Opatch apply Fails With Error "Unable to create patchObject" Inventory Corrupted (Doc ID 2792549.1)
    TFA is not Starting: [ TFA scheduler is not running ] (Doc ID 2737653.1)

    安装PSU，１９.７－１９.１９ 

    步骤
    1 OPatch版本，要求12.2.0.1.36
    2 验证Oracle Inventory 
    3 OPatch冲突检查
    4 系统空间检查
    5 补丁冲突检查
    6 安装补丁
    7 sql apply 

    出现的问题 
    1 OS磁盘目录问题，在安装补丁的时候，自检会提示，如果安装补丁过程中小于10G，会报错
    2 节点2上，没有找到oneoff补丁的xml。将节点1上的文件夹copy到节点2即可
    3 在检查补丁冲突的时候，节点1提示错误，但是在节点2中检测后，再次节点1中检测，问题消失
    4 所有的检测都没有问题。但是在安装的时候，提示没有TFA导致安装补丁失败，重新安装TFA后，问题解决。
        
    详细的补丁过程    

    1 OPatch版本，要求12.2.0.1.36
    2 验证Oracle Inventory 

    1. $ <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>
    2.  
    3. su - grid
    4. /u01/app/19.0.0/grid/OPatch/opatch  lsinventory -detail -oh /u01/app/19.0.0/grid

    -- 出现错误，发现节点2上没有一些补丁的xml文件

    1. Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-06-06_12-51-24PM_1.log
    2.  
    3. Lsinventory Output file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2023-06-06_12-51-24PM.txt
    4. --------------------------------------------------------------------------------
    5.  
    6.  
    7. Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
    8.  
    9. LsInventorySession failed: Unable to create patchObject
    10. Possible causes are:
    11.    ORACLE_HOME/inventory/oneoffs/30869156 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/inventory" does not exist.
    12.  
    13.  
    14. OPatch failed with error code 73
    15. [grid@node19c02 ~]$ 
    16.  
    17. [grid@node19c02 OPatch]$ ./opatch lspatches
    18. Inventory load failed... LsPatchesSession::loadAndPrintInstalledPatch()
    19. LsPatchesSession failed: Unable to create patchObject
    20. Possible causes are:
    21.    ORACLE_HOME/inventory/oneoffs/30869156 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/inventory" does not exist.
    22.  
    23.  
    24. OPatch failed with error code 2
    25. [grid@node19c02 OPatch]$

    -- 对比节点1和节点上的补丁的xml文件，发现节点2上没有的 

    1. [grid@node19c01 oneoffs]$ ls
    2. 29401763  29517242  29517247  29585399  30869156  30869304  30894985  30898856
    3. [grid@node19c01 oneoffs]$ 
    4.  
    5. [grid@node19c02 oneoffs]$ ls
    6. 29401763  29517242  29517247  29585399
    7. [grid@node19c02 oneoffs]$

    解决方法，将节点1上的文件copy到节点2上

    1. [grid@node19c01 oneoffs]$ scp -r 30869156 node19c02:/u01/app/19.0.0/grid/inventory/oneoffs/
    2. inventory.xml                                                                                                         100%  224KB  19.5MB/s   00:00    
    3. actions.xml                                                                                                           100% 2079KB  39.1MB/s   00:00    
    4. [grid@node19c01 oneoffs]$ scp -r 30869304 node19c02:/u01/app/19.0.0/grid/inventory/oneoffs/
    5. inventory.xml                                                                                                         100%   14KB   5.7MB/s   00:00    
    6. actions.xml                                                                                                           100%   54KB  23.8MB/s   00:00    
    7. [grid@node19c01 oneoffs]$ scp -r 30894985 node19c02:/u01/app/19.0.0/grid/inventory/oneoffs/
    8. inventory.xml                                                                                                         100%   55KB  12.9MB/s   00:00    
    9. actions.xml                                                                                                           100%  227KB  29.3MB/s   00:00    
    10. [grid@node19c01 oneoffs]$ scp -r 30898856 node19c02:/u01/app/19.0.0/grid/inventory/oneoffs/
    11. inventory.xml                                                                                                         100% 1819   267.1KB/s   00:00    
    12. actions.xml                                                                                                           100% 3879     2.8MB/s   00:00    
    13. [grid@node19c01 oneoffs]$ 
    1. su - oracle 
    2. $ <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>
    3. /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/19.0.0/db_1

    3 OPatch冲突检查

    1. su - grid 
    2. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/35042068
    3. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/35050331
    4. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/35050325
    5. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/35107512
    6. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/33575402
    7.  
    8. su - oracle
    9. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/35042068
    10. % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /psu/35037840/35050331

    4 系统空间检查

    1. su - grid
    2. cat /tmp/patch_list_gihome.txt
    3. /psu/35037840/35042068
    4. /psu/35037840/35050331
    5. /psu/35037840/35050325
    6. /psu/35037840/35107512
    7. /psu/35037840/33575402
    8.  
    9. $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
    10.  
    11. su - oracle 
    12. cat /tmp/patch_list_dbhome.txt
    13. /psu/35037840/35042068
    14. /psu/35037840/35050331
    15.  
    16. $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

    5 补丁冲突检查 ，奇怪，在节点1上执行错误，节点二执行正常。随后再次在节点1上执行，OK了。

    1. #/u01/app/19.0.0/grid/OPatch/opatchauto apply /psu/35037840 -analyze
    2.  
    3. [root@node19c01 grid]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /psu/35037840 -analyze
    4.  
    5. OPatchauto session is initiated at Tue Jun  6 13:29:30 2023
    6.  
    7. System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-06-06_01-29-44PM.log.
    8.  
    9. OPATCHAUTO-72050: System instance creation failed.
    10. OPATCHAUTO-72050: Failed while retrieving system information.
    11. OPATCHAUTO-72050: Please check log file for more details.
    12.  
    13. OPatchauto session completed at Tue Jun  6 13:30:17 2023
    14. Time taken to complete the session 0 minute, 34 seconds
    15.  
    16. Topology creation failed.
    17. [root@node19c01 grid]#

    6 安装补丁，在安装过程中，提示没有TFA 

    1. # opatchauto apply /psu/35037840
    2. /u01/app/19.0.0/grid/OPatch/opatchauto apply /psu/35037840
    3.  
    4.  
    5. [root@node19c01 grid]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /psu/35037840 
    6.  
    7. OPatchauto session is initiated at Tue Jun  6 13:54:17 2023
    8.  
    9. System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-06-06_01-54-32PM.log.
    10.  
    11. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-06-06_01-56-00PM.log
    12. The id for this session is NAPN
    13.  
    14. Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
    15.  
    16. Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1
    17. Patch applicability verified successfully on home /u01/app/19.0.0/grid
    18.  
    19. Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1
    20.  
    21.  
    22. Executing patch validation checks on home /u01/app/19.0.0/grid
    23. Patch validation checks successfully completed on home /u01/app/19.0.0/grid
    24.  
    25.  
    26. Executing patch validation checks on home /u01/app/oracle/product/19.0.0/db_1
    27. Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/db_1
    28.  
    29.  
    30. Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
    31. SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1
    32.  
    33.  
    34. Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/db_1
    35. Successfully prepared home /u01/app/oracle/product/19.0.0/db_1 to bring down database service
    36.  
    37.  
    38. Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
    39. Prepatch operation log file location: /u01/app/grid/crsdata/node19c01/crsconfig/crs_prepatch_apply_inplace_node19c01_2023-06-06_02-07-44PM.log
    40. Failed to bring down CRS service on home /u01/app/19.0.0/grid
    41.  
    42. Execution of [GIShutDownAction] patch action failed, check log for more details. Failures:
    43. Patch Target : node19c01->/u01/app/19.0.0/grid Type[crs]
    44. Details: [
    45. ---------------------------Patching Failed---------------------------------
    46. Command execution failed during patching in home: /u01/app/19.0.0/grid, host: node19c01.
    47. Command failed:  /u01/app/19.0.0/grid/perl/bin/perl -I/u01/app/19.0.0/grid/perl/lib -I/u01/app/19.0.0/grid/opatchautocfg/db/dbtmp/bootstrap_node19c01/patchwork/crs/install -I/u01/app/19.0.0/grid/opatchautocfg/db/dbtmp/bootstrap_node19c01/patchwork/xag /u01/app/19.0.0/grid/opatchautocfg/db/dbtmp/bootstrap_node19c01/patchwork/crs/install/rootcrs.pl -prepatch
    48. Command failure output: 
    49. Using configuration parameter file: /u01/app/19.0.0/grid/opatchautocfg/db/dbtmp/bootstrap_node19c01/patchwork/crs/install/crsconfig_params
    50. The log of current session can be found at:
    51.   /u01/app/grid/crsdata/node19c01/crsconfig/crs_prepatch_apply_inplace_node19c01_2023-06-06_02-07-44PM.log
    52. Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [724960844].
    53. 2023/06/06 14:09:46 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
    54. TFA scheduler is not running
    55. 2023/06/06 14:09:47 CLSRSC-4014: Failed to shut down Oracle Trace File Analyzer (TFA) Collector. Grid Infrastructure operations will continue. 
    56.  
    57. After fixing the cause of failure Run opatchauto resume
    58.  
    59. ]
    60. OPATCHAUTO-68061: The orchestration engine failed.
    61. OPATCHAUTO-68061: The orchestration engine failed with return code 1
    62. OPATCHAUTO-68061: Check the log for more details.
    63. OPatchAuto failed.
    64.  
    65. OPatchauto session completed at Tue Jun  6 14:09:52 2023
    66. Time taken to complete the session 15 minutes, 21 seconds
    67.  
    68.  opatchauto failed with error code 42
    69. [root@node19c01 grid]# 
    1. [root@node19c01 grid]# tfactl
    2. TFA scheduler is not running
    3. [root@node19c01 grid]# 
    4.  
    5.  
    6. [root@node19c01 grid]# tfactl start
    7. TFA scheduler is not running
    8. [root@node19c01 grid]#

    -- 安装了tfa以后，再次安装psu，空间不够，至少需要10G 

    1. Patch: /psu/35037840/35042068
    2. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_14-36-09PM_1.log
    3. Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output: 
    4. The details are:
    5. Required amount of space(10401.978MB) is not available.] 
    6.  
    7.  
    8. After fixing the cause of failure start a new opatchauto session
    9. ]
    10. OPATCHAUTO-68061: The orchestration engine failed.
    11. OPATCHAUTO-68061: The orchestration engine failed with return code 1
    12. OPATCHAUTO-68061: Check the log for more details.
    13. OPatchAuto failed.
    14.  
    15. OPatchauto session completed at Tue Jun  6 14:45:54 2023
    16. Time taken to complete the session 13 minutes, 59 seconds
    17.  
    18.  opatchauto failed with error code 42
    19. [root@node19c01 grid]#

    -- 节点1和节点2完整的安装补丁过程 

    1. [root@node19c02 psu]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /psu/35037840 
    2.  
    3. OPatchauto session is initiated at Tue Jun  6 14:48:04 2023
    4.  
    5. System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-06-06_02-48-19PM.log.
    6.  
    7. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-06-06_02-50-21PM.log
    8. The id for this session is QZXM
    9.  
    10. Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
    11.  
    12. Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1
    13. Patch applicability verified successfully on home /u01/app/19.0.0/grid
    14.  
    15. Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1
    16.  
    17.  
    18. Executing patch validation checks on home /u01/app/19.0.0/grid
    19. Patch validation checks successfully completed on home /u01/app/19.0.0/grid
    20.  
    21.  
    22. Executing patch validation checks on home /u01/app/oracle/product/19.0.0/db_1
    23. Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/db_1
    24.  
    25.  
    26. Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
    27. SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1
    28.  
    29.  
    30. Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/db_1
    31. Successfully prepared home /u01/app/oracle/product/19.0.0/db_1 to bring down database service
    32.  
    33.  
    34. Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
    35. Prepatch operation log file location: /u01/app/grid/crsdata/node19c02/crsconfig/crs_prepatch_apply_inplace_node19c02_2023-06-06_02-59-57PM.log
    36. CRS service brought down successfully on home /u01/app/19.0.0/grid
    37.  
    38.  
    39. Performing prepatch operation on home /u01/app/oracle/product/19.0.0/db_1
    40. Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1
    41.  
    42.  
    43. Start applying binary patch on home /u01/app/oracle/product/19.0.0/db_1
    44. Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/db_1
    45.  
    46.  
    47. Performing postpatch operation on home /u01/app/oracle/product/19.0.0/db_1
    48. Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1
    49.  
    50.  
    51. Start applying binary patch on home /u01/app/19.0.0/grid
    52. Binary patch applied successfully on home /u01/app/19.0.0/grid
    53.  
    54.  
    55. Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid
    56. Postpatch operation log file location: /u01/app/grid/crsdata/node19c02/crsconfig/crs_postpatch_apply_inplace_node19c02_2023-06-06_03-30-08PM.log
    57. CRS service started successfully on home /u01/app/19.0.0/grid
    58.  
    59.  
    60. Preparing home /u01/app/oracle/product/19.0.0/db_1 after database service restarted
    61. No step execution required.........
    62.  
    63.  
    64. Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0/db_1
    65. No SQL patch operations are required on local node for this home
    66.  
    67. OPatchAuto successful.
    68.  
    69. --------------------------------Summary--------------------------------
    70.  
    71. Patching is completed successfully. Please find the summary as follows:
    72.  
    73. Host:node19c02
    74. RAC Home:/u01/app/oracle/product/19.0.0/db_1
    75. Version:19.0.0.0.0
    76. Summary:
    77.  
    78. ==Following patches were SKIPPED:
    79.  
    80. Patch: /psu/35037840/35050325
    81. Reason: This patch is not applicable to this specified target type - "rac_database"
    82.  
    83. Patch: /psu/35037840/33575402
    84. Reason: This patch is not applicable to this specified target type - "rac_database"
    85.  
    86. Patch: /psu/35037840/35107512
    87. Reason: This patch is not applicable to this specified target type - "rac_database"
    88.  
    89.  
    90. ==Following patches were SUCCESSFULLY applied:
    91.  
    92. Patch: /psu/35037840/35042068
    93. Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-05-55PM_1.log
    94.  
    95. Patch: /psu/35037840/35050331
    96. Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-05-55PM_1.log
    97.  
    98.  
    99. Host:node19c02
    100. CRS Home:/u01/app/19.0.0/grid
    101. Version:19.0.0.0.0
    102. Summary:
    103.  
    104. ==Following patches were SUCCESSFULLY applied:
    105.  
    106. Patch: /psu/35037840/33575402
    107. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-18-37PM_1.log
    108.  
    109. Patch: /psu/35037840/35042068
    110. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-18-37PM_1.log
    111.  
    112. Patch: /psu/35037840/35050325
    113. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-18-37PM_1.log
    114.  
    115. Patch: /psu/35037840/35050331
    116. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-18-37PM_1.log
    117.  
    118. Patch: /psu/35037840/35107512
    119. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_15-18-37PM_1.log
    120.  
    121.  
    122.  
    123. OPatchauto session completed at Tue Jun  6 15:38:29 2023
    124. Time taken to complete the session 50 minutes, 11 seconds
    125. [root@node19c02 psu]# 
    1. [root@node19c01 grid]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /psu/35037840 
    2.  
    3. OPatchauto session is initiated at Tue Jun  6 15:40:46 2023
    4.  
    5. System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-06-06_03-41-05PM.log.
    6.  
    7. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-06-06_03-42-52PM.log
    8. The id for this session is VU2V
    9.  
    10. Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
    11.  
    12. Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1
    13. Patch applicability verified successfully on home /u01/app/19.0.0/grid
    14.  
    15. Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1
    16.  
    17.  
    18. Executing patch validation checks on home /u01/app/19.0.0/grid
    19. Patch validation checks successfully completed on home /u01/app/19.0.0/grid
    20.  
    21.  
    22. Executing patch validation checks on home /u01/app/oracle/product/19.0.0/db_1
    23. Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/db_1
    24.  
    25.  
    26. Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
    27. SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1
    28.  
    29.  
    30. Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/db_1
    31. Successfully prepared home /u01/app/oracle/product/19.0.0/db_1 to bring down database service
    32.  
    33.  
    34. Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
    35. Prepatch operation log file location: /u01/app/grid/crsdata/node19c01/crsconfig/crs_prepatch_apply_inplace_node19c01_2023-06-06_03-56-49PM.log
    36. CRS service brought down successfully on home /u01/app/19.0.0/grid
    37.  
    38.  
    39. Performing prepatch operation on home /u01/app/oracle/product/19.0.0/db_1
    40. Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1
    41.  
    42.  
    43. Start applying binary patch on home /u01/app/oracle/product/19.0.0/db_1
    44. Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/db_1
    45.  
    46.  
    47. Performing postpatch operation on home /u01/app/oracle/product/19.0.0/db_1
    48. Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1
    49.  
    50.  
    51. Start applying binary patch on home /u01/app/19.0.0/grid
    52. Binary patch applied successfully on home /u01/app/19.0.0/grid
    53.  
    54.  
    55. Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid
    56. Postpatch operation log file location: /u01/app/grid/crsdata/node19c01/crsconfig/crs_postpatch_apply_inplace_node19c01_2023-06-06_04-24-28PM.log
    57. CRS service started successfully on home /u01/app/19.0.0/grid
    58.  
    59.  
    60. Preparing home /u01/app/oracle/product/19.0.0/db_1 after database service restarted
    61. No step execution required.........
    62.  
    63.  
    64. Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0/db_1
    65. SQL patch applied successfully on home /u01/app/oracle/product/19.0.0/db_1
    66.  
    67. OPatchAuto successful.
    68.  
    69. --------------------------------Summary--------------------------------
    70.  
    71. Patching is completed successfully. Please find the summary as follows:
    72.  
    73. Host:node19c01
    74. RAC Home:/u01/app/oracle/product/19.0.0/db_1
    75. Version:19.0.0.0.0
    76. Summary:
    77.  
    78. ==Following patches were SKIPPED:
    79.  
    80. Patch: /psu/35037840/35050325
    81. Reason: This patch is not applicable to this specified target type - "rac_database"
    82.  
    83. Patch: /psu/35037840/33575402
    84. Reason: This patch is not applicable to this specified target type - "rac_database"
    85.  
    86. Patch: /psu/35037840/35107512
    87. Reason: This patch is not applicable to this specified target type - "rac_database"
    88.  
    89.  
    90. ==Following patches were SUCCESSFULLY applied:
    91.  
    92. Patch: /psu/35037840/35042068
    93. Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-02-19PM_1.log
    94.  
    95. Patch: /psu/35037840/35050331
    96. Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-02-19PM_1.log
    97.  
    98.  
    99. Host:node19c01
    100. CRS Home:/u01/app/19.0.0/grid
    101. Version:19.0.0.0.0
    102. Summary:
    103.  
    104. ==Following patches were SUCCESSFULLY applied:
    105.  
    106. Patch: /psu/35037840/33575402
    107. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-14-06PM_1.log
    108.  
    109. Patch: /psu/35037840/35042068
    110. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-14-06PM_1.log
    111.  
    112. Patch: /psu/35037840/35050325
    113. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-14-06PM_1.log
    114.  
    115. Patch: /psu/35037840/35050331
    116. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-14-06PM_1.log
    117.  
    118. Patch: /psu/35037840/35107512
    119. Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-06_16-14-06PM_1.log
    120.  
    121.  
    122.  
    123. OPatchauto session completed at Tue Jun  6 16:59:30 2023
    124. Time taken to complete the session 78 minutes, 26 seconds
    125. [root@node19c01 grid]#

    7 sql apply 

    1. [oracle@node19c01 OPatch]$ ./datapatch -verbose
    2. SQL Patching tool version 19.19.0.0.0 Production on Tue Jun  6 17:02:46 2023
    3. Copyright (c) 2012, 2023, Oracle.  All rights reserved.
    4.  
    5. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_74364_2023_06_06_17_02_46/sqlpatch_invocation.log
    6.  
    7. Connecting to database...OK
    8. Gathering database info...done
    9. Bootstrapping registry and package to current versions...done
    10. Determining current state...done
    11.  
    12. Current state of interim SQL patches:
    13.   No interim patches found
    14.  
    15. Current state of release update SQL patches:
    16.   Binary registry:
    17.     19.19.0.0.0 Release_Update 230322020406: Installed
    18.   SQL registry:
    19.     Applied 19.19.0.0.0 Release_Update 230322020406 successfully on 06-JUN-23 04.59.29.499888 PM
    20.  
    21. Adding patches to installation queue and performing prereq checks...done
    22. Installation queue:
    23.   No interim patches need to be rolled back
    24.   No release update patches need to be installed
    25.   No interim patches need to be applied
    26.  
    27. SQL Patching tool complete on Tue Jun  6 17:04:31 2023
    28. [oracle@node19c01 OPatch]$

    END

  • 相关阅读:
    day02-Gateway(网关)
    php上传图片，yii上传图片，（base64上传）
    【我是学生，可以送我么】搭建树莓派4bJTAG调试平台jlink平替版
    python【模块】xml.etree.ElementTree 解析 xml
    STM32CubeMX学习笔记（46）——USB接口使用（HID自定义设备）
    Linux 命令
    云原生系列 二【轻松入门容器基础操作】
    cocoapods使用
    view-design组件使用Vue+Input+Table实现动态搜索值并单选
    javacofig几个常用注解
  • 原文地址：https://blog.csdn.net/xxzhaobb/article/details/131081925