|
Баг затронутый в:-
воспроизводиться с той же ошибкой ORA-06502.
Патч предположительно закрывающий проблему 10.1.0.4
Полный текст JWH:-
All three databases are ASM and flashback logging enabled in RHEL 3 environment
Establishing asynchronous multi-master replication between two sites completed OK.
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@orcldata
BEGIN
DBMS_REPCAT.SPECIFY_NEW_MASTERS (
gname => 'hr_repg',
master_list => 'qws3data');
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 => 'qws3data',
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 administrative requests
pending for a while:
PULL_EXTENSION & PREPARE_FOR_IMPORT at the one ,supposed to be added
AWAIT_CALLBACK (3 requests) at Masterdef
PULL_EXTENSION at second non-Masterdef Site
Trace files content during request's pending:-
AT THE MASTERDEF SITE (orcldata) :
/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 (qws3data) 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
Encreasing extension_id up to varchar2(500) doesn't help
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
Ваш комментарий:
|
БИБЛИОТЕКА 
