My Oracle Support Banner

Odd NMS Database Errors After Upgrading Hosts to Solaris 11.4 (Doc ID 2612988.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Utilities Network Management System - Version 1.9.0.2 and later
Oracle Network Management for Utilities - DMS - Version 1.9.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 1.9.0.4 version, NMS Infrastructure

Various services are failing to start

In one attempt. this error appeared in the MTService log:

09/26 09:52:06: 0x1,ctp=0x0000000100227458 **ERROR** DBS::query: while processing 'SELECT h_cls, h_idx, partition, primary_ptn FROM alternate_views WHERE h_cls not in ( 999, 998, 996, 995)  AND active in ('Y','A') '
Selection set not consistent with number of rows returned,
 found 0 rows in selection set, supposed to find 989798,
selection[0] = ''.

In another attempt, the MBService log shows this error:

10/22 13:27:04: 0x1,ctp=0x000000010023f208 **ERROR** DBS::query: while processing 'select h_cls, h_idx, partition, primary_ptn, l_cls,
l_idx from alternate_views where ( death_patch is NULL ) order by h_cls, h_idx, birth_patch'
Selection set not consistent with number of rows returned,
found 704354 rows in selection set, supposed to find 990912,
selection[0] = '                 H_CLS                  H_IDX              PARTITION            PRIMARY_PTN                  L_CLS
            L_IDX'.
10/22 13:27:05: 0x1,ctp=0x000000010023f208 **ERROR** Message:  CES-00106      location:  AlternateViewManager::load      severity:  E
    Database SQL error.  See DBService log for details.



There are no corresponding errors in the TCDBService logs or the MBDBService logs.

Changes

The machine hosting the Oracle Database was recently upgrade to Solaris 11.4

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
References


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