Oracle 19c RAC 环境升级 19.6 RU OPatch Prerequisite check "CheckApplicable" failed 解决方法

您所在的位置:网站首页 阿胶的效果真的很好吗知乎 Oracle 19c RAC 环境升级 19.6 RU OPatch Prerequisite check "CheckApplicable" failed 解决方法

Oracle 19c RAC 环境升级 19.6 RU OPatch Prerequisite check "CheckApplicable" failed 解决方法

2023-04-26 09:27| 来源: 网络整理| 查看: 265

1错误1:ocrconfig.bin” does not exists or is not readable 1.1 现象

19c的RAC 环境,升级RU 从19.3 到 19.6,根据19.6 RU readme文档的操作,opatchauto的时候,报错:

[[email protected] software]# export PATH=$PATH:/u01/app/19.3.0/grid/OPatch [[email protected] software]# opatchauto apply /u01/software/30501910 OPatchauto session is initiated at Thu Mar 12 21:18:26 2020 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-12_09-18-36PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-12_09-21-01PM.log The id for this session is 5Z4B Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /u01/app/19.3.0/grid Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1 Successfully prepared home /u01/app/oracle/product/19.3.0/db_1 to bring down database service Bringing down CRS service on home /u01/app/19.3.0/grid CRS service brought down successfully on home /u01/app/19.3.0/grid Performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1 Perpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1 Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_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 : rac1->/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: rac1. Command failed: /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/software/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_rac1_crs.ser -analyzedresult /u01/app/19.3.0/grid/OPatch/auto/dbsessioninfo/sessionresult_analyze_rac1_crs.ser Command failure output: ==Following patches FAILED in apply: Patch: /u01/software/30501910/30489227 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-12_21-45-54PM_1.log Reason: Failed during Analysis: CheckNApplyReport Failed, [ Prerequisite Status: FAILED, Prerequisite output: The details are: Prerequisite check "CheckApplicable" 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 Thu Mar 12 21:46:04 2020 Time taken to complete the session 27 minutes, 39 seconds opatchauto failed with error code 42 [[email protected] software]#

查看错误日志:https://www.cndba.cn/dave/article/4081

[Mar 12, 2020 10:36:54 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 30489227 [Mar 12, 2020 10:36:57 PM] [WARNING]Action file /u01/app/19.3.0/grid/jlib/srvmasm.jar is in the jar list,OOP should be lanched [Mar 12, 2020 10:36:58 PM] [INFO] Patch 30489227: Copy Action: Source File "/u01/software/30501910/30489227/files/bin/ocrcheck.bin" does not exists or i s not readable 'oracle.has.crs, 19.0.0.0.0': Cannot copy file from 'ocrcheck.bin' to '/u01/app/19.3.0/grid/bin/ocrche ck.bin' Copy Action: Source File "/u01/software/30501910/30489227/files/bin/ocrconfig.bin" does not exists or is not readable 'oracle.has.crs, 19.0.0.0.0': Cannot copy file from 'ocrconfig.bin' to '/u01/app/19.3.0/grid/bin/ocrco nfig.bin' [Mar 12, 2020 10:36:58 PM] [INFO] Prerequisite check "CheckApplicable" failed. The details are: Patch 30489227: Copy Action: Source File "/u01/software/30501910/30489227/files/bin/ocrcheck.bin" does not exists or i s not readable 'oracle.has.crs, 19.0.0.0.0': Cannot copy file from 'ocrcheck.bin' to '/u01/app/19.3.0/grid/bin/ocrche ck.bin' Copy Action: Source File "/u01/software/30501910/30489227/files/bin/ocrconfig.bin" does not exists or is not readable 'oracle.has.crs, 19.0.0.0.0': Cannot copy file from 'ocrconfig.bin' to '/u01/app/19.3.0/grid/bin/ocrco nfig.bin' [Mar 12, 2020 10:36:58 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckApplicable" failed. [Mar 12, 2020 10:36:58 PM] [INFO] Finishing UtilSession at Thu Mar 12 22:36:58 CST 2020 [Mar 12, 2020 10:36:58 PM] [INFO] Log file location: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-12_22-36-43PM _1.log [Mar 12, 2020 10:36:58 PM] [INFO] Stack Description: java.lang.RuntimeException: Prerequisite check "CheckApplicable" failed. at oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6548) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:1002) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:370) at oracle.opatch.opatchutil.NApply.process(NApply.java:352) at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1123) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at oracle.opatch.UtilSession.process(UtilSession.java:355) at oracle.opatch.OPatchSession.main(OPatchSession.java:3985) at oracle.opatch.OPatchSDK.NApply(OPatchSDK.java:1127) at oracle.opatch.opatchsdk.OPatchTarget.NApplyReport(OPatchTarget.java:3964) at oracle.opatch.opatchsdk.OPatchTarget.NApplyReportForAllPrereqs(OPatchTarget.java:4013) at oracle.opatchauto.core.binary.action.AnalyzeReportGenerator.analyzePatch(AnalyzeReportGenerator .java:186) at oracle.opatchauto.core.binary.action.AnalyzeReportGenerator.execute(AnalyzeReportGenerator.java :148) at oracle.opatchauto.core.binary.action.LegacyPatchAction.execute(LegacyPatchAction.java:46) at oracle.opatchauto.core.binary.OPatchAutoBinary.patchWithoutAnalyze(OPatchAutoBinary.java:519) at oracle.opatchauto.core.binary.OPatchAutoBinary.applyWithoutAnalyze(OPatchAutoBinary.java:406) at oracle.opatchauto.core.OPatchAutoCore.runOPatchAutoBinary(OPatchAutoCore.java:192) at oracle.opatchauto.core.OPatchAutoCore.main(OPatchAutoCore.java:75) Caused by: java.lang.RuntimeException: Prerequisite check "CheckApplicable" failed. ... 21 more Caused by: oracle.opatch.PrereqFailedException: Prerequisite check "CheckApplicable" failed. ... 21 more [Mar 12, 2020 10:36:58 PM] [INFO] EXITING METHOD: NApplyReport(OPatchPatch[] patches,OPatchNApplyOptions options) [[email protected] OPatch]$ 1.2 解决方法

这里的错误是:

“/u01/software/30501910/30489227/files/bin/ocrconfig.bin” does not exists or is not readable

从这里看像是权限问题,手工修改RU 补丁的权限:

[[email protected] software]# chown grid:oinstall 30501910 -R

再次执行变成了另外的错误。

2 错误2:Copy failed from ‘…/files/bin/cssdagent’ to ‘…/bin/cssdagent’… 2.1 现象

再次执行,还是报错。如下:

2020-03-13 08:36:48,374 INFO [313] com.oracle.glcm.patch.auto.db.integration.controller.action.OPatchAutoBinaryAction - Opatchcore binary error message= 2020-03-13 08:36:48,375 INFO [313] com.oracle.glcm.patch.auto.db.integration.controller.action.OPatchAutoBinaryAction - Reading session result from /u01/app/19.3.0/grid/opatchautocfg/db/sessioninfo/sessionresult_rac1_crs.ser 2020-03-13 08:36:48,380 INFO [313] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='Failed while applying binary patches on home /u01/app/19.3.0/grid '} 2020-03-13 08:36:48,381 SEVERE [311] com.oracle.glcm.patch.auto.action.PatchActionExecutor - Failed to execute patch action [com.oracle.glcm.patch.auto.db.integration.controller.action.OPatchAutoBinaryAction] on patch target [rac1->/u01/app/19.3.0/grid Type[crs]]. 2020-03-13 08:36:48,382 INFO [311] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures: Patch Target : rac1->/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: rac1. Command failed: /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/software/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/opatchautocfg/db/sessioninfo/sessionresult_rac1_crs.ser -analyzedresult /u01/app/19.3.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac1_crs.ser Command failure output: ==Following patches FAILED in apply: Patch: /u01/software/30501910/30489227 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_08-31-51AM_1.log Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: Copy failed from '/u01/software/30501910/30489227/files/bin/crsd.bin' to '/u01/app/19.3.0/grid/bin/crsd.bin'... Copy failed from '/u01/software/30501910/30489227/files/bin/cssdagent' to '/u01/app/19.3.0/grid/bin/cssdagent'... Copy failed from '/u01/software/30501910/30489227/files/bin/cssdmonitor' to '/u01/app/19.3.0/grid/bin/cssdmonitor'... Copy fa ... After fixing the cause of failure Run opatchauto resume ]'} 2020-03-13 08:36:48,407 SEVERE [41] com.oracle.cie.wizard.internal.engine.WizardControllerEngine - Wizard error cause com.oracle.cie.wizard.tasks.TaskExecutionException: OPATCHAUTO-68128: Patch action execution failed. OPATCHAUTO-68128: Failed to execute patch actions for goal offline:binary-patching OPATCHAUTO-68128: Check the log for more information. at com.oracle.glcm.patch.auto.wizard.silent.tasks.PatchActionTask.execute(PatchActionTask.java:106) at com.oracle.cie.wizard.internal.cont.SilentTaskContainer$TaskRunner.run(SilentTaskContainer.java:102) at java.lang.Thread.run(Thread.java:748) Caused by: com.oracle.glcm.patch.auto.OPatchAutoException: OPATCHAUTO-68067: Patch action execution failed. OPATCHAUTO-68067: Failed to execute patch action [com.oracle.glcm.patch.auto.db.integration.controller.action.OPatchAutoBinaryAction Patch Target : rac1->/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: rac1. Command failed: /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/software/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/opatchautocfg/db/sessioninfo/sessionresult_rac1_crs.ser -analyzedresult /u01/app/19.3.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac1_crs.ser Command failure output: ==Following patches FAILED in apply: Patch: /u01/software/30501910/30489227 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_08-31-51AM_1.log Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: Copy failed from '/u01/software/30501910/30489227/files/bin/crsd.bin' to '/u01/app/19.3.0/grid/bin/crsd.bin'... Copy failed from '/u01/software/30501910/30489227/files/bin/cssdagent' to '/u01/app/19.3.0/grid/bin/cssdagent'... Copy failed from '/u01/software/30501910/30489227/files/bin/cssdmonitor' to '/u01/app/19.3.0/grid/bin/cssdmonitor'... Copy fa ... After fixing the cause of failure Run opatchauto resume ]]. Failures: OPATCHAUTO-68067: Check the details to determine the cause of the failure. at com.oracle.glcm.patch.auto.action.PatchActionExecutor.execute(PatchActionExecutor.java:172) at com.oracle.glcm.patch.auto.wizard.silent.tasks.PatchActionTask.execute(PatchActionTask.java:102) ... 2 more 2020-03-13 08:36:48,516 INFO [1] com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport - Space available after session: 44935 MB 2020-03-13 08:36:49,875 SEVERE [1] com.oracle.glcm.patch.auto.OPatchAuto - OPatchAuto failed. com.oracle.glcm.patch.auto.OPatchAutoException: OPATCHAUTO-68061: The orchestration engine failed. OPATCHAUTO-68061: The orchestration engine failed with return code 1 OPATCHAUTO-68061: Check the log for more details. at com.oracle.glcm.patch.auto.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:40) at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:858) at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:398) at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:344) at com.oracle.glcm.patch.auto.OPatchAuto.main(OPatchAuto.java:212) 2020-03-13 08:36:49,875 INFO [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='OPATCHAUTO-68061: The orchestration engine failed. OPATCHAUTO-68061: The orchestration engine failed with return code 1 OPATCHAUTO-68061: Check the log for more details.'} 2020-03-13 08:36:49,875 INFO [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='OPatchAuto failed.'}

这次错误变了:

Copy failed from ‘/u01/software/30501910/30489227/files/bin/cssdagent’ to ‘/u01/app/19.3.0/grid/bin/cssdagent’…https://www.cndba.cn/dave/article/4081

2.2 解决方法

上MOS搜了一下,有一篇文章和这个错误很类似:

opatch report “ERROR: Prereq checkApplicable failed.” when Applying Grid Infrastructure patch (Doc ID 1417268.1)

MOS里将了多种原因可能会触发这个错误,和我这里最像的是这一条:

D. The patch is not unzipped as grid user, often it is unzipped as root user ls -l will show the files are owned by root user. The solution is to unzip the patch as grid user into an empty directory outside of GRID_HOME, then retry the patch apply.

我的RU patch 虽然不在GRID_HOME目录下,但也是用root用户解压缩的。 删除原来的解压缩后,重新用grid用户解压缩一次,在打补丁,还是同样的错误:

[[email protected] tmp]$ unzip -d /tmp p30501910_190000_Linux-x86-64-GI.zip [Mar 13, 2020 9:18:08 AM] [INFO] Copying file to "/u01/app/19.3.0/grid/srvm/lib/sprraw.o" [Mar 13, 2020 9:18:08 AM] [INFO] The following actions have failed: [Mar 13, 2020 9:18:08 AM] [WARNING] OUI-67124:Copy failed from '/tmp/30501910/30489227/files/bin/crsd.bin' to '/u01/app/19.3.0/grid/bin/crsd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/cssdagent' to '/u01/app/19.3.0/grid/bin/cssdagent'... Copy failed from '/tmp/30501910/30489227/files/bin/cssdmonitor' to '/u01/app/19.3.0/grid/bin/cssdmonitor'... Copy failed from '/tmp/30501910/30489227/files/bin/evmd.bin' to '/u01/app/19.3.0/grid/bin/evmd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/evmlogger.bin' to '/u01/app/19.3.0/grid/bin/evmlogger.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/gipcd.bin' to '/u01/app/19.3.0/grid/bin/gipcd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/gpnpd.bin' to '/u01/app/19.3.0/grid/bin/gpnpd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/mdnsd.bin' to '/u01/app/19.3.0/grid/bin/mdnsd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/ocssd.bin' to '/u01/app/19.3.0/grid/bin/ocssd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/octssd.bin' to '/u01/app/19.3.0/grid/bin/octssd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/ohasd.bin' to '/u01/app/19.3.0/grid/bin/ohasd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/oraagent.bin' to '/u01/app/19.3.0/grid/bin/oraagent.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/orarootagent.bin' to '/u01/app/19.3.0/grid/bin/orarootagent.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/osysmond.bin' to '/u01/app/19.3.0/grid/bin/osysmond.bin'... [Mar 13, 2020 9:18:08 AM] [INFO] Do you want to proceed? [y|n] [Mar 13, 2020 9:18:08 AM] [INFO] N (auto-answered by -silent) [Mar 13, 2020 9:18:08 AM] [INFO] User Responded with: N [Mar 13, 2020 9:18:08 AM] [WARNING] OUI-67124:ApplySession failed in system modification phase... 'ApplySession::apply failed: Copy failed from '/tmp/30501910/30489227/f iles/bin/crsd.bin' to '/u01/app/19.3.0/grid/bin/crsd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/cssdagent' to '/u01/app/19.3.0/grid/bin/cssdagent'... Copy failed from '/tmp/30501910/30489227/files/bin/cssdmonitor' to '/u01/app/19.3.0/grid/bin/cssdmonitor'... Copy failed from '/tmp/30501910/30489227/files/bin/evmd.bin' to '/u01/app/19.3.0/grid/bin/evmd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/evmlogger.bin' to '/u01/app/19.3.0/grid/bin/evmlogger.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/gipcd.bin' to '/u01/app/19.3.0/grid/bin/gipcd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/gpnpd.bin' to '/u01/app/19.3.0/grid/bin/gpnpd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/mdnsd.bin' to '/u01/app/19.3.0/grid/bin/mdnsd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/ocssd.bin' to '/u01/app/19.3.0/grid/bin/ocssd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/octssd.bin' to '/u01/app/19.3.0/grid/bin/octssd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/ohasd.bin' to '/u01/app/19.3.0/grid/bin/ohasd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/oraagent.bin' to '/u01/app/19.3.0/grid/bin/oraagent.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/orarootagent.bin' to '/u01/app/19.3.0/grid/bin/orarootagent.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/osysmond.bin' to '/u01/app/19.3.0/grid/bin/osysmond.bin'... ' [Mar 13, 2020 9:18:08 AM] [INFO] Restoring "/u01/app/19.3.0/grid" to the state prior to running NApply... [Mar 13, 2020 9:18:08 AM] [INFO] Restoring files: copy recurse from /u01/app/19.3.0/grid/.patch_storage/NApply/2020-03-13_09-15-07AM/backup to /u01/app/19.3.0/grid #### Stack trace of processes holding locks #### Time: 2020-03-13_09-14-13AM Command: oracle/opatchauto/core/OPatchAutoCore apply /tmp/30501910 -oh /u01/app/19.3.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.3.0/grid/oraInst.loc -per sistresult /u01/app/19.3.0/grid/opatchautocfg/db/sessioninfo/sessionresult_rac1_crs.ser -analyzedresult /u01/app/19.3.0/grid/opatchautocfg/db/sessioninfo/sessionresult_a nalyze_rac1_crs.ser -customLogDir /u01/app/19.3.0/grid/cfgtoollogs Lock File Name: /u01/app/oraInventory/locks/_u01_app_19.3.0_grid_writer.lock StackTrace: ----------- java.lang.Throwable at oracle.sysman.oii.oiit.OiitLockHeartbeat.writeStackTrace(OiitLockHeartbeat.java:193) at oracle.sysman.oii.oiit.OiitLockHeartbeat.(OiitLockHeartbeat.java:173) at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:346) at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:238) at oracle.sysman.oii.oiic.OiicStandardInventorySession.acquireLocks(OiicStandardInventorySession.java:564) at oracle.sysman.oii.oiic.OiicStandardInventorySession.initAreaControl(OiicStandardInventorySession.java:359) at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:332) at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:294) at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:243) at oracle.sysman.oui.patch.impl.HomeOperationsImpl.initialize(HomeOperationsImpl.java:107) at oracle.glcm.opatch.common.api.install.HomeOperationsShell.initialize(HomeOperationsShell.java:117) at oracle.opatch.ipm.IPMRWServices.addPatchCUP(IPMRWServices.java:134) at oracle.opatch.ipm.IPMRWServices.add(IPMRWServices.java:146) at oracle.opatch.ApplySession.apply(ApplySession.java:899) at oracle.opatch.ApplySession.processLocal(ApplySession.java:4098) at oracle.opatch.ApplySession.process(ApplySession.java:5080) at oracle.opatch.ApplySession.process(ApplySession.java:4942) at oracle.opatch.OPatchACL.processApply(OPatchACL.java:310) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:1429) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:370) at oracle.opatch.opatchutil.NApply.process(NApply.java:352) at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1123) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at oracle.opatch.UtilSession.process(UtilSession.java:355) at oracle.opatch.OPatchSession.main(OPatchSession.java:3985) at oracle.opatch.OPatchSDK.NApply(OPatchSDK.java:1127) at oracle.opatch.opatchsdk.OPatchTarget.NApply(OPatchTarget.java:4169) at oracle.opatchauto.core.binary.action.LegacyPatchAction.execute(LegacyPatchAction.java:76) at oracle.opatchauto.core.binary.OPatchAutoBinary.patchWithoutAnalyze(OPatchAutoBinary.java:519) at oracle.opatchauto.core.binary.OPatchAutoBinary.applyWithoutAnalyze(OPatchAutoBinary.java:406) at oracle.opatchauto.core.OPatchAutoCore.runOPatchAutoBinary(OPatchAutoCore.java:192) at oracle.opatchauto.core.OPatchAutoCore.main(OPatchAutoCore.java:75)

继续研究,有可能是bug:https://www.cndba.cn/dave/article/4081

Bug 13575478 : PATCH APLLICABLE/CONFLICT CHECK FAILED WITH ‘OPATCH AUTO’

https://www.cndba.cn/dave/article/4081 https://www.cndba.cn/dave/article/4081 A. Expected behaviour if GRID_HOME has not been unlocked If GI home has not been unlocked with "rootcrs.pl -unlock", checkapplicable will fail as many files are still owned by root user, this is expected behaviour. The solution is to use "opatch auto" or follow the patch readme step-by-step so the GI home gets unlocked first.

这里的方法和opatchauto有出入,所以尝试进行了analyze,提示有patch 已经打上了,但是通过opatch lspatches 并没有显示,所以对19.6 的RU执行了rollback。

[[email protected] ~]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /tmp/30501910 -analyze [[email protected] ~]# /u01/app/19.3.0/grid/OPatch/opatchauto rollback /tmp/30501910

再次执行,变成了另外错误3.

3 错误3:”CheckActiveFilesAndExecutables” 3.1 现象

这里的错误提示非常明显:https://www.cndba.cn/dave/article/4081https://www.cndba.cn/dave/article/4081

Following active executables are used by opatch process : /u01/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.19.1 /u01/app/oracle/product/19.3.0/db_1/lib/libsqlplus.so [Mar 13, 2020 3:13:26 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/oracle/product/19.3.0/db_1/lib/libclntsh.so.19.1 /u01/app/oracle/product/19.3.0/db_1/lib/libsqlplus.so [Mar 13, 2020 3:13:26 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. [Mar 13, 2020 3:13:26 PM] [INFO] Finishing UtilSession at Fri Mar 13 15:13:26 CST 2020 [Mar 13, 2020 3:13:26 PM] [INFO] Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_15-09-58PM_1.log [[email protected] ~]# 3.2 解决方法

有活动的sqlplus 窗口存在。 先执行rollback:

https://www.cndba.cn/dave/article/4081 [[email protected] ~]# /u01/app/19.3.0/grid/OPatch/opatchauto rollback /tmp/30501910 OPatchauto session is initiated at Fri Mar 13 15:18:58 2020 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-13_03-19-01PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-13_03-21-09PM.log The id for this session is U2H9 Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1 Successfully prepared home /u01/app/oracle/product/19.3.0/db_1 to bring down database service Performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1 Perpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 Start rolling back binary patch on home /u01/app/oracle/product/19.3.0/db_1 Binary patch rolled back successfully on home /u01/app/oracle/product/19.3.0/db_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1 Preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted No step execution required......... Trying to roll back SQL patch on home /u01/app/oracle/product/19.3.0/db_1 SQL patch rolled back successfully on home /u01/app/oracle/product/19.3.0/db_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /tmp/30501910/30489227 Reason: This Patch does not exist in the home, it cannot be rolled back. Patch: /tmp/30501910/30489632 Reason: This Patch does not exist in the home, it cannot be rolled back. Patch: /tmp/30501910/30655595 Reason: This Patch does not exist in the home, it cannot be rolled back. Patch: /tmp/30501910/30557433 Reason: This Patch does not exist in the home, it cannot be rolled back. Host:rac1 RAC Home:/u01/app/oracle/product/19.3.0/db_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /tmp/30501910/30489632 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /tmp/30501910/30655595 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /tmp/30501910/30557433 Reason: Patch /tmp/30501910/30557433 is not applied as part of bundle patch 30501910 ==Following patches were SUCCESSFULLY rolled back: Patch: /tmp/30501910/30489227 Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_15-23-36PM_1.log Patching session reported following warning(s): _________________________________________________ [WARNING] The database instance 'cndba1' from '/u01/app/oracle/product/19.3.0/db_1', in host'rac1' is not running. SQL changes, if any, will not be rolled back. To roll back. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle). Refer to the readme to get the correct steps for applying the sql changes. OPatchauto session completed at Fri Mar 13 15:24:58 2020 Time taken to complete the session 6 minutes, 1 second [[email protected] ~]#

再次apply,依旧报错。

https://www.cndba.cn/dave/article/4081 4错误4:OUI-67073:UtilSession failed: ApplySession failed in system modification phase(这种解决方法不要尝试) 4.1 现象

这里的错误和错误2是一致的。 其实这个错误才是最根本的,影响19c 打RU的现象,只是MOS上没有找到合理的解释。 现在可行的方法就是使用 nonrolling的方式,分别对GI和DB 进行RU的升级。

------------------------------------ [Mar 13, 2020 3:54:57 PM] [INFO] Removed patch "30489227" with UPI + "23305624" from OUI inventory memory.. [Mar 13, 2020 3:54:57 PM] [INFO] Stack Description: java.lang.RuntimeException: OUI session not initialized at oracle.sysman.oui.patch.impl.HomeOperationsImpl.saveInventory(HomeOperationsImpl.java:372) at oracle.glcm.opatch.common.api.install.HomeOperationsShell.saveInventory(HomeOperationsShell.java:204) at oracle.opatch.ipm.IPMRWServices.saveInstallInventory(IPMRWServices.java:854) at oracle.opatch.OPatchSession.restorePatchesInventory(OPatchSession.java:1434) at oracle.opatch.MergedPatchObject.restoreOH(MergedPatchObject.java:1234) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:1465) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:370) at oracle.opatch.opatchutil.NApply.process(NApply.java:352) at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1123) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at oracle.opatch.UtilSession.process(UtilSession.java:355) at oracle.opatch.OPatchSession.main(OPatchSession.java:3985) at oracle.opatch.OPatchSDK.NApply(OPatchSDK.java:1127) at oracle.opatch.opatchsdk.OPatchTarget.NApply(OPatchTarget.java:4169) at oracle.opatchauto.core.binary.action.LegacyPatchAction.execute(LegacyPatchAction.java:76) at oracle.opatchauto.core.binary.OPatchAutoBinary.patchWithoutAnalyze(OPatchAutoBinary.java:519) at oracle.opatchauto.core.binary.OPatchAutoBinary.applyWithoutAnalyze(OPatchAutoBinary.java:406) at oracle.opatchauto.core.OPatchAutoCore.runOPatchAutoBinary(OPatchAutoCore.java:192) at oracle.opatchauto.core.OPatchAutoCore.main(OPatchAutoCore.java:75) [Mar 13, 2020 3:54:57 PM] [SEVERE] OUI-67115:OPatch failed to restore OH '/u01/app/19.3.0/grid'. Consult OPatch document to restore the home manually before proceeding. [Mar 13, 2020 3:54:57 PM] [WARNING] OUI-67124: NApply was not able to restore the home. Please invoke the following scripts: - restore.[sh,bat] - make.txt (Unix only) to restore the ORACLE_HOME. They are located under "/u01/app/19.3.0/grid/.patch_storage/NApply/2020-03-13_15-52-41PM" [Mar 13, 2020 3:54:58 PM] [SEVERE] OUI-67073:UtilSession failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: Copy failed from '/tmp/30501910/30489227/files/bin/crsd.bin' to '/u01/app/19.3.0/grid/bin/crsd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/cssdagent' to '/u01/app/19.3.0/grid/bin/cssdagent'... Copy failed from '/tmp/30501910/30489227/files/bin/cssdmonitor' to '/u01/app/19.3.0/grid/bin/cssdmonitor'... Copy failed from '/tmp/30501910/30489227/files/bin/evmd.bin' to '/u01/app/19.3.0/grid/bin/evmd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/evmlogger.bin' to '/u01/app/19.3.0/grid/bin/evmlogger.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/gipcd.bin' to '/u01/app/19.3.0/grid/bin/gipcd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/gpnpd.bin' to '/u01/app/19.3.0/grid/bin/gpnpd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/mdnsd.bin' to '/u01/app/19.3.0/grid/bin/mdnsd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/ocssd.bin' to '/u01/app/19.3.0/grid/bin/ocssd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/octssd.bin' to '/u01/app/19.3.0/grid/bin/octssd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/ohasd.bin' to '/u01/app/19.3.0/grid/bin/ohasd.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/oraagent.bin' to '/u01/app/19.3.0/grid/bin/oraagent.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/orarootagent.bin' to '/u01/app/19.3.0/grid/bin/orarootagent.bin'... Copy failed from '/tmp/30501910/30489227/files/bin/osysmond.bin' to '/u01/app/19.3.0/grid/bin/osysmond.bin'... 4.2 解决方法

按日志提示,执行脚本:

[[email protected] 2020-03-13_15-52-41PM]# ls backup make.txt patchlist.txt restore.sh [[email protected] 2020-03-13_15-52-41PM]# ./restore.sh This script is going to restore the Oracle Home to the previous state. It does not perform any of the following: - Running init/pre/post scripts - Oracle binary re-link - Customized steps performed manually by user Please use this script with supervision from Oracle Technical Support. About to modify Oracle Home( /u01/app/19.3.0/grid ) Do you want to proceed? [Y/N] y User responded with : Y Restore script completed. [[email protected] 2020-03-13_15-52-41PM]# 4.3 分析过程1

因为之前不能copy文件都是crs的,所以在进行到RU 进行到停CRS时,我手工的执行了停CRS的操作:

[[email protected] 2020-03-13_16-45-11PM]# crsctl stop crs -f CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' CRS-2673: Attempting to stop 'ora.crsd' on 'rac1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rac1' CRS-2673: Attempting to stop 'ora.chad' on 'rac1' CRS-2673: Attempting to stop 'ora.cndba.db' on 'rac1' CRS-2677: Stop of 'ora.cndba.db' on 'rac1' succeeded CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'rac1' CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.MGMT.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1' CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded CRS-2677: Stop of 'ora.MGMT.dg' on 'rac1' succeeded CRS-2677: Stop of 'ora.OCR.dg' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1' CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' CRS-2677: Stop of 'ora.chad' on 'rac1' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'rac1' CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'rac1' succeeded CRS-33677: Stop of resource group 'ora.asmgroup' on server 'rac1' succeeded. CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2' CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac1' CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1' CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rac1' CRS-2673: Attempting to stop 'ora.crf' on 'rac1' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1' CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded CRS-2677: Stop of 'ora.storage' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1' CRS-2673: Attempting to stop 'ora.evmd' on 'rac1' CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac1' CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.driver.afd' on 'rac1' CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1' CRS-2677: Stop of 'ora.driver.afd' on 'rac1' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed CRS-4133: Oracle High Availability Services has been stopped. [[email protected] 2020-03-13_16-45-11PM]# 4.4 停完CRS之后,RU打成功 [[email protected] tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /tmp/30501910 OPatchauto session is initiated at Fri Mar 13 17:17:26 2020 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-13_05-17-50PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-13_05-20-03PM.log The id for this session is FPKL Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 Patch applicability verified successfully on home /u01/app/19.3.0/grid Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1 Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1 Successfully prepared home /u01/app/oracle/product/19.3.0/db_1 to bring down database service Bringing down CRS service on home /u01/app/19.3.0/grid CRS service brought down successfully on home /u01/app/19.3.0/grid 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 CRS service started successfully on home /u01/app/19.3.0/grid Preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted No step execution required......... OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac1 RAC Home:/u01/app/oracle/product/19.3.0/db_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /tmp/30501910/30489632 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /tmp/30501910/30655595 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /tmp/30501910/30489227 Reason: This patch is already been applied, so not going to apply again. Patch: /tmp/30501910/30557433 Reason: This patch is already been applied, so not going to apply again. Host:rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /tmp/30501910/30489227 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_17-23-27PM_1.log Patch: /tmp/30501910/30489632 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_17-23-27PM_1.log Patch: /tmp/30501910/30557433 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_17-23-27PM_1.log Patch: /tmp/30501910/30655595 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-13_17-23-27PM_1.log OPatchauto session completed at Fri Mar 13 17:45:20 2020 Time taken to complete the session 27 minutes, 56 seconds [[email protected] tmp]# 4.5 遗留问题

这种在打RU过程中手工停crs的方式可以让RU 打成功,但是会导致很多权限问题,CRS 无法启动:

[[email protected] lib]# crsctl start crs CRS-41053: checking Oracle Grid Infrastructure for file permission issues PRVG-2031 : Owner of file "/u01/app/grid/cfgtoollogs" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVH-0124 : Path "/etc/oracle/maps" with permissions "rwxr-xr-x" does not have write permissions for the file's group and others on node "rac1". PRVH-0100 : Restricted deletion flag is not set for path "/etc/oracle/maps" on node "rac1". PRVG-2031 : Owner of file "/u01/app/grid" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/admin" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVH-0111 : Path "/etc/init.d/ohasd" with permissions "rwxr-x---" does not have read permissions for others on node "rac1". PRVH-0113 : Path "/etc/init.d/ohasd" with permissions "rwxr-x---" does not have execute permissions for others on node "rac1". PRVG-2031 : Owner of file "/etc/oracleafd.conf" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2032 : Group of file "/etc/oracleafd.conf" did not match the expected value on node "rac1". [Expected = "oinstall(54321)" ; Found = "asmadmin(54329)"] PRVH-0124 : Path "/var/tmp/.oracle" with permissions "rwxr-xr-x" does not have write permissions for the file's group and others on node "rac1". PRVH-0100 : Restricted deletion flag is not set for path "/var/tmp/.oracle" on node "rac1". PRVG-2031 : Owner of file "/u01/app/grid/diag/ofm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/lsnrctl" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/netcman" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/audit" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/checkpoints" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/crsdata/rac1/olr/rac1_19.olr" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVH-0100 : Restricted deletion flag is not set for path "/u01/app/grid/crsdata/rac1/shm" on node "rac1". PRVG-2031 : Owner of file "/u01/app/grid/crsdata/rac1/shm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/crsdata/rac1/cvu" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/crsdata/rac1/olr" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/crsdata" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/crsdata/rac1/ocr" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/kfod" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/asmtool" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/crs" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/dps" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/em" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/diagtool" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/gsm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/ios" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/rdbms" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/apx" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/tnslsnr" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/asmcmd" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/clients" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/asm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/grid/diag/afdboot" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-11960 : Set user ID bit is not set for file "/u01/app/19.3.0/grid/bin/jssu" on node "rac1". PRVH-0147 : Set group ID bit is not set for file "/u01/app/19.3.0/grid/bin/extproc" on node "rac1". PRVG-11960 : Set user ID bit is not set for file "/u01/app/19.3.0/grid/bin/extjob" on node "rac1". PRVG-11960 : Set user ID bit is not set for file "/u01/app/19.3.0/grid/bin/oradism" on node "rac1". PRVG-11960 : Set user ID bit is not set for file "/u01/app/19.3.0/grid/bin/oracle" on node "rac1". PRVH-0147 : Set group ID bit is not set for file "/u01/app/19.3.0/grid/bin/oracle" on node "rac1". PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/HASLoad.pm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2032 : Group of file "/u01/app/19.3.0/grid/crs/install/cmdllroot.sh" did not match the expected value on node "rac1". [Expected = "oinstall(54321)" ; Found = "root(0)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/crsconfig_params.sbs" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/crsconvert.pm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/install_gi.excl" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/paramfile.crs" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/oracle-ohasd.service" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/oracle-ohasd.conf" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/installRemove.excl" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/install.incl" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/install.excl" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/inittab" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/crstfa.pm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/crsconvtoext.pm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/crsconfig_addparams.sbs" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/CLSR.pm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/dropdb.pl" did not match the expected value on node "rac1". [Expected = "root(0)|root(0)" ; Found = "grid(54322)"] PRVH-0109 : Path "/u01/app/19.3.0/grid/lib/libacfs19.so" with permissions "rwxr-xr-x" does not have write permissions for the file's group on node "rac1". PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/tfa_setup" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/roothas.sh" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/rootcrs.sh" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVH-0109 : Path "/u01/app/19.3.0/grid/crs/install/rhpdata" with permissions "rwxr-xr-x" does not have write permissions for the file's group on node "rac1". PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/rhpdata" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/post_gimr_ugdg.pl" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVG-2031 : Owner of file "/u01/app/19.3.0/grid/crs/install/perlhasgen.pm" did not match the expected value on node "rac1". [Expected = "root(0)" ; Found = "grid(54322)"] PRVH-0109 : Path "/u01/app/19.3.0/grid/lib/libedtn19.a" with permissions "rwxr-xr-x" does not have write permissions for the file's group on node "rac1". PRVH-0109 : Path "/u01/app/19.3.0/grid/lib/libskgxpcompat.so" with permissions "rwxr-xr-x" does not have write permissions for the file's group on node "rac1". CRS-4124: Oracle High Availability Services startup failed. CRS-4000: Command Start failed, or completed with errors. [[email protected] lib]#

根据错误提示逐个手工修改权限:

[[email protected] grid]# chown root:oinstall admin -R [[email protected] grid]# pwd /u01/app/grid [[email protected] grid]# chown root:oinstall * -R [[email protected] grid]# cd /u01/app/19.3.0/grid/crs/install/ [[email protected] install]# ll

Oracle 19c RAC PRVG-11960 : Set user ID bit is not set for file 解决方法https://www.cndba.cn/dave/article/4079

但最终还是按如下方法解决了CRS不能启动的问题:https://www.cndba.cn/dave/article/4081

Oracle 19c 升级19.6 RU 导致权限异常 gipcInternalConnectSync: failed sync request 解决方法https://www.cndba.cn/dave/article/4080

版权声明:本文为博主原创文章,未经博主允许不得转载。



【本文地址】


今日新闻


推荐新闻


    CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3