Saturday, November 11, 2023

Proceeding Failed oPatchauto

/grid/12.1.0/asm/product/OPatch/opatchauto apply /mnt/PATCH_STAGE/CPU_OCT18/GI_DB/28689148/28349311 -analyze
/grid/12.1.0/asm/product/OPatch/opatchauto apply /mnt/PATCH_STAGE/CPU_OCT18/GI_DB/28689148/28349311

[Oct 26, 2019 5:14:55 PM] [INFO]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 28259914
[Oct 26, 2019 5:14:55 PM] [INFO]    Patch 28259914:
                                    Copy Action: Destination File "/grid/12.1.0/asm/product/bin/orarootagent.bin" is not writeable.
                                    'oracle.crs, 12.1.0.2.0': Cannot copy file from 'orarootagent.bin' to '/grid/12.1.0/asm/product/bin/orarootagent.bin'
[Oct 26, 2019 5:14:55 PM] [INFO]    Prerequisite check "CheckApplicable" failed.
                                    The details are:

                                    Patch 28259914:
                                    Copy Action: Destination File "/grid/12.1.0/asm/product/bin/orarootagent.bin" is not writeable.
                                    'oracle.crs, 12.1.0.2.0': Cannot copy file from 'orarootagent.bin' to '/grid/12.1.0/asm/product/bin/orarootagent.bin'
[Oct 26, 2019 5:14:55 PM] [SEVERE]  OUI-67073:UtilSession failed:
                                    Prerequisite check "CheckApplicable" failed.
[Oct 26, 2019 5:14:55 PM] [INFO]    --------------------------------------------------------------------------------


Update /grid/12.1.0/asm/product/OPatch/auto/dbsessioninfo/localSessionInfoFile_inhyduvpodb002.txt info for the session ID
346     /grid/12.1.0/asm/product/OPatch/opatchauto apply /mnt/PATCH_STAGE/CPU_OCT18/GI_DB/28689148/28349311 -oh /grid/12.1.0/asm/product
349     /grid/12.1.0/asm/product/OPatch/opatchauto apply /mnt/PATCH_STAGE/CPU_OCT18/GI_DB/28689148/28349311 -oh /grid/12.1.0/asm/product -norestart
351     fuser /grid/12.1.0/asm/product/bin/orarootagent.bin
/grid/12.1.0/asm/product/OPatch/opatchauto apply /mnt/PATCH_STAGE/CPU_OCT18/GI_DB/28689148/28349311 -oh /grid/12.1.0/asm/product resume
/grid/12.1.0/asm/product/OPatch/opatchauto resume
/grid/12.1.0/asm/product/bin/crsctl start crs

>  CRS-6706: Oracle Clusterware Release patch level ('392601041') does not match Software patch level ('1505651481'). Oracle Clusterware cannot be started.
>  CRS-4000: Command Start failed, or completed with errors.

/grid/12.1.0/asm/product/OPatch/opatchauto -session MD2E
/grid/12.1.0/asm/product/OPatch/opatchauto resume -session MD2E
cd /grid/12.1.0/asm/product/OPatch/auto/dbsessioninfo
kill -9 19529878

cp -p localSessionInfoFile_inhyduvpodb002.txt localSessionInfoFile_inhyduvpodb002.txt.old
vi localSessionInfoFile_inhyduvpodb002.txt
/grid/12.1.0/asm/product/OPatch/opatchauto resume

2019-10-26 18:36:43,184 INFO  [1] com.oracle.glcm.patch.auto.db.framework.core.patch.PatchMetadaReader - Reading session result from /grid/12.1.0/asm/product/OPatch/auto/dbtmp/result.ser
2019-10-26 18:36:43,220 INFO  [1] com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation - CRS Type is detected to be CRS
2019-10-26 18:36:43,220 INFO  [1] com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation - Checking the CRS status and session state across the entire cluster
2019-10-26 18:36:43,220 INFO  [1] com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation - Size of the host list is : 2
2019-10-26 18:36:43,247 INFO  [1] com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation - Credential not found for user grid on inhyduvpodb002
2019-10-26 18:36:43,247 INFO  [1] com.oracle.glcm.patch.auto.db.product.validation.validators.RemoteGIStatusValidation - Grid is a single node cluster installation
2019-10-26 18:36:43,250 INFO  [1] com.oracle.glcm.patch.auto.db.product.validation.DBValidationController - Validation failed due to :OPATCHAUTO-72141: Grid patching cannot be performed in rolling


OPATCHAUTO-72141: Grid is installed only on a single node.
OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.
2019-10-26 18:36:43,254 INFO  [1] com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport - Space available after session: 66732 MB
2019-10-26 18:36:43,475 SEVERE [1] com.oracle.glcm.patch.auto.OPatchAuto - OPatchAuto failed.
com.oracle.glcm.patch.auto.OPatchAutoException: OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode.
OPATCHAUTO-72141: Grid is installed only on a single node.
OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.
        at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.AbstractTopologyBuilder.buildTopology(AbstractTopologyBuilder.java:121)
        at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.CRSTopologyBuilder.buildTopology(CRSTopologyBuilder.java:112)
        at com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport.loadTopology(DBBaseProductSupport.java:192)
        at com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBProductSupport.loadTopology(DBProductSupport.java:69)
        at com.oracle.glcm.patch.auto.OPatchAuto.loadTopology(OPatchAuto.java:1732)
        at com.oracle.glcm.patch.auto.OPatchAuto.prepareOrchestration(OPatchAuto.java:730)
        at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:397)
        at com.oracle.glcm.patch.auto.OPatchAuto.orchestrate(OPatchAuto.java:344)
        at com.oracle.glcm.patch.auto.OPatchAuto.main(OPatchAuto.java:212)
2019-10-26 18:36:43,476 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='OPATCHAUTO-72141: Grid patching cannot be performed in
 rolling mode.
OPATCHAUTO-72141: Grid is installed only on a single node.
OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.'}
2019-10-26 18:36:43,477 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='OPatchAuto failed.'}
 cp -p MD2E.json MD2E.json.bkp
vi MD2E.json

      "key" : "nonrolling",
      "value" : "true"
/grid/12.1.0/asm/product/OPatch/opatchauto resume

2019-10-26 18:54:44,527 SEVERE [344] com.oracle.glcm.patch.auto.action.PatchActionExecutor - Failed to execute patch action [com.oracle.glcm.patch.auto.db.integration.controller.action.crs.GIStartu
pAction] on patch target [inhyduvpodb002->/grid/12.1.0/asm/product Type[crs]].
2019-10-26 18:54:44,527 INFO  [344] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='Execution of [GIStartupAction] patch action failed,
check log for more details. Failures:
Patch Target : inhyduvpodb002->/grid/12.1.0/asm/product Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /grid/12.1.0/asm/product, host: inhyduvpodb002.
Command failed:  /grid/12.1.0/asm/product/perl/bin/perl -I/grid/12.1.0/asm/product/perl/lib -I/grid/12.1.0/asm/product/OPatch/auto/dbtmp/bootstrap_inhyduvpodb002/patchwork/crs/install /grid/12.1.0/
asm/product/OPatch/auto/dbtmp/bootstrap_inhyduvpodb002/patchwork/crs/install/rootcrs.pl -postpatch -nonrolling
Command failure output:
Using configuration parameter file: /grid/12.1.0/asm/product/OPatch/auto/dbtmp/bootstrap_inhyduvpodb002/patchwork/crs/install/crsconfig_params

After fixing the cause of failure Run opatchauto resume

]'}
2019-10-26 18:54:44,530 SEVERE [59] 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 startup:startup
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:785)
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.crs.GIStartupAction
Patch Target : inhyduvpodb002->/grid/12.1.0/asm/product Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /grid/12.1.0/asm/product, host: inhyduvpodb002.
Command failed:  /grid/12.1.0/asm/product/perl/bin/perl -I/grid/12.1.0/asm/product/perl/lib -I/grid/12.1.0/asm/product/OPatch/auto/dbtmp/bootstrap_inhyduvpodb002/patchwork/crs/install /grid/12.1.0/
asm/product/OPatch/auto/dbtmp/bootstrap_inhyduvpodb002/patchwork/crs/install/rootcrs.pl -postpatch -nonrolling
Command failure output:
Using configuration parameter file: /grid/12.1.0/asm/product/OPatch/auto/dbtmp/bootstrap_inhyduvpodb002/patchwork/crs/install/crsconfig_params

After fixing the cause of failure Run opatchauto resume

/grid/12.1.0/asm/product/OPatch/opatchauto resume
/grid/12.1.0/asm/product/bin/crsctl start crs
/grid/12.1.0/asm/product/bin/kfod op=patches
/grid/12.1.0/asm/product/bin/kfod.bin op=patchlvl
/grid/12.1.0/asm/product/OPatch/opatchauto resume
cd /grid/12.1.0/asm/product/OPatch/auto/dbsessioninfo
vi MD2E.json
/grid/12.1.0/asm/product/OPatch/opatchauto resume
/grid/12.1.0/asm/product/crs/install/rootcrs.sh -patch

root@inhyduvpodb002(/)# /grid/12.1.0/asm/product/bin/crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2505363275].
root@inhyduvpodb001(/)# /grid/12.1.0/asm/product/bin/crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2505363275].

root@inhyduvpodb002(/grid/12.1.0/asm/product/cfgtoollogs/opatchauto)# /grid/12.1.0/asm/product/bin/crsctl query crs softwarepatch
Oracle Clusterware patch level on node inhyduvpodb002 is [2505363275].