Replication :: Removing Master Site Which Is In Multi-master Environment?
Sep 16, 2008
I want to remove the master site which is in the multi master replication environment.
I have a doubt here. When I try to suspend the master activity,I need to give the gname.
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => 'NAGADMIN');
END;
/
Where gname=master group name.But I have 9 master groups in my database. If i give one of the gname present in the master site will suspend the replication of the entire database from the replication.
eg; i am only giving NAGADMIN gname in the suspend activity script.. I have other gnames like, NAGUSER,NAGAUTH, etc....
IN M.V. SITE , and i am getting following error while creating REPGROUP CODE SQL> BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP ( 3 gname => 'emp_repg', 4 master => 'orc1',
while replicating the master site via materialized views, in mViewGroups i issued:
BEGIN DBMS_REFRESH.MAKE ( name => 'mvadmin.hamza_refg', list => '', next_date => SYSDATE, interval => 'SYSDATE + 1/1440', -- for test purpose i used such a small interval implicit_destroy => FALSE, rollback_seg => '', push_deferred_rpc => TRUE, refresh_after_errors => FALSE); END;
in my previous attempt it worked all fine... i had a change in senerio, so i did my replication again from scractch using the same old spool in a new installation but even after 3 tries on replicating from scratch my objects are not getting refreshed automatically. even when i attempt to refresh the group it does not work. it works only when i refresh each of the participating object of the group manually.
I have 3 sites which want to be updated as soon as the other one updates its data.(in 5 seconds). So I have chosen multi master solution,sync regardless of the resource consideration.
1-what is the difference between multimaster async and updatable materialized view regardless of resource consuming in multimaster?because in both of them each site can receive and also propagate the data...I just know that in materialized view we can work offline and then apply it manually is there any other thing?
2-I can not understand the difference between multimaster sync and async (considering the 5 seconds,because 5 second is a little time)I mean in this case are they different from each other or not.
I have a multimaster replication between 2 sites (BASE1 and BASE3). BASE1 is the master definition site. I want to add a new master site without acquiescing the master group (named GM_ADMINISTRATEUR).
First, I have used the script provided by Oracle :
The first time, I had Errors, so I use the command
DBMS_REPCAT.UNDO_ADD_NEW_MASTERS_REQUEST
and I drop the master site BASE2 (connected as repadmin to BASE2 site).
The master site BASE2 is not present at BASE1 master definition site, The master repgroup is not present at BASE2 BUT, the master site BASE2 is always present at BASE3 master site. I think that the command UNDO_ADD_NEW_MASTERS_REQUEST undo the changes on BASE1 (the master definition site) but don't undo the changes on the site BASE3.
And now, when I want redo the add_new_masters, the command
DBMS_REPCAT.ADD_NEW_MASTER return a error on the command ADD_NEW_MASTER in the DBA_REPCATALOG for the following reason: ORA-00001: violation de contrainte unique (SYSTEM.REPCAT$_REPSCHEMA_PRIMARY) ORA-06512: � "SYS.DBMS_REPCAT_UTL", ligne 4484 ORA-06512: � "SYS.DBMS_REPCAT_RPC", ligne 1758
And I can't continue because the new master site BASE2 does not appear at BASE1 master definition site. I think I have to drop the master site BASE2 at the master site BASE3, but I dont know how to do this.
**** Following information at BASE1 (master definition site : ***** prompt Replication schemas/ sites Replication schemas/ sites select sname, masterdef,
I want to upgrade all the Oracle 10g Release (10.2.0)master sites (bi-directional) databases to Oracle 11g Release (latest). In fact, we are using bi-directional oracle streams and snapshot replication, it means capture,propagate and apply process is running.
I created one table with out primary key like well_1 .in that table have have more than 30 columns.
SQL> select uwi,analysis_obs_no,fluid_type,top,base,date_sampled from well_1 2 where uwi ='1000 and base =2871.5;
UWI obs_NO F TOP BASE ---------------- ---- ------ ----- - ----------------------------- 1000 1 G 2870.5 2871.5 1000 3 G 2516 2871.5 1000 4 G 2870.5 2871.5 1000 2 G 2870.5 2871.5 1000 6 G 2516 2871.5 1000 5 G 2516 2871.5 1000 7 G 2516 2871.5 1000 1 L 2516 2871.5 1000 2 L 2516 2871.5 7 rows selected.
i did code like this in from in search panel. in taht form i will enter uwi and base values and iwill click search button.then it will display all record values in master block .after taht i will click next button then it will display next values(all values).
i am getting all values (1 G to 7 G values).but iam not getting last 2 records when i click next button (1 L to 2 L values ).
next button
select analysis_obs_no,fluid_type into :ctrl1.OBS_NO,:ctrl1.fluid_type from well_gas_anal where analysis_obs_no =(select min(analysis_obs_no) from well_gas_anal [code].....
i tried in SQL*PLUS like this :
select rowid,analysis_obs_no,fluid_type,rownum 2 from well_gas_anal 3 where rowid=(select min(rowid) 4 from well_gas_anal 5 where analysis_obs_no > &a 6 and uwi ='1000' and base =2871.5 ) 7 and uwi ='1000' and base =2871.5 8* and fluid_type is not null SQL> /
The Scenario is that we have Master and detail table (With Foreign key enabled), we want to TRUNCATE Master table.
1) Is there any option which can Truncate the table without disabling the constraints for child tables...we want to Truncate the table forcefully.. 2) What will be best method to truncate a Table having Master detail relation (Foreign key enabled) and we need to truncate the table without disabling the constraint ( if there are records in child table) 3) What will be best method to truncate a Table having Master detail relation (Foreign key enabled) and we need to truncate the table without disabling the constraint ( if there are NO records in child table
I want to delete Master / Detail Data through cursor between date 01-02-2010 till 10-02-2010. Problem is in Detail I dont have date column in detail. But I have to delete Master and Detail record with desire date. I have made a cursor but it delete only detail record i want to delete master record too.
Master Table M_NO CHAR (12) NOT NULL, REMARKS VARCHAR2 (200), CANCEL_YN CHAR (1) NOT NULL, M_DATE DATE NOT NULL, PRIMARY KEY ( M_NO ) ) ;
Detail Structure
M_SNO NUMBER NOT NULL, ACCOUNT_CODE CHAR (19) NOT NULL, CANCEL_YN CHAR (1) NOT NULL, M_DESC VARCHAR2 (200), DB_AMT NUMBER, CR_AMT NUMBER, M_NO CHAR (12) NOT NULL, PRIMARY KEY ( M_SNO, M_NO ) ) ;
create or replace procedure test as cursor md_cur is select m_No from master where m_Date between '01-02-2010' and '10-02-2010';
we have two tabular block first one is master and sencond one is detail when we insert detail item it proper work and when when move next record in master block then it ask for save, I want to user enter all record and when he save with button then it save other wise no. but when he move any record in master block all realted record show in detail block.
I have approximately 1200 transaction to be updated to a master table. There are other columns in the master table but only one column is being updated. I would like to use sqlloader if possible or any other efficient means. Those 1200 record is stored in an excel spreadsheet. The col1 of the excel spreadsheet have to match col1 of the master table inorder for update col2 from the excel spreadsheet. Here is an example of the data. My operation system is HPUX and database is Oracle 10g.
Master table col1 col2 col3 col 4 4238 susan 56e 5879 h698c rich 12g 7091 joyce 34b 0876 mike 25n 7501 k956b robert 87c 9498 angela 67r 3645 doris 92y
my problem is with cancel masterbutton, when i clear form through this cancel masterbutton it clear the form. but after this when i click on show button it is not working, although show button is working correctly before pressing cancel_query masterbutton. what should i consider for correct working.
I have a master detail form. I have one column in master, which is a free text field and one in detail block which is a LOV. When I enter data in the master block and select say A,B,C records in LOV in detail block and saved it. These A,B,C records in LOV shouldn't appear in the detail block when a new record is entered in the master Block.
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 28 17:07:53 2010 SQL> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "DeciPher"; ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "DeciPher" * ERROR at line 1: ORA-28374: typed master key not found in wallet
I have a Oracle Form which has 2 blocks, master and Detail.I have a pre-Insert Trigger on master block which has a sequence that acts as the id of the primary key column. Now, when I populate the master block and dont save then go to detail block and save(after populating detail block's data) it gives me an error that can not insert null into detail block foreign key column.I understand that his is happening because in the above scenario pre-insert is not firing for the master block.Am I writing the the sequence generation code in a wrong trigger?
I have a form that contains a tab canvas. On the second canvas page I have two data blocks with a master detail relationship.The first block (master) is driven by a table (table_one) with the following fields:
The second block only shows error_code and error_code_desc. The point of this canvas page is to add/remove master records and associate detail records with a master. I never want to actually insert or remove records from table two; merely updating the sf_id column in table two.What I am trying to achieve is the following:
1. Create a master record with detail records at the same time. 2. Delete a master record 3. Add and remove detail records
An insert into the detail block is nothing more than associating a master record with a detail record by updating the sf_id column in table two. A delete from the detail block is nothing more than setting the sf_id column to null in table two. I am not actually adding or removing records in table_two.
I have tried overriding the commit on the second block to perform updates instead of Oracle actually trying to insert NEW records into table_two.
I am trying to query a form having two data blocks. one is a master and the other is a detail block. the problem is when i insert data in the form, save it, and press enter query key, the data in the master block fields are still there. while the data in the detail block field are cleared and i can insert values. how to clear data from master block field so i can query
I'm designing a canvas which will open up on the click of a push-button from a form A. Now this form A has a data block(ie. single underlying table A).
I want to display data from two tables - Table B and Table C in this canvas in the form of a multi-record grid structure - one below the other i.e. table B data above and table C data below.
Now table B and table C share a PK-FK relnship between them. What I want is when a user clicks on a record in the table B above then the corresponding records in the table C should get displayed below(now there can be multiple detail records in table C for a single record in table B - PK-FK reln)
i'd written code something like this in the When-button-pressed trigger:-
c_where_clause := ....(query from Form A) set_block_property('block B',default,c_where_clause); go_block('block B'); go_block('block C'); execute_query; first_record;
(in addition to the above trigger, I have also included queries in the post-query trigger of the two tables B and C to get some data populated in the non-database fields in this canvas)
do i have to do add a piece of code to loop thru the records...like checking for last record,if not going to the next_record and so on for both the blocks?
i want to ask, that in a master detail form, when a user enters few records in detail block against a master record, then when creating a new master record the form builder prompts to save the form first (with yes, no, cancel) option, if we hit no, the records in the detail block are washed away (while the master records remains)
is there any option that i can create several master records having associated detail records before saving them all at the end.
Submitting transaction / master data through API without exposing DB credentials...I am developing a scenario where I will submit transaction / master data like sales order / master item to Oracle apps (EBS) through MS Excel via API / interface table but like to provide only apps (EBS) user credentials rather then DB credentials so DB password could not expose to normal end user.
5) issued command as sysdba - ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "ASHISH123";
6) restarted the database.
7) since i want to made it autologin. so I open wallet through the below mentioned path program file >>oracle_home>> integrated management tool >> wallet But when it asked the password I typed the same password but it was not accepting. So i made new wallet with the same specified path. Also I clicked on auto login.
8) Now, i have restarted the database and tried to issue the command "ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "suresh123";
While issuing the command, getting error "ora-28374 typed master key not found in wallet". "
i tried with the recreation of new folder again on the same path as -"C:appAdministratoradmin estwallet" and same entry updated on sqlnet.ora. But facing the same error.
Is there any way to re-create or modify the encryption of tablespace?
