Extremely Slow MBService Startup After Installing 1.12.0.3.22 or 2.3.0.0.1 (Doc ID 2224117.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 to 1.12.0.3 [Release 1.12]
Oracle Utilities Network Management System - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 1.12.0.3 [Release 1.12]
Oracle Network Management for Utilities - DMS - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

On : 1.12.0.3.22 or 2.3.0.01, MBService takes an extremely long time to initialize when the model has more than 200,000 primary views to load from a single table.
It spends an inordinate amount of time in AlternateViewManager::load().

..
01/09/17 14:02:20: 0x7fa4ecf65740,ctp=0x16338e8,"<MAIN-TASK>" MBService::initialize() starting.

..
01/09/17 14:02:20: 0x7fa4ecf65740,ctp=0x16338e8,"<MAIN-TASK>" AlternateViewManager::load()


Even after 15 minutes, there is no corresponding MBS-00203 entry in the log file, which would indicate that the alternate views had finished loading.

 
Add the counts from the following query to determine the count of primary views:
select 'network_components  '||count(1) from alternate_views a, network_components b where b.h_cls = a.h_cls and b.h_idx = a.h_idx and b.death is null and a.death is null union
select 'network_nodes  '||count(1) from alternate_views a, network_nodes b where b.h_cls = a.h_cls and b.h_idx = a.h_idx and b.death is null and a.death is null union
select 'object_instances  '||count(1) from alternate_views a, object_instances b where b.h_cls = a.h_cls and b.h_idx = a.h_idx and b.death is null and a.death is null;



MBService should start in a reasonable amount of time.

The issue can be reproduced at will with the following steps:
1. Start services.
2. Check the MBService log for "AlternateViewManager::load()" entries.

Changes

NMS was recently patched to 1.12.0.3.22 or 2.3.0.0.1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms