OPatch failed with error code 73
oracle 11g打psu补丁提示error coed 73
原因一:具体提示如下
[oracle@eheng:/oradata/31537677]$/oracle/product/11.2.0.4/db_1/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /oracle/product/11.2.0.4/db_1 Central Inventory : /oracle/oraInventory from : /oracle/product/11.2.0.4/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-08-23_12-06-17PM_1.log Verifying environment and performing prerequisite checks... NApply could not load patch from location '/oradata/31537677/31103343' UtilSession failed: Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata. Log file location: /oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-08-23_12-06-17PM_1.log OPatch failed with error code 73
该错误是由于opatch版本较低所导致,从mos上下载最新的opatch进行升级即可。
升级步骤如下,上传p6880880_112000_Linux-x86-64.zip到$ORACLE_HOME
mv OPatch OPatch_bak unzip p6880880_112000_Linux-x86-64.zip [oracle@eheng:/oracle/product/11.2.0.4/db_1/OPatch]$./opatch version OPatch Version: 11.2.0.3.36 OPatch succeeded.
原因二:具体提示如下
[oracle@eheng:/oradata/31537677]$/oracle/product/11.2.0.4/db_1/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.36 Copyright (c) 2022, Oracle Corporation. All rights reserved. Oracle Home : /oracle/product/11.2.0.4/db_1 Central Inventory : /oracle/oraInventory from : /oracle/product/11.2.0.4/db_1/oraInst.loc OPatch version : 11.2.0.3.36 OUI version : 11.2.0.4.0 Log file location : /oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-08-23_12-10-44PM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following active files/executables/libs are used by ORACLE_HOME :/oracle/product/11.2.0.4/db_1 /oracle/product/11.2.0.4/db_1/lib/libclntsh.so.11.1 /oracle/product/11.2.0.4/db_1/bin/oracle Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following active files/executables/libs are used by ORACLE_HOME :/oracle/product/11.2.0.4/db_1 /oracle/product/11.2.0.4/db_1/lib/libsqlplus.so UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-08-23_12-10-44PM_1.log OPatch failed with error code 73
错误显示有进程还在使用这两个库文件。
查看是什么进程在使用,随后用kill杀掉进程
[oracle@eheng:/oradata/31537677]$fuser /oracle/product/11.2.0.4/db_1/lib/libclntsh.so.11.1 /oracle/product/11.2.0.4/db_1/lib/libclntsh.so.11.1: 30425m 30633m 30783m [oracle@eheng:/oradata/31537677]$ps -ef |grep 30425 oracle 30425 30424 0 11:15 pts/4 00:00:00 sqlplus as sysdba oracle 32513 31513 0 12:12 pts/1 00:00:00 grep 30425 [oracle@eheng:/oradata/31537677]kill -9 30425 [oracle@eheng:/oradata/31537677]kill -9 30633 [oracle@eheng:/oradata/31537677]kill -9 30783