ORACLE19C RAC 19.3.0升级19.12.0

第一节点补丁冲突检查

GI_HOME

[grid@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32585572/
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2022-08-05_00-52-01AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32904851
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32915586
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32916816
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32918050
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

ORACLE_HOME

[oracle@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32904851
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-05_00-56-33AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32916816
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-05_00-56-55AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

第二节点补丁冲突检查

GI_HOME

[grid@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32585572/

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32904851
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32915586
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32916816
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32918050
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

ORACLE_HOME

[oracle@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32904851
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-05_01-01-30AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/32895426/32916816
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-05_01-01-53AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

第一节点升级预检查

[grid@rac1 ~]$ /u01/app/19.3.0/grid/bin/cluvfy stage -pre patch
This software is "385" days old. It is a best practice to update the CRS home by downloading and applying the latest release update. Refer to MOS note 2731675.1 for more details.

Verifying cluster upgrade state ...PASSED
Verifying OLR Integrity ...PASSED
Verifying Hosts File ...PASSED
Verifying Free Space: rac2:/ ...PASSED
Verifying Free Space: rac1:/ ...PASSED
Verifying OPatch utility version consistency ...PASSED
Verifying Software home: /u01/app/19.3.0/grid ...PASSED

Pre-check for Patch Application was successful.

CVU operation performed:      stage -pre patch
Date:                         Aug 5, 2022 1:03:14 AM
CVU home:                     /u01/app/19.3.0/grid/
User:                         grid

第二节点升级预检查

[grid@rac2 ~]$ /u01/app/19.3.0/grid/bin/cluvfy stage -pre patch
This software is "385" days old. It is a best practice to update the CRS home by downloading and applying the latest release update. Refer to MOS note 2731675.1 for more details.

Verifying cluster upgrade state ...PASSED
Verifying OLR Integrity ...PASSED
Verifying Hosts File ...PASSED
Verifying Free Space: rac2:/ ...PASSED
Verifying Free Space: rac1:/ ...PASSED
Verifying OPatch utility version consistency ...PASSED
Verifying Software home: /u01/app/19.3.0/grid ...PASSED

Pre-check for Patch Application was successful.

CVU operation performed:      stage -pre patch
Date:                         Aug 5, 2022 1:03:21 AM
CVU home:                     /u01/app/19.3.0/grid/
User:                         grid

第一节点空间预检查

vi /patch/patch_list_gihome.txt

/patch/32895426/32585572
/patch/32895426/32904851
/patch/32895426/32915586
/patch/32895426/32916816
/patch/32895426/32918050

[grid@rac2 OPatch]$ ./opatch prereq CheckSystemSpace -phBaseFile /patch/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.3.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2022-08-05_01-08-29AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

ORACLE

vi /patch/patch_list_dbhome.txt

/patch/32895426/32904851
/patch/32895426/32916816

[grid@rac2 OPatch]$ ./opatch prereq CheckSystemSpace -phBaseFile /patch/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.3.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2022-08-05_01-10-14AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

第二节点空间预检查

vi /patch/patch_list_gihome.txt

/patch/32895426/32585572
/patch/32895426/32904851
/patch/32895426/32915586
/patch/32895426/32916816
/patch/32895426/32918050

[grid@rac2 OPatch]$ ./opatch prereq CheckSystemSpace -phBaseFile /patch/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.3.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2022-08-05_01-14-23AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

ORACLE

vi /patch/patch_list_dbhome.txt

/patch/32895426/32904851
/patch/32895426/32916816

[grid@rac2 OPatch]$ ./opatch prereq CheckSystemSpace -phBaseFile /patch/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.3.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2022-08-05_01-15-16AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

第一节点GI patch

[root@rac1 patch]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /patch/32895426 -oh /u01/app/19.3.0/grid

OPatchauto session is initiated at Thu Aug  4 18:20:23 2022

System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-08-04_06-20-33PM.log.

Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2022-08-04_06-21-57PM.log
The id for this session is 5MM4

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid


Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_prepatch_apply_inplace_rac1_2022-08-04_06-23-59PM.log
CRS service brought down successfully on home /u01/app/19.3.0/grid


Start applying binary patch on home /u01/app/19.3.0/grid
Binary patch applied successfully on home /u01/app/19.3.0/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_postpatch_apply_inplace_rac1_2022-08-04_06-34-53PM.log
CRS service started successfully on home /u01/app/19.3.0/grid

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac1
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /patch/32895426/32585572
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_18-25-24PM_1.log

Patch: /patch/32895426/32904851
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_18-25-24PM_1.log

Patch: /patch/32895426/32915586
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_18-25-24PM_1.log

Patch: /patch/32895426/32916816
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_18-25-24PM_1.log

Patch: /patch/32895426/32918050
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_18-25-24PM_1.log

OPatchauto session completed at Thu Aug  4 18:41:08 2022
Time taken to complete the session 20 minutes, 45 seconds
[root@rac1 patch]#

ORACLE PATH

[root@rac1 patch]# /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply /patch/32895426 -oh /u01/app/oracle/product/19.3.0/db_1/

OPatchauto session is initiated at Fri Aug  5 01:17:36 2022

System initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2022-08-05_01-17-48AM.log.

Session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2022-08-05_01-18-54AM.log
The id for this session is GUKP

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1


Executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1
No step execution required.........


Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1
No step execution required.........


Performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1


Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1


Preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/db_1
No step execution required.........

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac1
RAC Home:/u01/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /patch/32895426/32915586
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /patch/32895426/32585572
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /patch/32895426/32918050
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /patch/32895426/32904851
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-05_01-21-51AM_1.log

Patch: /patch/32895426/32916816
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-05_01-21-51AM_1.log



OPatchauto session completed at Fri Aug  5 01:36:35 2022
Time taken to complete the session 18 minutes, 59 seconds

第二节点GI patch

[root@rac2 patch]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /patch/32895426 -oh /u01/app/19.3.0/grid

OPatchauto session is initiated at Thu Aug  4 19:50:10 2022

System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-08-04_07-50-23PM.log.

Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2022-08-04_07-52-00PM.log
The id for this session is 317U

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid


Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crs_prepatch_apply_inplace_rac2_2022-08-04_07-54-13PM.log
CRS service brought down successfully on home /u01/app/19.3.0/grid


Start applying binary patch on home /u01/app/19.3.0/grid
Binary patch applied successfully on home /u01/app/19.3.0/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crs_postpatch_apply_inplace_rac2_2022-08-04_08-08-37PM.log
CRS service started successfully on home /u01/app/19.3.0/grid

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /patch/32895426/32585572
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_19-56-19PM_1.log

Patch: /patch/32895426/32904851
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_19-56-19PM_1.log

Patch: /patch/32895426/32915586
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_19-56-19PM_1.log

Patch: /patch/32895426/32916816
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_19-56-19PM_1.log

Patch: /patch/32895426/32918050
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-04_19-56-19PM_1.log

OPatchauto session completed at Thu Aug  4 20:18:11 2022
Time taken to complete the session 28 minutes, 1 second

ORACLE PATH

Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1
Failed while applying binary patches on home /u01/app/oracle/product/19.3.0/db_1

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : rac2->/u01/app/oracle/product/19.3.0/db_1 Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/oracle/product/19.3.0/db_1, host: rac2.
Command failed:  /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto  apply /patch/32895426 -oh /u01/app/oracle/product/19.3.0/db_1 -target_type rac_database -binary -invPtrLoc /u01/app/oracle/product/19.3.0/db_1//oraInst.loc -jre /u01/app/oracle/product/19.3.0/db_1/OPatch/jre -persistresult /u01/app/oracle/product/19.3.0/db_1/opatchautocfg/db/sessioninfo/sessionresult_rac2_rac_2.ser -analyzedresult /u01/app/oracle/product/19.3.0/db_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac2_rac_2.ser
Command failure output:
==Following patches FAILED in apply:

Patch: /patch/32895426/32904851
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-05_01-40-46AM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /u01/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)'

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Fri Aug  5 01:51:30 2022
Time taken to complete the session 13 minutes, 56 seconds

 opatchauto failed with error code 42
[root@rac2 32895426]# cd /u01/app/oraInventory/ContentsXML/
[root@rac2 ContentsXML]# ll
total 20
-rw-rw---- 1 grid   oinstall 300 Aug  4 20:08 comps.xml
-rw-rw---- 1 grid   oinstall 557 Jul 20 12:05 inventory.xml
-rw-rw---- 1 grid   oinstall 292 Aug  4 20:08 libs.xml
-rw-r--r-- 1 grid   oinstall 174 Aug  4 20:08 oui-patch.xml
-rw-r--r-- 1 oracle oinstall 174 Aug  4 20:08 oui-patch.xml.back
[root@rac2 ContentsXML]# chmod 660 oui-patch.xml


[root@rac2 ContentsXML]# /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto resume

OPatchauto session is initiated at Fri Aug  5 01:52:21 2022
Session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2022-08-05_01-52-27AM.log
Resuming existing session with id 3J27

Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1
Failed while applying binary patches on home /u01/app/oracle/product/19.3.0/db_1

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : rac2->/u01/app/oracle/product/19.3.0/db_1 Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/oracle/product/19.3.0/db_1, host: rac2.
Command failed:  /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto  apply /patch/32895426 -oh /u01/app/oracle/product/19.3.0/db_1 -target_type rac_database -binary -invPtrLoc /u01/app/oracle/product/19.3.0/db_1//oraInst.loc -jre /u01/app/oracle/product/19.3.0/db_1/OPatch/jre -persistresult /u01/app/oracle/product/19.3.0/db_1/opatchautocfg/db/sessioninfo/sessionresult_rac2_rac_2.ser -analyzedresult /u01/app/oracle/product/19.3.0/db_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac2_rac_2.ser
Command failure output:
==Following patches FAILED in apply:

Patch: /patch/32895426/32904851
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-08-05_01-53-32AM_1.log
Reason: Failed during Analysis: CheckNApplyReport Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/32904851 is corrupted. PatchObject constructor: Input file "/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/32904851/etc/config/actions" or "/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/32904851/etc/config/inventory" does not exist.
]

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Fri Aug  5 01:54:06 2022
Time taken to complete the session 1 minute, 46 seconds

 opatchauto failed with error code 42

一节点拷贝损坏的补丁

[oracle@rac1 ~]$ scp -r /u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/32904851 oracle@rac2:/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/32904851
inventory.xml                                                                                                                      100%  647KB  25.8MB/s   00:00
actions.xml                                                                                                                        100% 5981KB  35.1MB/s   00:00

重新应用补丁

[root@rac2 oneoffs]# /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto resume

OPatchauto session is initiated at Fri Aug  5 02:19:41 2022
Session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2022-08-05_02-19-46AM.log
Resuming existing session with id 3J27

Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1


Preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/db_1
No step execution required.........

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac2
RAC Home:/u01/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /patch/32895426/32915586
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /patch/32895426/32585572
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /patch/32895426/32918050
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /patch/32895426/32904851
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /patch/32895426/32916816
Reason: This patch is not applicable to this specified target type - "rac_database"



OPatchauto session completed at Fri Aug  5 02:24:02 2022
Time taken to complete the session 4 minutes, 22 seconds

此次为制造升级故障没有更改/u01/app/oraInventory/ContentsXML/oui-patch.xml权限

第二节点打GI补丁之前都要更改/u01/app/oraInventory/ContentsXML/目录的oui-patch.xml文件为同组用户可写。

[root@rac2 32895426]# cd /u01/app/oraInventory/ContentsXML/
[root@rac2 ContentsXML]# ll
total 20
-rw-rw---- 1 grid oinstall 300 Aug 4 20:08 comps.xml
-rw-rw---- 1 grid oinstall 557 Jul 20 12:05 inventory.xml
-rw-rw---- 1 grid oinstall 292 Aug 4 20:08 libs.xml
-rw-r--r-- 1 grid oinstall 174 Aug 4 20:08 oui-patch.xml
-rw-r--r-- 1 oracle oinstall 174 Aug 4 20:08 oui-patch.xml.back
[root@rac2 ContentsXML]# chmod 660 oui-patch.xml

解决办法把一节点相应补丁拷贝到第二节点

至此升级完成

ORACLE19C RAC 19.3.0升级19.12.0

Java相关栏目本月热门文章