重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 19.3升级19.7补丁报CheckSystemCommandAvailable处理办法 [打印本页]

作者: 王亮 时间: 2020-7-5 16:32
标题: oracle 19.3升级19.7补丁报CheckSystemCommandAvailable处理办法
本帖最后由王亮于 2020-7-8 19:06 编辑

在进行oracle 19.3升级oracle 19.7，在手动打升级补丁时，补丁冲突检查没有问题，但在补丁应用时，却提示Prerequisite check"CheckSystemCommandAvailable" failed. 查看升级日志，最后也是显示那个错误提示
检查补丁冲突内容如下：

oracle@localhost 30869156]$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir/setup/30869156/

Oracle Interim Patch Installer version12.2.0.1.21

PREREQ session

Oracle Home : /u01/app/oracle/product/19.3.0

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.3.0/oraInst.loc

OPatch version : 12.2.0.1.21

OUI version : 12.2.0.7.0

Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_19-52-01PM_1.log

Invoking prereq"checkconflictagainstohwithdetail"

Prereq"checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

检查并没有选错，说明补丁没有问题，但在应用补丁时，有错误，内容如下：

[oracle@localhost 30783543]$ /u01/app/oracle/product/19.3.0/OPatch/opatchapply -local /setup/30783543/30805684/

Oracle Interim Patch Installer version12.2.0.1.21

Oracle Home : /u01/app/oracle/product/19.3.0

Central Inventory : /u01/app/oraInventory

from :/u01/app/oracle/product/19.3.0/oraInst.loc

OPatch version : 12.2.0.1.21

OUI version : 12.2.0.7.0

Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_21-01-58PM_1.log

Verifying environment and performingprerequisite checks...

Prerequisite check"CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

UtilSession failed:

Prerequisite check"CheckSystemCommandAvailable" failed.

Log file location:/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_21-01-58PM_1.log

OPatch failed with error code 73

处理方法呢，是需要安装一个psmisc包，这个包使用系统的ISO文件配置本地yum源，进行yum安装。

在安装完成之后，再手动进行补丁的应用，即可完成升级，最后显示一下oracle版本

验证

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Productionon Thu Jul 2 00:15:02 2020

Version 19.7.0.0.0

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1593832664 bytes

Fixed Size 9135320 bytes

Variable Size 1493172224 bytes

Database Buffers 83886080 bytes

Redo Buffers 7639040 bytes

Database mounted.

Database opened.

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

CON_ID

----------

Oracle Database 19c Enterprise EditionRelease 19.0.0.0.0 - Production

Version 19.7.0.0.0

Oracle Database 19c Enterprise EditionRelease 19.0.0.0.0 – Production

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)