Shulou(Shulou.com)06/01 Report--

Environment: rhel7.6 oracle 19c rac

Cluster resource status

[grid@19crac1] $crsctl stat res-t-init

Ora.asm

1 ONLINE ONLINE 19crac1 STABLE

Ora.cluster_interconnect.haip

1 ONLINE ONLINE 19crac1 STABLE

Ora.crf

1 ONLINE ONLINE 19crac1 STABLE

Ora.crsd

1 ONLINE ONLINE 19crac1 STABLE

Ora.cssd

1 ONLINE ONLINE 19crac1 STABLE

Ora.cssdmonitor

1 ONLINE ONLINE 19crac1 STABLE

Ora.ctssd

1 ONLINE ONLINE 19crac1 ACTIVE:0,STABLE

Ora.diskmon

1 OFFLINE OFFLINE STABLE

Ora.drivers.acfs

1 ONLINE ONLINE 19crac1 STABLE

Ora.evmd

1 ONLINE ONLINE 19crac1 STABLE

Ora.gipcd

1 ONLINE ONLINE 19crac1 STABLE

Ora.gpnpd

1 ONLINE ONLINE 19crac1 STABLE

Ora.mdnsd

1 ONLINE ONLINE 19crac1 STABLE

Ora.storage

1 ONLINE ONLINE 19crac1 STABLE

[grid@19crac1] $crsctl stat res-t

Ora.LISTENER.lsnr

ONLINE ONLINE 19crac1 STABLE

ONLINE ONLINE 19crac2 STABLE

Ora.chad

ONLINE ONLINE 19crac1 STABLE

ONLINE ONLINE 19crac2 STABLE

Ora.net1.network

ONLINE ONLINE 19crac1 STABLE

ONLINE ONLINE 19crac2 STABLE

Ora.ons

ONLINE ONLINE 19crac1 STABLE

ONLINE ONLINE 19crac2 STABLE

Ora.proxy_advm

OFFLINE OFFLINE 19crac1 STABLE

OFFLINE OFFLINE 19crac2 STABLE

Ora.19crac1.vip

1 ONLINE ONLINE 19crac1 STABLE

Ora.19crac2.vip

1 ONLINE ONLINE 19crac2 STABLE

Ora.ARCHDG.dg (ora.asmgroup)

1 ONLINE ONLINE 19crac1 STABLE

2 ONLINE ONLINE 19crac2 STABLE

Ora.ASMNET1LSNR_ASM.lsnr (ora.asmgroup)

1 ONLINE ONLINE 19crac1 STABLE

2 ONLINE ONLINE 19crac2 STABLE

Ora.DATADG.dg (ora.asmgroup)

1 ONLINE ONLINE 19crac1 STABLE

2 ONLINE ONLINE 19crac2 STABLE

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE 19crac2 STABLE

Ora.OCRDG.dg (ora.asmgroup)

1 ONLINE ONLINE 19crac1 STABLE

2 ONLINE ONLINE 19crac2 STABLE

Ora.asm (ora.asmgroup)

1 ONLINE ONLINE 19crac1 Started,STABLE

2 ONLINE ONLINE 19crac2 Started,STABLE

Ora.asmnet1.asmnetwork (ora.asmgroup)

1 ONLINE ONLINE 19crac1 STABLE

2 ONLINE ONLINE 19crac2 STABLE

Ora.cvu

1 ONLINE ONLINE 19crac2 STABLE

Ora.qosmserver

1 ONLINE ONLINE 19crac2 STABLE

Ora.scan1.vip

1 ONLINE ONLINE 19crac2 STABLE

Operation: type the latest RU, and the patch package is named p29699097_190000_Linux-x86-64.zip

Process: follow the instructions of readme, replace OPatch, patch directly

[root@19crac1 OPatch] #. / opatchauto apply / u01/soft/29699097/29708769/

Report an error in the process:

[root@19crac1 OPatch] #. / opatchauto apply / u01/soft/29699097/29708769/

OPatchauto session is initiated at Sun Dec 8 12:51:27 2019

System initialization log file is / u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2019-12-08-12-51-30PM.log.

Session log file is / u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2019-12-08 / 12-52-00PM.log

The id for this session is UJK7

Executing OPatch prereq operations to verify patch applicability on home / u01/app/19c/grid

Patch applicability verification failed on home / u01/app/19c/grid

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:

Patch Target: 19crac1-> / u01/app/19c/grid Type [crs]

Details: [

-- Patching Failed--

Command execution failed during patching in home: / u01/app/19c/grid, host: 19crac1.

Command failed: / u01/app/19c/grid/OPatch/opatchauto apply / u01/soft/29699097/29708769/-oh / u01/app/19c/grid-target_type cluster-binary-invPtrLoc / u01/app/19c/grid/oraInst.loc-jre / u01/app/19c/grid/OPatch/jre-persistresult / u01/app/19c/grid/OPatch/auto/dbsessioninfo/sessionresult_analyze_19crac1_crs.ser-analyze-online-prepare_home

Command failure output:

= = Following patches FAILED in analysis for apply:

Patch: / u01/soft/29699097/29708769/29834717

Log: / u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch3019-12-08 / 12-52-09PM_1.log

Reason: Failed during Analysis: CheckSystemCommandsAvailable Failed, [Prerequisite Status: FAILED, Prerequisite output:

The details are:

Missing command: fuser]

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 Sun Dec 8 12:52:15 2019

Time taken to complete the session 0 minute, 48 seconds

Opatchauto failed with error code 42

Found that the fuser command could not be found.

Further check for [root@19crac1 OPatch] # which fuser

/ usr/bin/which: no fuser in (/ usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin)

Found that there is no, my system for minimal installation, may have something to do with this, so install

[root@19crac1 ~] # yum search fuser

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

= Matched: fuser =

Psmisc.x86_64: Utilities for managing processes on your system

[root@19crac1 ~] # yum install psmisc

Loaded plugins: product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Base | 4.3 kB 00:00:00

Resolving Dependencies

-> Running transaction check

-> Package psmisc.x86_64 0RU 22.20-15.el7 will be installed

-> Finished Dependency Resolution

Dependencies Resolved

Package Arch Version Repository Size

Installing:

Psmisc x8631 64 22.20-15.el7 base 141k

Transaction Summary

Install 1 Package

Total download size: 141 k

Installed size: 475 k

Is this ok [y/d/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

Installing: psmisc-22.20-15.el7.x86_64 1 Compact 1

Verifying: psmisc-22.20-15.el7.x86_64 1 Compact 1

Installed:

Psmisc.x86_64 0VR 22.20-15.el7

Complete!

Execute [root@19crac1 OPatch] #. / opatchauto apply / u01/soft/29699097/29708769/ again

OPatchauto session is initiated at Sun Dec 8 12:54:26 2019

System initialization log file is / u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2019-12-08-12-54-28PM.log.

Session log file is / u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2019-12-08 / 12-54-52PM.log

The id for this session is GI54

Executing OPatch prereq operations to verify patch applicability on home / u01/app/19c/grid

Patch applicability verified successfully on home / u01/app/19c/grid

Bringing down CRS service on home / u01/app/19c/grid

CRS service brought down successfully on home / u01/app/19c/grid

Start applying binary patch on home / u01/app/19c/grid

Binary patch applied successfully on home / u01/app/19c/grid

Starting CRS service on home / u01/app/19c/grid

CRS service started successfully on home / u01/app/19c/grid

OPatchAuto successful.

-- Summary--

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

Host:19crac1

CRS Home:/u01/app/19c/grid

Version:19.0.0.0.0

Summary:

= = Following patches were SKIPPED:

Patch: / u01/soft/29699097/29708769/29401763

Reason: This patch is already been applied, so not going to apply again.

= = Following patches were SUCCESSFULLY applied:

Patch: / u01/soft/29699097/29708769/29834717

Log: / u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch3019-12-08 / 12-57-47PM_1.log

Patch: / u01/soft/29699097/29708769/29850993

Log: / u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch3019-12-08 / 12-57-47PM_1.log

Patch: / u01/soft/29699097/29708769/29851014

Log: / u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch3019-12-08 / 12-57-47PM_1.log

OPatchauto session completed at Sun Dec 8 13:03:32 2019

Time taken to complete the session 9 minutes, 6 seconds

Won't make a mistake.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.