Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Enterprise Manager Grid Control - Error with database schema compare tool

edited May 3, 2013 4:53AM in Managing Databases using Enterprise Manager (MOSC) 3 commentsAnswered

On 11.1.0.1
The following error occured

Change Manager Back-end SQL Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: violation de contrainte unique (SYSMAN.MGMT_CM_COMPARISON_OBJECT_UC)
ORA-06512: à "SYSMAN.MGMT_CM", ligne 1962
ORA-06512: à ligne 1

When making a comparison between two schemas on two differents databases.

Not able to make comparison between two schemas on two differents databases.


Even after  Applying  patch 12318104 on top of 11.1.0.1 OMS home

The problem was solved doing the following:

installing  a version of software in production. This version is identical to the one installed in development. So customer is  having the same database schemas (tables indexes ..) in development and production.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center