Re: Advanced Rep between 9.2.0 and 8.1.7?
Yes, I am replicating between 8.1.7.3 and 9iR2 without any issues. Need help? OraCop --- Michael Barger [EMAIL PROTECTED] wrote: Has anyone heard of or experienced a successful implementation of Advanced Replication between an 8.1.7 database and a 9.2.0 db? __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Advanced Rep between 9.2.0 and 8.1.7?
What is performance like ? how many objects in replication group ? What I am essentially looking for is performance degradation metrics and full specs (# users, machine, OS, size of DB, # rows in largest tables, rate of inserts / updates) from source for a one-way replication of about 500 tables and about 3,000 indexes on these tables. You wouldn't happen to have any of those metrics, would you ? Would you ? Pretty please ? Quests touts that Shareplex is so much better than AR, but how much is that ? Does it justify the price premium which they are not shy on ? Or should I be looking at Shadow Base 3, or Omni-Replicator, or just stick with AR and slap in an extra CPU ? Thanks. Ferenc Mantfeld -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject:Re: Advanced Rep between 9.2.0 and 8.1.7? Yes, I am replicating between 8.1.7.3 and 9iR2 without any issues. Need help? OraCop --- Michael Barger [EMAIL PROTECTED] wrote: Has anyone heard of or experienced a successful implementation of Advanced Replication between an 8.1.7 database and a 9.2.0 db? __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Advanced Rep between 9.2.0 and 8.1.7?
Ferenc, I have a multimaster setup between 8174 and 920 and works like a charm. Tables 200 Schemas 5 Total Size 600 Gb Average Table Size 14 million rows Transaction per second (from STATSPACK) about 13 Machine HP 6000 servers OS Windows 2000 Advanced Server About the setup, there is nothing special about replication between 8ik and 9i, it's pretty much the same as in case of 8i-8i. HTH Arup Nanda www.proligence.com From: mantfield [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Advanced Rep between 9.2.0 and 8.1.7? Date: Tue, 26 Nov 2002 19:04:04 -0800 MIME-Version: 1.0 Received: from mc4-f18.law16.hotmail.com ([65.54.237.153]) by mc4-s19.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 26 Nov 2002 19:32:57 -0800 Received: from newsfeed.cts.com ([209.68.248.164]) by mc4-f18.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 26 Nov 2002 19:32:55 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id TAA56272;Tue, 26 Nov 2002 19:27:42 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050D197; Tue, 26 Nov 2002 19:04:04 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: mantfield [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 27 Nov 2002 03:32:55.0586 (UTC) FILETIME=[AC8DB820:01C295C5] What is performance like ? how many objects in replication group ? What I am essentially looking for is performance degradation metrics and full specs (# users, machine, OS, size of DB, # rows in largest tables, rate of inserts / updates) from source for a one-way replication of about 500 tables and about 3,000 indexes on these tables. You wouldn't happen to have any of those metrics, would you ? Would you ? Pretty please ? Quests touts that Shareplex is so much better than AR, but how much is that ? Does it justify the price premium which they are not shy on ? Or should I be looking at Shadow Base 3, or Omni-Replicator, or just stick with AR and slap in an extra CPU ? Thanks. Ferenc Mantfeld -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: Advanced Rep between 9.2.0 and 8.1.7? Yes, I am replicating between 8.1.7.3 and 9iR2 without any issues. Need help? OraCop --- Michael Barger [EMAIL PROTECTED] wrote: Has anyone heard of or experienced a successful implementation of Advanced Replication between an 8.1.7 database and a 9.2.0 db? __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Advanced Rep between 9.2.0 and 8.1.7?
Has anyone heard of or experienced a successful implementation of Advanced Replication between an 8.1.7 database and a 9.2.0 db? __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).