EM 13c: Enterprise Manager Cloud Control OMS Upgrade to 13.5 Hangs at Repository Database Prerequisite, Prereqkit Logs Reports Error: SEVERE: ORA-01476: divisor is equal to zero (Doc ID 2781225.1)

May 28, 2021 12:50:34 AM oracle.sysman.emdrep.emprereqkit.logger.EMPrereqKitLogger logDebug
FINE: executing Action: SELECT
CASE
WHEN (r.rowcount / (c.cpucount)/6000000 * i.noindex ) >
(SELECT nvl(MIN(to_number(parameter_value)),10) FROM SYSMAN.mgmt_parameters WHERE parameter_name = 'max_metric_item_index_time')
THEN 1
ELSE 0
END case
FROM
  -- returns the max amount of parallel we can have.
  -- we use 1/2 by default
  (SELECT MIN(value) cpucount
  FROM
  (SELECT decode(floor(to_number(value)*.5),0,1,to_number(value)*.5) value
  FROM v$parameter
  WHERE name = 'cpu_count'
  UNION
  SELECT to_number(value) FROM v$parameter WHERE name = 'parallel_max_servers'
  UNION
  SELECT to_number(DECODE(VALUE,'CPU',
  (SELECT VALUE FROM v$parameter WHERE NAME = 'cpu_count'
  )))
  FROM v$parameter
  WHERE NAME = 'parallel_degree_limit'
  )
  ) c,
  -- Returns rowcount of metric items e
  (SELECT num_rows AS rowcount
  FROM all_tables
  WHERE table_name = 'EM_METRIC_ITEMS_E'
  AND owner = 'SYSMAN'
  ) r,
  -- returns value of 1 if not index, zero if index exists or short creation time
  (SELECT DECODE(COUNT(*),0,1,0) noindex
  FROM all_indexes
  WHERE table_name = 'EM_METRIC_ITEMS_E'
  AND index_name = 'EM_METRIC_ITEMS_KEY_IDX01'
  AND owner = 'SYSMAN'
  ) i
May 28, 2021 12:50:34 AM oracle.sysman.emdrep.emprereqkit.logger.EMPrereqKitLogger log
INFO: Using an existing DB connection...
May 28, 2021 12:50:34 AM oracle.sysman.emdrep.emprereqkit.logger.EMPrereqKitLogger logError
SEVERE: SQL exception : createstatement()
May 28, 2021 12:50:34 AM oracle.sysman.emdrep.emprereqkit.logger.EMPrereqKitLogger logError
SEVERE: ORA-01476: divisor is equal to zero

May 28, 2021 12:50:34 AM oracle.sysman.emdrep.emprereqkit.logger.EMPrereqKitLogger logError
SEVERE: InvocationTargetException in Command Executor
May 28, 2021 12:50:34 AM oracle.sysman.emdrep.emprereqkit.logger.EMPrereqKitLogger logError
SEVERE: Following exception occured in EMPrereqKit