EM 13c: Fleet UPDATE_RACDB job fails with error "Unable to retreive destination home location: ORA-01427: single-row subquery returns more than one row"
(Doc ID 2811157.1)
Last updated on JULY 20, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.3.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control, when applying patch using Fleet Update RAC database job failed with "ORA-01427: single-row subquery returns more than one row".
$ emcli db_software_maintenance -performOperation -name=12.2.0.1.210420 -purpose=UPDATE_RACDB -target_type=rac_database -target_list="<RAC_DB_NAME>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ORACLE_SUDO:SYSMAN" -dataguard_role=primary -rolling=true
Processing target "<RAC_DB_NAME>"...
Error occurred. Check the OMS log for details
Verb performOperation unsuccessful
/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc
2021-09-19 02:38:23,812 [emcli-work-manager:emcli-request] ERROR verbs.MigrateDBToGoldImageVerb logp.251 - Unable to retreive destination home location: ORA-01427: single-row subquery returns more than one row
2021-09-19 02:38:23,814 [emcli-work-manager:emcli-request] ERROR verbs.GIMangerVerb logp.251 - Error occurred
Unable to retreive destination home location: ORA-01427: single-row subquery returns more than one row
Processing target "<RAC_DB_NAME>"...
Error occurred. Check the OMS log for details
Verb performOperation unsuccessful
/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc
2021-09-19 02:38:23,812 [emcli-work-manager:emcli-request] ERROR verbs.MigrateDBToGoldImageVerb logp.251 - Unable to retreive destination home location: ORA-01427: single-row subquery returns more than one row
2021-09-19 02:38:23,814 [emcli-work-manager:emcli-request] ERROR verbs.GIMangerVerb logp.251 - Error occurred
Unable to retreive destination home location: ORA-01427: single-row subquery returns more than one row
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 |