Patch 30029041: enterprise manager for oms plugins 13.2.2.0.190731 / Error while applying SQL Patche
Hi,
Oracle Linux 7.6, EMCC 13.2.2.0,
while applying the actual OMS Systempatch following error occurs while patching the DB pluggin:
from logs:
While omspatching with latest oms systempatch the following SQL from file /u02/software/middleware/plugins/oracle.sysman.db.oms.plugin_13.2.2.0.0/sql/db/13.2.2.0/rec/ha_rec_rw_metric.sql fails.
ORA-20233: ORA-01422: Exakter Abruf gibt mehr als die angeforderte Zeilenzahl zurück when modifying default collections
ORA-06512: in "SYSMAN.MGMT_COLLECTION", Zeile 1068
ORA-06512: in "SYSMAN.MGMT_COLLECTION", Zeile 1375
ORA-06512: in "SYSMAN.MGMT_COLLECTION", Zeile 1005
ORA-06512: in "SYSMAN.MGMT_COLLECTION", Zeile 111
From analyzing
/u02/software/middleware/plugins/oracle.sysman.db.oms.plugin_13.2.2.0.0/sql/db/13.2.2.0/rec/ha_rec_rw_metric.sql