My Oracle Support Banner

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)

Last updated on JULY 01, 2021

Applies to:

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

Symptoms

Enterprise Manager (EM) 13c Cloud Control OMS upgrade to 13.5 hangs at repository database prerequisite checks and emprereq kit logs reported the following error:

/<temp_location>/OraInstall<timestamp>/emdbprereqs/<timestamp>/emprereqkit.log

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

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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