RE: Database Comparison

Hi Boivin and Fellow Listers,
I have been using Oracle change manager to compare the two diff databases and 2 diff schemas for quite some time. Basically I use it compare prodcution and development and test databases/schema.The initial setup is little bit tedious. First a repository has to be created in a seperate machine, and then using the discovery wizard we have to discover the nodes. We must make sure that Oracle agent is up and running in the target m/c. After that we have to launch the console and to be frank with you I have not got into the small details of display, but I feel this tool is quite easier.

The major hurdle I faced is when applying the changes of one schema to another. Change manager will generate the change scripts, this is generated in TCL/TK. So one must be familiar with these also. Also if any errors are encountered this scripts halts and also this script deletes any data and referential integrity constraints.

So I generate the required reports and do the changes manually either in SQL*Plus. I also keep a log while doing the changes.

Best Regards
Venkat

--

On Thu, 10 Jan 2002 05:25:21  
 Boivin, Patrice J wrote:


>I've had some problems with the Change Manager.

>

>For some databases it doesn't "see" any of the objects that would fall in

>the last few item categories in the navigator pane on the left - including

>tablespaces.

>

>There is a bug with the JVM, sometimes the Oracle Java tool colours go

>beserk (fluorescent) and in one occation the window positioning was

>completely off.  I use 1024x768 desktops on some NT servers.  Sometimes the

>whole graphic column that shows checkmarks or crosses in comparison reports

>appears in the upper left corner of the screen instead of where it should

>be.  These are probably all related to the same "known bug" for the JVM

>display functions.

>

>The reports also are extensive, I don't know if it is possible to tell

>Change Manager to only put in reports just the information you want.

>Internet browsers are not happy with HTML files that are megabytes in size,

>they take a long time to load.

>

>The Change Manager is faster if run on the console holding the repository

>than from a remote client. I recommend running it from the OEM repository

>console if at all possible, to avoid network trips as the Change Manager

>stores information into the repository.  There will be enough networking

>going on with it comparing two remote systems.

>

>Would anyone care to share tips on how to use Change Manager appropriately?

>Did you find any problems with Change Manager, are there any differences it

>did not catch?

>

>Regards,

>Patrice Boivin

>Systems Analyst (Oracle Certified DBA)

>

>Systems Admin & Operations | Admin. et Exploit. des systèmes

>Technology Services        | Services technologiques

>Informatics Branch         | Direction de l'informatique 

>Maritimes Region, DFO      | Région des Maritimes, MPO

>

>E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

>

>

> -----Original Message-----

>Sent:  Thursday, January 10, 2002 1:20 AM

>To:    Multiple recipients of list ORACLE-L

>Subject:       Re: Database Comparison

>

> Srini,

>Use the change manager that comes with Oracle Enterprise manager. The

>initial set-up is little bit difficult. But once u r through, then it is an

>handy tool.

>Venkat

>--

>-- 

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>-- 

>Author: Boivin, Patrice J

>  INET: BoivinP_at_mar.dfo-mpo.gc.ca

>

>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

>San Diego, California        -- Public Internet access / Mailing Lists

>--------------------------------------------------------------------

>To REMOVE yourself from this mailing list, send an E-Mail message

>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

>the message BODY, include a line containing: UNSUB ORACLE-L

>(or the name of mailing list you want to be removed from).  You may

>also send the HELP command for other information (like subscribing).

>



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: csvenkata_at_lycos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).