Home » Server Options » Replication » Adding New Master Sites Without Quiescing the Master Group (v.10.1.0.2)
Adding New Master Sites Without Quiescing the Master Group (v.10.1.0.2) [message #64250] Wed, 05 January 2005 22:40 Go to next message
JWH
Messages: 5
Registered: January 2005
Junior Member
All three database are ASM and flashback logging enabled in RHEL 3 environment
Establishing asynchronous multimaster replication between two sites worked just fine.

Attempt to add third failed:-

Step1. Set up:
1.The replication administrator at new master site
2.A scheduled link from each existing master site to new master site
3.A scheduled link from new master site to each existing master site
4.A schedule purge job at new master site

Status OK

Step 2. CONNECT repadmin/repadmin@orc1.world

BEGIN
DBMS_REPCAT.SPECIFY_NEW_MASTERS (
gname => 'hr_repg',
master_list => 'orc3.world');
END;

Status OK

Next step:-

variable masterdef_flashback_scn number;
variable extension_id varchar2(50);
BEGIN
DBMS_REPCAT.ADD_NEW_MASTERS (
export_required => true,
available_master_list => 'orc3.world',
masterdef_flashback_scn => :masterdef_flashback_scn,
extension_id => :,
break_trans_to_masterdef => false,
break_trans_to_new_masters => false,
percentage_for_catchup_mdef => 80,
cycle_seconds_mdef => 60,
percentage_for_catchup_new => 80,
cycle_seconds_new => 60);
END;

Procedure DBMS_REPCAT.ADD_NEW_MASTERS hangs.

Monitoring administrative requests at all three master sites through Java-Console is showing six pending administrative requests for a while (two at the one ,supposed to be added,three at Masterdef,one at second non-Masterdef Site )
Cannot escalate issue to vendor due to development phase
Adding New Master Sites Without Quiescing the Master Group (9.2.0.4) [message #64287 is a reply to message #64250] Mon, 10 January 2005 01:46 Go to previous messageGo to next message
JWH
Messages: 5
Registered: January 2005
Junior Member
The same procedures in the same environment
worked fine for 9.2.0.4.
Up on successful completion DBMS_REPCAT.ADD_NEW_MASTERS
returns value of masterdef_flashback_scn and updates FLASHBACK_SCN
field of view DBA_REPEXTENSIONS on Masterdef Site . This value is supposed to be used to export desired schema on Masterdef Site for transfer and import on
newly added site to Multi-Master Replication System
Adding New Master Sites Without Quiescing the Master Group (v.10.1.0.2) - Error [message #64295 is a reply to message #64250] Mon, 10 January 2005 06:26 Go to previous messageGo to next message
JWH
Messages: 5
Registered: January 2005
Junior Member
AT THE MASTERDEF SITE :

/u01/app/oracle/admin/orcldata/udump/orcldata_ora_13324.trc

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
System name: Linux
Node name: ServerVRN
Release: 2.4.21-15.ELsmp
Version: #1 SMP Thu Apr 22 00:18:24 EDT 2004
Machine: i686
Instance name: orcldata
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 13324, image: oracleorcldata@ServerVRN

*** ACTION NAME:() 2005-01-10 16:14:38.723
*** MODULE NAME:(SQL*Plus) 2005-01-10 16:14:38.723
*** SERVICE NAME:(orcldata) 2005-01-10 16:14:38.723
*** SESSION ID:(248.12) 2005-01-10 16:14:38.723
*** 2005-01-10 16:14:38.722
wait_for_masters: waiting for repcatlog with id = 49 during add_new_masters
*** 2005-01-10 16:16:31.592
wait_for_masters: waiting for repcatlog with id = 49 during add_new_masters
*** 2005-01-10 16:18:24.452
wait_for_masters: waiting for repcatlog with id = 49 during add_new_masters

AT THE SITE SUPPOSED TO BE ADDED:

/u01/app/oracle/admin/qws3data/bdump/qws3data_j000_10619.trc

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
System name: Linux
Node name: ServerVRN
Release: 2.4.21-15.ELsmp
Version: #1 SMP Thu Apr 22 00:18:24 EDT 2004
Machine: i686
Instance name: qws3data
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 10619, image: oracle@ServerVRN (J000)

*** 2005-01-10 16:13:57.800
*** ACTION NAME:() 2005-01-10 16:13:57.777
*** MODULE NAME:() 2005-01-10 16:13:57.777
*** SERVICE NAME:(SYS$USERS) 2005-01-10 16:13:57.777
*** SESSION ID:(261.67) 2005-01-10 16:13:57.777
can not pull extension request ED5A07CE1CAAA0C0E030A8C01B00340C from ORCLDATA
-6502.ORA-06502: PL/SQL: numeric or value error: character string buffer too small
*** 2005-01-10 16:23:43.317
*** ACTION NAME:() 2005-01-10 16:23:43.317
*** MODULE NAME:() 2005-01-10 16:23:43.317
*** SERVICE NAME:(SYS$USERS) 2005-01-10 16:23:43.317
*** SESSION ID:(261.109) 2005-01-10 16:23:43.317
can not pull extension request ED5A07CE1CAAA0C0E030A8C01B00340C from ORCLDATA
-6502.ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Increasing extension_id up to varchar2(500) doesn’t help
Re: Adding New Master Sites Without Quiescing the Master Group (v.10.1.0.2) [message #64352 is a reply to message #64250] Sun, 16 January 2005 09:51 Go to previous messageGo to next message
JWH
Messages: 5
Registered: January 2005
Junior Member
Issue appears to be noticed for 9.2.0.5 (HP-UX 11i ,SunOS 5.9,AIX 5.1) and 10.1.0.2 (Solaris 2.8) on DBA's Forum at Metalink.

View threads :-

1. Re : Errors adding new master site to multi-master repl setup
626837.999 04-NOV-2004
2. Re : 10g replication new features 618911.995 12-OCT-2004

Trace file content shows up the same errors as reported in current thread.
Re: Adding New Master Sites Without Quiescing the Master Group (v.10.1.0.2) [message #64436 is a reply to message #64250] Fri, 28 January 2005 10:14 Go to previous message
JWH
Messages: 5
Registered: January 2005
Junior Member
Per Metalink Notes:-

Bug 4015165 - Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
Range of versions believed to be affected Versions >= 9.2.0.6 but < 10.2
Platforms affected Generic (all / most platforms affected)
This issue is fixed in 10.1.0.4 (Server Patch Set)
10g Release 2 (future version)
Previous Topic: how to rollback a materialized view in oracle 8.1.7
Next Topic: Replication between MS SQL Server and Oracle
Goto Forum:
  


Current Time: Fri Mar 29 09:44:06 CDT 2024