My Oracle Support Banner

EM 13c: OMS RU patching fails with error ORA-01422: exact fetch returns more than requested number of rows (Doc ID 3007240.1)

Last updated on MARCH 18, 2024

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


While applying the RU patch on OMS failed with the below error.

"omspatcher apply" standard output:

Updating repository with RCU reference file "<OMS_HOME>/.omspatcher_storage/35854889_Dec_26_2023_03_38_24/original_patch" for plugin home "<OMS_HOME>/plugins/oracle.sysman.db.oms.plugin_13."

Some error occurred during RCU update. Please refer individual log file(s) for details.
Log file location: <OMS_HOME>/cfgtoollogs/omspatcher/2024-02-11_12-25-58PM_SystemPatch_35861059_21/rcu_applypatch_original_patch_2024-02-11_12-36-34PM.log



OMSPatcher failed to execute some of the patching steps. Please check the Patching summary,individual logs and try to resolve the issue. Once the issue is resolved,Please execute below command to complete patching session:
omspatcher resume

OMSPatcher wont allow any other patching operations unless the script is executed successfully

Log file location: <OMS_HOME><oms_home>/cfgtoollogs/omspatcher/35861059/omspatcher_2024-02-11_11-46-30AM_apply.log

Recommended actions: Please check log file(s) for failed RCU artifact action(s) and contact Oracle Support with the logs.

OMSPatcher failed with error code 245


Repository ApplyRepositoryPatch in progress.
Executing pre create operations
Percent Complete: 55
Percent Complete: 58
Percent Complete: 61
Percent Complete: 64
Percent Complete: 67
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 27



-- get WH db info from repos
sql_txt := 'select target_guid, db_cred_guid, host_cred_guid from db_caw_repos';
execute immediate sql_txt into l_tgt_guid, l_db_cred_guid, l_host_cred_guid;
when NO_DATA_FOUND then
dbms_output.put_line('AWR Warehouse not configured. Nothing to upgrade.');


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.