DBCleanup -fixAVTable Does not Fix Duplicate alternate_view Entries if Only a Single Set of Handles is Found
Last updated on NOVEMBER 15, 2017
Applies to:Oracle Utilities Network Management System - Version 184.108.40.206 to 220.127.116.11 [Release 1.10 to 1.12]
Oracle Network Management for Utilities - DMS - Version 18.104.22.168 to 22.214.171.124 [Release 1.10 to 1.12]
Information in this document applies to any platform.
The ALTERNATE_VIEWS database table has a duplicated entry, as shown by running this query:
H_CLS H_IDX PARTITION PRIMARY_PTN L_CLS L_IDX BIRTH BIRTH_PATCH DEATH DEATH_PATCH ACTIVE
424 738354 1201 1197 4001 1201 11/04/2015 19:45:27 365698 Y
424 738354 1201 1197 4001 1201 12/08/2015 14:38:37 368577 Y
Running "DBCleanup -fixAVTable" should cause the entry with the higher birth_patch to get deactivated, but due to this bug, DBCleanup does not change the ALTERNATE_VIEWS table.
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