1，报错信息
[root@bjmyedu1 dbhome_1]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Thu Sep 7 22:37:12 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-07_10-37-15PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-09-07_10-37-22PM.log
The id for this session is ZCU6
Shared home /u01/app/19.0.0/grid can only be patched in nonrolling mode.
OPATCHAUTO-72030: Execution mode invalid.
OPATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared.
OPATCHAUTO-72030: Execute in non-rolling mode.
OPatchAuto failed.
OPatchauto session completed at Thu Sep 7 22:37:35 2023
Time taken to complete the session 0 minute, 20 seconds
opatchauto failed with error code 42
[root@bjmyedu1 ~]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/19.0.0/grid
Invalid current directory. Please run opatchauto from other than '/root' or '/' directory.
And check if the home owner user has write permission set for the current directory.
opatchauto returns with error code = 2
[root@bjmyedu1 soft]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Thu Sep 7 22:41:16 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-07_10-41-20PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-09-07_10-41-28PM.log
The id for this session is N1HH
Shared home /u01/app/19.0.0/grid can only be patched in nonrolling mode.
OPATCHAUTO-72030: Execution mode invalid.
OPATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared.
OPATCHAUTO-72030: Execute in non-rolling mode.
OPatchAuto failed.
OPatchauto session completed at Thu Sep 7 22:41:40 2023
Time taken to complete the session 0 minute, 21 seconds
opatchauto failed with error code 42
[root@bjmyedu1 soft]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490
OPatchauto session is initiated at Thu Sep 7 22:41:49 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-07_10-41-52PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-09-07_10-41-57PM.log
The id for this session is RXIP
Shared home /u01/app/19.0.0/grid can only be patched in nonrolling mode.
OPATCHAUTO-72030: Execution mode invalid.
OPATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared.
OPATCHAUTO-72030: Execute in non-rolling mode.
OPatchAuto failed.
OPatchauto session completed at Thu Sep 7 22:42:10 2023
Time taken to complete the session 0 minute, 18 seconds
opatchauto failed with error code 42
[root@bjmyedu1 soft]#
[root@bjmyedu1 soft]# export ^C
2， 解决方法
[root@bjmyedu1 soft]# export CV_ASSUME_DISTID=RHEL7.6[root@bjmyedu1 soft]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Thu Sep 7 22:43:29 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-07_10-43-32PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-09-07_10-43-39PM.log
The id for this session is VG16
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/bjmyedu1/crsconfig/crs_prepatch_apply_inplace_bjmyedu1_2023-09-07_10-44-22PM.log
CRS service brought down successfully on home /u01/app/19.0.0/grid
Start applying binary patch on home /u01/app/19.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/bjmyedu1/crsconfig/crs_postpatch_apply_inplace_bjmyedu1_2023-09-07_10-50-57PM.log
CRS service started successfully on home /u01/app/19.0.0/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:bjmyedu1
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /soft/35319490/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_22-46-50PM_1.log
Patch: /soft/35319490/35320081
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_22-46-50PM_1.log
Patch: /soft/35319490/35320149
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_22-46-50PM_1.log
Patch: /soft/35319490/35332537
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_22-46-50PM_1.log
Patch: /soft/35319490/35553096
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_22-46-50PM_1.log
OPatchauto session completed at Thu Sep 7 22:54:41 2023
Time taken to complete the session 11 minutes, 9 seconds
[root@bjmyedu1 soft]#
[root@bjmyedu1 soft]#
[root@bjmyedu1 soft]#
[root@bjmyedu1 soft]# cat /etc/redhat-release
Rocky Linux release 8.8 (Green Obsidian)
3, DB安装RU
[root@bjmyedu1 soft]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/oracle/product/19.0.0/dbhome_1/
opatchauto must run from one of the homes specified
opatchauto returns with error code = 2
[root@bjmyedu1 soft]# cd
[root@bjmyedu1 ~]#
[root@bjmyedu1 ~]# cd /tmp/
[root@bjmyedu1 tmp]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/oracle/product/19.0.0/dbhome_1
opatchauto must run from one of the homes specified
opatchauto returns with error code = 2
[root@bjmyedu1 tmp]# /u01/app/oracle/ apply /soft/35319490 -oh /u01/app/oracle/product/19.0.0/dbhome_1
checkpoints/ diag/ product/
[root@bjmyedu1 tmp]# /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/oracle/product/19.0.0/dbhome_1
OPatchauto session is initiated at Thu Sep 7 23:01:26 2023
System initialization log file is /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2023-09-07_11-01-29PM.log.
Remote command execution failed due to Exception in thread "main" oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: failed to detect Grid Infrastructure setup due to null
at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.detectCrsHome(ClusterInformationLoader.java:328)
at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.loadInventory(ClusterInformationLoader.java:81)
at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.getInstance(ClusterInformationLoader.java:70)
at oracle.dbsysmodel.driver.sdk.productdriver.remote.HomeListCollector.executeAction(HomeListCollector.java:31)
at oracle.dbsysmodel.driver.sdk.productdriver.remote.RemoteOperationHelper.main(RemoteOperationHelper.java:26)
Command output:
OPATCHAUTO-72050: System instance creation failed.
OPATCHAUTO-72050: Failed while retrieving system information.
OPATCHAUTO-72050: Please check log file for more details.
OPatchauto session completed at Thu Sep 7 23:01:53 2023
Time taken to complete the session 0 minute, 24 seconds
Topology creation failed.
[root@bjmyedu1 tmp]# export CV_ASSUME_DISTID=RHEL7.6
[root@bjmyedu1 tmp]# /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto apply /soft/35319490 -oh /u01/app/oracle/product/19.0.0/dbhome_1
OPatchauto session is initiated at Thu Sep 7 23:02:39 2023
System initialization log file is /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2023-09-07_11-02-42PM.log.
Session log file is /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2023-09-07_11-02-54PM.log
The id for this session is HQZ7
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
No sqlpatch prereq operations are required on the local node for this home
No step execution required.........
Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/dbhome_1
No step execution required.........
Performing prepatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19.0.0/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Performing postpatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1
Preparing home /u01/app/oracle/product/19.0.0/dbhome_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0/dbhome_1
No SQL patch operations are required on local node for this home
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:bjmyedu1
RAC Home:/u01/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /soft/35319490/35332537
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/35319490/33575402
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/35319490/35553096
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /soft/35319490/35320081
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_23-03-35PM_1.log
Patch: /soft/35319490/35320149
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-09-07_23-03-35PM_1.log
OPatchauto session completed at Thu Sep 7 23:07:59 2023
Time taken to complete the session 5 minutes, 17 seconds
