My Oracle Support Banner

OEM 13c: Fleet UPDATE_RACDB Job On Standby DB Fails With Error "Could not verify status of the standby database: Exception occurred while fetching open_mode for the DB instance" (Doc ID 3026402.1)

Last updated on MAY 31, 2024

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When you are attempting to execute the UPDATE_RACDB Command it fails with error on standby DB "Could not verify status of the standby database: Exception occurred while fetching open_mode for the DB instance"

Command Snippet:

$ emcli db_software_maintenance -performOperation -name="Update RAC DB" -purpose=UPDATE_RACDB -target_type=rac_database -target_list="<TARGET_NAME>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"

Check Passed.

Checking image subscription...

Check image subscription passed.

Operation 'Update RAC DB' created successfully.

Update operation for cluster target xxxx can be monitored using:

EMCLI:

emcli get_instance_status -exec=8B36DB09FF1E2058E0537C28410A5041 -details -xml

Browser:

https://<EM Host>:<EM Port>/em/faces/core-jobs-procedureExecutionTracking?executionGUID=8B36DB09FF1E2058E0537C28410A5041

Verb performOperation completed successfully

[oracle@oms bin]$

Job Steps Log for Job :Open TDE wallet for database target

1:Evaluate expression:evaluateExpression

Target Name: orcl.oracle.com
Target type: rac_database
Dataguard role: standbyExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
Could not verify status of the standby database: Exception occurred while fetching open_mode for the DB instance 'orcl.oracle.com_orcl1'
null
Manually open wallet.

----------------------------------------------------------
Could not verify status of the standby database: Exception occurred while fetching open_mode for the DB instance 'orcl.oracle.com_orcl1'
null
Manually open wallet.
------------------------------------

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.