My Oracle Support Banner

Migrating CES_CUSTOMER_A/B Tables As Part of an Upgrade to 2.5+ (Doc ID 2798917.1)

Last updated on SEPTEMBER 19, 2022

Applies to:

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

Symptoms

On : 2.5.0.0.0 version, Installation

In 2.5, only the NMS admin database user has direct access to the tables, the NMS_READ_WRITE_USER and NMS_READ_ONLY_USER access the data via synonyms to the tables and views.

When attempting to upgrade from 2.4.0.1 to 2.5.0.1, there were several tables that did not have an automated migration path.


These errors appeared in the setup log after "nms-setup" was run:

ISQL loading [NMS_HOME]/sql/nms_schema_callentry.sql

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 26 12:31:59 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

FROM incidents i, incident_change_log icl, ces_customers_1 cc
                                           *
ERROR at line 7:
ORA-00980: synonym translation is no longer valid


This caused cascading errors later in the setup.



Synonym created.

grant select on wce_incidents_1 to ces_rw
                *
ERROR at line 1:
ORA-04063: view "NMS_PROD.WCE_INCIDENTS_1" has errors


grant select on wce_incidents_1 to ces_ro
                *
ERROR at line 1:
ORA-04063: view "NMS_PROD.WCE_INCIDENTS_1" has errors


Changes

 Attempting to upgrade an NMS 2.4.0.1 database to 2.5.0.1.2

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.