19C 补丁安装问题汇总

问题1：

现象：

Start applying binary patch on home /u01/app/19.3.0/grid
Failed while applying binary patches on home /u01/app/19.3.0/grid

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : iotdb3node1->/u01/app/19.3.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.3.0/grid, host: iotdb3node1.
Command failed:  /u01/app/19.3.0/grid/OPatch/opatchauto  apply /u01/soft/30463609/30501910 -oh /u01/app/19.3.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.3.0/grid/oraInst.loc -jre /u01/app/19.3.0/grid/OPatch/jre -persistresult /u01/app/19.3.0/grid/OPatch/auto/dbsessioninfo/sessionresult_iotdb3node1_crs.ser -analyzedresult /u01/app/19.3.0/grid/OPatch/auto/dbsessioninfo/sessionresult_analyze_iotdb3node1_crs.serCommand failure output: 
==Following patches FAILED in apply:

Patch: /u01/soft/30463609/30501910/30557433
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_19-12-30PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed. 

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 Tue Mar 10 19:13:55 2020
Time taken to complete the session 5 minutes, 6 seconds

 opatchauto failed with error code 42
复制

日志：

[Mar 10, 2020 7:13:55 PM] [INFO]    Finish fuser command /sbin/fuser /u01/app/19.3.0/grid/lib/libasmclntsh19.so at Tue Mar 10 19:13:55 CST 2020
[Mar 10, 2020 7:13:55 PM] [INFO]    Following active executables are not used by opatch process :
                                    
                                    
                                    Following active executables are used by opatch process :
                                    /u01/app/19.3.0/grid/lib/libclntsh.so.19.1
[Mar 10, 2020 7:13:55 PM] [INFO]    Prerequisite check "CheckActiveFilesAndExecutables" failed.
                                    The details are:
                                    
                                    
                                    Following active executables are not used by opatch process :
                                    
                                    
                                    Following active executables are used by opatch process :
                                    /u01/app/19.3.0/grid/lib/libclntsh.so.19.1
[Mar 10, 2020 7:13:55 PM] [INFO]    UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Mar 10, 2020 7:13:55 PM] [SEVERE]  OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Mar 10, 2020 7:13:55 PM] [INFO]    Finishing UtilSession at Tue Mar 10 19:13:55 CST 2020
[Mar 10, 2020 7:13:55 PM] [INFO]    Log file location: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_19-12-30PM_1.log
[root@iotdb3node1 ~]# 
复制

处理办法：
查看进程的调用，kill进程
重新执行安装命令或者resume。

问题2：

现象：

[root@iotdb2node2 30489227]# /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply  /u01/soft/30463609/30501910  -oh /u01/app/oracle/product/19.3.0/db_1

OPatchauto session is initiated at Tue Mar 10 20:29:44 2020

System initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2020-03-10_08-29-46PM.log.

Session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2020-03-10_08-30-17PM.log
The id for this session is Y7WN

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verification failed 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 : iotdb2node2->/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: iotdb2node2.
Command failed:  /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto  apply /u01/soft/30463609/30501910 -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/OPatch/auto/dbsessioninfo/sessionresult_analyze_iotdb2node2_rac.ser -analyze -online -prepare_home
Command failure output: 
==Following patches FAILED in analysis for apply:

Patch: /u01/soft/30463609/30501910/30489227
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30489227 is corrupted. PatchObject constructor: Input file "/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/30489227/etc/config/actions" or "/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/30489227/etc/config/inventory" does not exist.


Patch: /u01/soft/30463609/30501910/30557433
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30489227 is corrupted. PatchObject constructor: Input file "/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/30489227/etc/config/actions" or "/u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/30489227/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 Tue Mar 10 20:30:26 2020
Time taken to complete the session 0 minute, 42 seconds

 opatchauto failed with error code 42
[root@iotdb2node2 30489227]#
复制

处理办法：
手动cp

cd /u01/app/oracle/product/19.3.0/db_1/inventory/oneoffs/
mkdir 30489227
cp -r /u01/soft/30463609/30501910/30489227/etc ./30489227/
chown oracle:oinstall -R 30489227
chmod 750 30489227
复制

重新执行安装命令或者resume。

问题3：

现象：
在补丁安装之后启动crs报错。

Start applying binary patch on home /u01/app/19.3.0/grid
Binary patch applied successfully on home /u01/app/19.3.0/grid
Starting CRS service on home /u01/app/19.3.0/grid
Failed to start CRS service on home /u01/app/19.3.0/grid
Execution of [GIStartupAction] patch action failed, check log for more details. Failures:
Patch Target : iotdb4node1->/u01/app/19.3.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.3.0/grid, host: iotdb4node1.
Command failed:  /u01/app/19.3.0/grid/perl/bin/perl -I/u01/app/19.3.0/grid/perl/lib -I/u01/app/19.3.0/grid/OPatch/auto/dbtmp/bootstrap_iotdb4node1/patchwork/crs/install -I/u01/app/19.3.0/grid/OPatch/auto/dbtmp/bootstrap_iotdb4node1/patchwork/xag /u01/app/19.3.0/grid/OPatch/auto/dbtmp/bootstrap_iotdb4node1/patchwork/crs/install/rootcrs.pl -postpatch
Command failure output: 
Using configuration parameter file: /u01/app/19.3.0/grid/OPatch/auto/dbtmp/bootstrap_iotdb4node1/patchwork/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/iotdb4node1/crsconfig/crs_postpatch_iotdb4node1_2020-03-11_01-09-02PM.log
2020/03/11 13:09:13 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-41053: checking Oracle Grid Infrastructure for file permission issues
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
2020/03/11 13:15:09 CLSRSC-117: Failed to start Oracle Clusterware stack 
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 Wed Mar 11 13:15:10 2020
Time taken to complete the session 8 minutes, 41 seconds

 opatchauto failed with error code 42
[root@iotdb4node1 ~]# 
复制

处理办法：手动启动crs
重新执行补丁安装命令。