Replication for Standard Unleaded Edition

I have recently read in an article (by Prakash) regarding 'Simulating Multi-master Replication in Standard Edition'.

With the difference of costs between Standard and Enterprise editions, customers are having large interest in this solution.

Can you please give a prototype on how to do this. Examples and scripts would be appreciated.


Posted On: Friday 16th of November 2012 12:53:12 AM Total Views:  324
View Complete with Replies

Related Messages:

Oracle standard edition replication   (188 Views)
I need to replicate data from plant to head office and vice-versa. Following is our business case. exisitng application is running independently at 7 locations Developed using Visual Basic with backend oracle. Now we need to maintain data of all locations at all places. Can you please help me to handle this using oracle standard edition.
Snapshot replication:   (194 Views)
In a updateable snapshot replication, when only one column is updated on the master, will the entire record be updated on the replicated site or only the column on which the changes happened will get replicated. Eg: col2 changes(updated) on the master table log.(There are 4 col: Col1,col2,col3,col4). When the refresh process happens, Will the oracle refresh the entire row (all the columns) or only the col2 is sent to the replication site: We need to change the logic of one of the batch programs based on this input. Please let me know.
replication of packages in multi master replication   (182 Views)
Hi I am working on Oracle database 10g. I am trying to implement advanced replication on my database. Till now I have replicated tables and those are working fine. Now I want to replicate procedure, in this case on running all the procedures(adding packages and generating replication support) I am not getting any error. But after this I am not able to resume replication. In DBA_REPGROUP status of master group is QUIESCED. I want to know why I am getting this problem and how can i solve it. I am running following code for this : BEGIN DBMS_REPCAT.create_master_repobject (sname => 'REPADMIN', oname => 'PKG_COMMON_ERROR', TYPE => 'PACKAGE', use_existing_object => TRUE, COMMENT => 'Added on ' || SYSDATE, retry => FALSE, gname => 'MYREPGRP' ); DBMS_REPCAT.create_master_repobject (sname => 'REPADMIN', oname => 'PKG_COMMON_ERROR', TYPE => 'PACKAGE BODY', use_existing_object => TRUE, COMMENT => 'Added on ' || SYSDATE, retry => FALSE, gname => 'MYREPGRP' ); END; BEGIN DBMS_REPCAT.generate_replication_support (sname => 'REPADMIN', oname => 'PKG_COMMON_ERROR', TYPE => 'PACKAGE', DISTRIBUTED => TRUE, min_communication => TRUE ); DBMS_REPCAT.generate_replication_support (sname => 'REPADMIN', oname => 'PKG_COMMON_ERROR', TYPE => 'PACKAGE BODY', DISTRIBUTED => TRUE, min_communication => TRUE ); END;
replication advice   (155 Views)
Dear members , i am having two database in two different city. City A is my HeadofficeDatabase and CityB is my factoryDatabase. Now all the Master entry will take place in CityA and Transactions in both the places.I am having around 200 Master Tables that i am planning to replicate using Simple Snapshots. The Transaction tables are having more than 200 and that will be replicated using Master to Master Replication .CityA will be the Master Definition site and CityB will be the Master site. The lease line from City A to City B is 64kpbs out of which i will be getting only 24kpbs for data transfer. If i am implimenting the above system will i be able to replicate properly Please guide me on this issue..
replication - need help   (235 Views)
Hi I am trying to setup advanced replication. When running catrep.sql as internal i noticed the following error: Statement processed. from system.def$_aqcall C, system.def$_aqcall C1, * ORA-00942: table or view does not exist grant select on defcalldest to select_catalog_role * ORA-00942: table or view does not exist comment on table DEFCALLDEST is * ORA-00942: table or view does not exist comment on column DEFCALLDEST.CALLNO is * ORA-00942: table or view does not exist comment on column DEFCALLDEST.DEFERRED_TRAN_ID is * ORA-00942: table or view does not exist comment on column DEFCALLDEST.DBLINK is * ORA-00942: table or view does not exist Statement processed. Statement processed. from system.def$_aqcall C, system.def$_destination D * ORA-00942: table or view does not exist grant select on deftrandest to select_catalog_role * ORA-00942: table or view does not exist Statement processed. Statement processed. Statement processed. ORA-00942: table or view does not exist ORA-06512: at "SYSTEM.ORA$_SYS_REP_AUTH", line 29 ORA-06512: at line 2 Statement processed. No errors for PACKAGE BODY UTL_RAW When I query the dba_objects if found the following have status = 'INVALID'. OWNER ------------------------------ OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS --------------- ------- SYS AQ$_DUMMY_T TYPE INVALID SYS DBMS_AQADM PACKAGE BODY INVALID SYS DBMS_DEFER_QUERY PACKAGE BODY INVALID SYS DBMS_DEFER_SYS SYS DBMS_DEFER_SYS_PART1 PACKAGE BODY INVALID SYS DBMS_REPCAT_MAS PACKAGE BODY INVALID SYS DBMS_REPCAT_SNA_UTL PACKAGE BODY INVALID SYS DBMS_REPCAT_UTL PACKAGE BODY INVALID SYS DBMS_SNAPSHOT PACKAGE BODY INVALID What should I do now
replication   (184 Views)
I have a snapshot log on a master table but I can delete any rows from master table. nothing in alert.log, no tablespace full I can neither select * or count(*) from my snapshot log with any users. It's take long time my snapshot log is not purge.
replication   (184 Views)
Hi , we have a setup of replication in 8.0.5 as single master defenition site and 4 snapshot sites . our requirement is to add two new snapshot site in 8.1.7 release. is it possible (with mastersite as older version and othersite as new version database) if so is there any restriction for thatwill replication work fine in this setup please reply as soon as possible
replication based on triggers   (277 Views)
gurus... Urgently help required. In oracle,How do we implement replication based on triggers(Once the data insert /update /delete the trigger should fire and the data should be replicated.At pressent it is happenig based on job interval)
replication   (134 Views)
Any idea on which replication software is more stable and easy to manage 1. oracle replication. 2. quest shareplex
replication   (187 Views)
what is the exe file to be executed to open oracle replication manager on sun solaris platform
replication   (162 Views)
, There is a peculiar situation in our office,here is its description. I want to create a replicated environment.since there is a limitaion on network traffic,so i want to have a Master site at hq's and updateable Snapshot site at remote site.It required that the changes made at snapshot site to be replicated to master site after office hours say after 15:00 hrs.For this how to configure the shedule link and purge that every dayafter office hours these changes are made at hq's. When i scrolled through some of questions posted on this site,some one told that it is not possible to send the changes made at snapshot to master site,its only single direction. in the above situation if i want to have multimaster sites at both the ends that too the changes to be replicated only after office hours so that there will not be any traffic on network. please can i have your valuable remarks on the above situration. Thank u very much my e-mail is
replication   (163 Views)
HI I have a oracle 8.1.5 database on win2k server. i have updatable snapshots for this database at a different location. when i insert a new record into the snapshot and update the master site it is working if i update any record at snapshot site and push the data to the master site it logs error at the master site "no data found."the same error when i delete a record at snapshot and try updating the master site.Plz note i am not talking of refreshing. i am using oracle replication manager. can anyone tell me what does oracle use for updating replicated data,primary key or row id.i checked the oracle documentation but couldn't get anythig.Plz let me know if i skipped any parts of the docs
replication   (180 Views)
, I created snapshot at remote site.From the oracle manuals it is noted that Oracle 8i will not support the LONG and LONG RAW datatypes,actually we are going to install a outside vendor application on remote site in which one of table consist of LONG datatype which is used to capture the images of people,since Oracle will not support this datatype,can any one tell which datatype will replace the LONG so that it will not affect the replication. Thank u
RBS in replication envrionment   (151 Views)
In a replication environment(use the replicated db for reporting only), when you do a refresh, either complete or fast, what rollback segments are being used The rbs in the master db, or in the local db
why stream replication is slow in the first startup?   (153 Views)
The data in node1 is slow applied in Node2 when i first startup stream replication,the time is one hour,I don't known the reason,who will tell me
what is the mean of replication and why we use replication??   (168 Views)
, respectfully, i have not any knowledge regarding REPLICATION. plz tell me about the replication and why we use replication in fully details. and i want to some knowledge about the STAND BY.what is the mean of STAND BY in ORACLE 10g.
replication??   (158 Views)
Hi: O.S. => Windows NT Oracle => Is advanced replication part of OEM Also, is there any other option that I can use to take the snap shot of the database periodically Let me know.
replication off   (152 Views)
How do we switch off replication for an import session, if its possible
replication is a tools ,software or any otherthings   (135 Views)
i m not getting the point what is replication plz tell me
replication group   (121 Views)
Hi Friends, I read the oracle docs about replication and It didnt give me clear explaination about it. Do u have other links that explain steps by steps on how to do it (for dummies ) For example th replication group: If I have 10 tables to replicate in a schema PROD1 and another 10 tables to replicate in schema PROD2 on db server SERVER1 Can I call them 2 groups of 1 group.