Schema Comparison for 2 different database via OEM

Schema Comparison for 2 different database via OEM

Below steps for comparing multiple Schemas using OEM:

1.  In Cloud Control, Search the Database target and go to DB Home page, from the Schema menu click the Change Management and click the Schema Comparison as highlighted below

2.       On Next Window you can see the Schema Comparison Window, from here you can click the create button as highlighted below.

3.       On Next Window we need to give the comparison name, database name for left Source database as below window and click Next.

(Note: Have Schema password or sys password for the database, while adding database to job, it will ask password for authentication)

4.       On Next Window we need to give the database name for the Right Source and click next.

5.       On Next Window select the object type which we need to compare and select non-objects like grants and role if we need to compare, and select the Multiple Schemas that we need to compare, and Click Next to proceed.

6.       On Next Window you can check or uncheck the option which you need to add for this comparison, this window is optional and we can leave as it is default and we can proceed further by clicking Next.

7.       On Next Window we need to provide the credentials for the both database to start the comparison job.

8.       And also you can schedule this job at any time or immediately and we can enable the email notification with job results once it is completed successfully and click Next to proceed further.

9.       On Next Window you can review all the details and submit the job to start the comparison.

10.   Once you submit the job, you will get the confirmation like below.

11.   And also you can monitor the job by clicking the View job details.

11a. Once job completed successfully you can get the mail like below

12.   You can view the job details in the same schema Comparison page at any time.

13.   Below are the Schema Comparison result windows from OEM