RE: Database Comparison
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: [EMAIL PROTECTED] -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Database Comparison
There is a site on the 'net somewhere that inventories who is using what OS and Web server for major Web sites, but I can't remember what the URL for that is. It only reflects what they are using to serve pages to the Web, though. 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: [EMAIL PROTECTED] -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 -- On Wed, 09 Jan 2002 11:00:36 Paul Baumgartel wrote: There's a very good script available at http://www.dbspecialists.com. --- [EMAIL PROTECTED] wrote: Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Database Comparison
www.netcraft.com Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, January 10, 2002 8:40 AM To: Multiple recipients of list ORACLE-L There is a site on the 'net somewhere that inventories who is using what OS and Web server for major Web sites, but I can't remember what the URL for that is. It only reflects what they are using to serve pages to the Web, though. *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Database Comparison
Srini, But be careful - the Change Management pack for OEM is a purchaseable option. It is not free. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 09, 2002 11:20 PM To: Multiple recipients of list ORACLE-L 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 -- On Wed, 09 Jan 2002 11:00:36 Paul Baumgartel wrote: There's a very good script available at http://www.dbspecialists.com. --- [EMAIL PROTECTED] wrote: Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Database Comparison
Srini, I would suggest going to http://www.toadsoft.com and downloading the freeware version in order to use the Schema Compare tool. All it would require would be a database link between your Production DB and your QA DB, or vice-versa. It will show you all object differences. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 09, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Database Comparison
Srini I agree with James. Free tool does a pretty good job. I question it's report of db triggers and views, though. Doesn't seem to be right - it always reports them out of sync for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 09, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Srini, I would suggest going to http://www.toadsoft.com and downloading the freeware version in order to use the Schema Compare tool. All it would require would be a database link between your Production DB and your QA DB, or vice-versa. It will show you all object differences. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 09, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Database Comparison
There's a very good script available at http://www.dbspecialists.com. --- [EMAIL PROTECTED] wrote: Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 -- On Wed, 09 Jan 2002 11:00:36 Paul Baumgartel wrote: There's a very good script available at http://www.dbspecialists.com. --- [EMAIL PROTECTED] wrote: Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).