My Oracle Support Banner

13c: Fleet Update GI Job Failed With "ORA-01427: Single-row Subquery Returns More Than One Row" (Doc ID 2719778.1)

Last updated on JULY 13, 2021

Applies to:

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


In Enterprise Manager (EM) Cloud Control, When applying patch using Fleet Update GI job failed with "ORA-01427: single-row subquery returns more than one row"

$ emcli db_software_maintenance -performOperation -name="Update Cluster" -purpose=UPDATE_GI -target_type=cluster -target_list="<cluster name>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ORACLE_SUDO:SYSMAN"

Job Initialize Patch DB Deployment Procedure Step log

ExpressionEvaluationException: Below error message was returned while
executing this Computational step.
Error occured in the execute funtions. Check OMS logs
for detailsUnable to retreive destination home location: ORA-01427: single-row subquery returns more than one row





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

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