My Oracle Support Banner

OUA And NMS 2.5: Which Schema Name To Use On "Source DB Connection Details"? (Doc ID 2860836.1)

Last updated on APRIL 05, 2022

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.2.0 and later
Information in this document applies to any platform.

Goal

On : 2.7.0.2.0 version, Install / Upgrade


Before NMS 2,5, there is only one database source schema like NMS hosting all NMS tables.In NMS 2.5, it support multi sites. Each site has its own schema like NMS_1 without any NMS tables/views but synonyms accessing the NMS administration schema like NMS_ADMIN, which host all NMS tables and views.In NMS_ADMIN, certain tables have table_name_1, table_name_2 etc. The number _1 or _2 represents site numbers.

When I configure OUA source with config.sh, what source schema name I should use? In the above example, NMS_ADMIN or NMS_1?
 

Solution

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
Goal
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.