ODA:DB Home Pre-patch Failed with PRCC-1000 : Parameter RHPHELPERUtil-queryIfDataGuard-oracleSID value is not valid (Doc ID 2910285.1)

# odacli describe-prepatchreport -i 75a9ce55-96a1-4918-a0c7-c6ff56b9315a

Patch pre-check report
------------------------------------------------------------------------
Job ID: 75a9ce55-96a1-4918-a0c7-c6ff56b9315a
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home23
Status: FAILED
Created: November 10, 2022 4:50:42 AM CST
Result: One or more pre-checks failed for [ORACHK, DB]

Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
a29e8f86-322a-4c4d-a183-59b40cb24ce3
Validate patching tag Success Validated patching tag: 19.15.0.0.0.
Is system provisioned Success Verified system is provisioned
Validate minimum agent version Success Validated minimum agent version
Is GI upgraded Success Validated GI is upgraded
Validate available space for Success Validated free space required under
db /u01/app/odaorahome
Validate dbHomesOnACFS Success User has configured diskgroup for
configured Database homes on ACFS
Validate Oracle base Success Successfully validated Oracle Base
Is DB clone available Success Successfully validated clone file
exists
Evaluate DBHome patching with Failed Internal error encountered: PRCC-1000
RHP : Parameter
Validate command execution Success Validated command execution

22-11-10 05:05:57,084 DEBUG [Run patching pre-checks for component: DB : JobId=75a9ce55-96a1-4918-a0c7-c6ff56b9315a] [] c.o.d.a.s.p.PatchPreCheckJobStatusListener: end precheck task listener process
2022-11-10 05:05:57,084 DEBUG [Run patching pre-checks for component: DB : JobId=75a9ce55-96a1-4918-a0c7-c6ff56b9315a] [] c.o.d.c.t.r.ServiceJobReport: process TaskDetail this.jobid= 75a9ce55-96a1-4918-a0c7-c6ff56b9315a d.jobid=75a9ce55-96a1-4918-a0c7-c6ff56b9315a d.taskid=TaskZJsonRpcExt_776 this.msg=Use 'odacli describe-prepatchreport -i <ID>' to check prepatch results d.res=
PatchPreCheckReportDb {
id: 1668077453491
jobId: 75a9ce55-96a1-4918-a0c7-c6ff56b9315a
nodeId: node_0
comments: Internal error encountered: PRCC-1000 : Parameter RHPHELPERUtil-queryIfDataGuard-oracleSID value is not valid
patchPreCheckTaskId: 1635334201641
agentVersion: 19.15.0.0.0
targetVersion: 19.15.0.0.0
DB home ID: a29e8f86-322a-4c4d-a183-59b40cb24ce3
} d.subtasks.isempty=true d.status=Success
2022-11-10 05:05:57,085 DEBUG [Run patching pre-checks for com

[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.223 CST ] [RHPHELPERUtil.getRunningInstances:5510] output : <DB_NODES></DB_NODES><DB_INSTANCES></DB_INSTANCES>
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.223 CST ] [RHPHELPERUtil.getValue:6963] retrieving value enclosed by <DB_NODES> and </DB_NODES> ...
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.223 CST ] [RHPHELPERUtil.getValue:6970] retrieved value :
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.223 CST ] [RHPHELPERUtil.getValue:6963] retrieving value enclosed by <DB_INSTANCES> and </DB_INSTANCES> ...
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.223 CST ] [RHPHELPERUtil.getValue:6970] retrieved value :
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.223 CST ] [RHPHELPERUtil.getRunningInstances:5525] returning : {}
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.224 CST ] [DBPatchUpgradeOperationImpl.determineIsDataGuard:8527] Retrieved sid : null and node :<nodename>
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.224 CST ] [Utils.assertInput:470] Exception thrown because RHPHELPERUtil-queryIfDataGuard-oracleSID was null or empty.
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.227 CST ] [DBPatchUpgradeOperationImpl.determineIsDataGuard:8546] Failed to determine the database role oracle.cluster.common.InvalidArgsException : PRCC-1000 : Parameter RHPHELPERUtil-queryIfDataGuard-oracleSID value is not valid
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.227 CST ] [DBPatchUpgradeOperationImpl.move:489] attempt to move or upgrade database failed with OperationException : PRCC-1000 : Parameter RHPHELPERUtil-queryIfDataGuard-oracleSID value is not valid
[UID:1432960377] [Precheck Patch databases by RHP] [ 2022-11-10 05:05:56.227 CST ] [DatabaseOperationImpl.move:1448] OperationException: PRCC-1000 : Parameter RHPHELPERUtil-queryIfDataGuard-oracleSID value is not valid

example:

[root@<nodename>~]# ps -ef | grep pmon
grid 45476 1 0 Nov10 ? 00:00:20 asm_pmon_+ASM1
grid 50152 1 0 Nov10 ? 00:00:18 apx_pmon_+APX1
oracle 67487 1 0 Nov10 ? 00:00:20 ora_pmon_db1
oracle 67610 1 0 Nov10 ? 00:00:20 ora_pmon_db2
oracle 68305 1 0 Nov10 ? 00:00:24 ora_pmon_db3
oracle 68324 1 0 Nov10 ? 00:00:24 ora_pmon_db4
oracle 68356 1 0 Nov10 ? 00:00:24 ora_pmon_db5
root 98356 98047 0 04:11 pts/1 00:00:00 grep --color=auto pmon

[root@<nodename> ~]# odacli list-databases

ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
e07d9f34-3e37-43db-80d4-0d5e69557cf3 db3 RAC 19.14.0.0.220118 false OLTP odb1 ASM CONFIGURED a29e8f86-322a-4c4d-a183-59b40cb24ce3
a8f9ffb0-5cc6-4a47-b070-e438afa7e26c db5 RAC 19.14.0.0.220118 false OLTP odb1 ASM CONFIGURED a29e8f86-322a-4c4d-a183-59b40cb24ce3
05ced6df-6e5e-4e91-8439-5fd867b60d93 db4 RAC 19.14.0.0.220118 false OLTP odb1 ASM CONFIGURED a29e8f86-322a-4c4d-a183-59b40cb24ce3
f514518a-0631-42b8-8b38-5d66ee26aea8 db6 RAC 19.14.0.0.220118 true OLTP odb1 ACFS CONFIGURED a29e8f86-322a-4c4d-a183-59b40cb24ce3  ◄▬▬
91862063-c8ea-48a7-80d1-967a6c2a9030 db2 RAC 19.14.0.0.220118 true OLTP odb1 ASM CONFIGURED a29e8f86-322a-4c4d-a183-59b40cb24ce3
96c1d7f6-9354-4c4c-b71a-ecd37822673e db1 RAC 19.14.0.0.220118 true OLTP odb1 ASM CONFIGURED a29e8f86-322a-4c4d-a183-59b40cb24ce3