| Adding New Master Sites Without Quiescing the Master Group (v.10.1.0.2) [message #64250] |
Wed, 05 January 2005 22:40  |
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  |
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 |
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 |
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 |
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)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
