Patch Reviews - ENM (MOSC)

MOSC Banner

Patch 30029041: enterprise manager for oms plugins 13.2.2.0.190731 / Error while applying SQL Patche

edited Sep 18, 2019 8:00AM in Patch Reviews - ENM (MOSC) 1 commentAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center