Database Software

I have a following streams configuration:

Source/Publisher server Oracle RAC EE 11.2.0.2 with 2 nodes (HOST_NAME:SR-ORACAR1/2)

********** CREATING TABLESPACE ***********************

CREATE TABLESPACE STR_ADSL_DATA
DATAFILE '+DATA' SIZE 5G AUTOEXTEND ON NEXT 200M MAXSIZE 30G
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 200M
SEGMENT SPACE MANAGEMENT MANUAL;


************** CREATING TABLE ***************************

CREATE TABLE "CARDBUSR"."RADIUSACCOUNTING"
( "PRIMARYKEY" NUMBER(18,0),
"GROUP_NAME" VARCHAR2(255),
"USER_NAME" VARCHAR2(255),
"NAS_IP_ADDRESS" VARCHAR2(255),
"NAS_PORT" VARCHAR2(255),
"SERVICE_TYPE" VARCHAR2(255),
"FRAMED_PROTOCOL" VARCHAR2(255),
"FRAMED_IP_ADDRESS" VARCHAR2(255),
"CALLING_STATION_ID" VARCHAR2(255),
"ACCT_STATUS_TYPE" VARCHAR2(255),
"ACCT_INPUT_OCTETS" NUMBER(38,0),
"ACCT_OUTPUT_OCTETS" NUMBER(38,0),
"ACCT_SESSION_ID" VARCHAR2(255),
"ACCT_SESSION_TIME" NUMBER,
"ACCT_INPUT_PACKETS" NUMBER(38,0),
"ACCT_OUTPUT_PACKETS" NUMBER(38,0),
"LOGGEDAT" DATE
) PCTFREE 2 PCTUSED 40 INITRANS 16 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 5G NEXT 200M FREELISTS 16 FREELIST GROUPS 8 BUFFER_POOL DEFAULT)
TABLESPACE "STR_ADSL_DATA";

***************** Other configurations **************************

BEGIN
DBMS_STREAMS_AUTH. GRANT_ADMIN_PRIVILEGE (grantee => 'STRADMIN', grant_privileges => TRUE);
END;


CREATE TABLESPACE "STR_METADATA" DATAFILE
'+DATA' SIZE 1G AUTOEXTEND ON NEXT 200M MAXSIZE 30G
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

BEGIN
DBMS_LOGMNR_D.SET_TABLESPACE ('STR_METADATA');
END;


************ creating capture/apply queue ************

BEGIN
DBMS_STREAMS_ADM.set_up_queue(queue_table => 'CAPTURE_STRUMICATAB',
queue_name => 'CAPTURE_STRUMICA',
queue_user => 'stradmin');
END;
/

************ creating capture process ************
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES (table_name => '"CARDBUSR"."RADIUSACCOUNTING"',
streams_type => 'capture',
streams_name => 'CAPTURE_STRUMICA',
queue_name => 'CAPTURE_STRUMICA',
include_dml => TRUE,
include_ddl => FALSE,
inclusion_rule => TRUE);
END;
/

BEGIN
dbms_capture_adm.set_parameter(capture_name => 'CAPTURE_STRUMICA',
parameter => '_SGA_SIZE',
VALUE => '70');
END;
/

BEGIN
dbms_capture_adm.set_parameter(capture_name => 'CAPTURE_STRUMICA',
parameter => '_CHECKPOINT_FREQUENCY',
VALUE => '500');
END;
*/


************* create apply process ******************************************

BEGIN
DBMS_APPLY_ADM.create_apply (queue_name => 'CAPTURE_STRUMICA',
apply_name => 'APPLY_STRUMICA',
APPLY_DATABASE_LINK => 'ADSL',
source_database=>'SRCAR' ,
apply_captured => TRUE);
END;

BEGIN
DBMS_STREAMS_ADM.add_table_rules (table_name => '"CARDBUSR"."RADIUSACCOUNTING"',
streams_type => 'apply',
streams_name => 'APPLY_STRUMICA',
queue_name => 'CAPTURE_STRUMICA',
include_dml => TRUE,
include_ddl => FALSE,
inclusion_rule => TRUE);
END;

BEGIN
DBMS_APPLY_ADM.
set_parameter (apply_name => 'APPLY_STRUMICA',
parameter => 'disable_on_error',
VALUE => 'N');
END;
/

*>>>note:* apply and capture process are created on Source Database database without using a propagation. I use a APPLY_DATABASE_LINK => 'ADSL' to transfer the data from Source Database (Oracle 11.2.0.2) to the destination (Oracle RAC EE 10.2.0.3). At source Database SRCAR table "CARDBUSR"."RADIUSACCOUNTING" has aproximatly 100 insert/second, and no delete and no update. Structure of "CARDBUSR"."RADIUSACCOUNTING" at ADSL is eqwivalent.

From Oracle EM Streams Advisor I got the folowing output

Component Level Statistics:APPLY_STRUMICA
Name Component Database:SRCAR
Path ID:2
Bottleneck:YES
Latency (Seconds):59631
Message Apply Rate (Messages/Sec):87.57
Transaction Apply Rate (Txn/Sec):43.86

Then I tried to change directly and from EM:

BEGIN
DBMS_APPLY_ADM.SET_PARAMETER(
apply_name => 'APPLY_STRUMICA',
parameter => 'parallelism',value =>2);
END;
/

BEGIN
DBMS_APPLY_ADM.SET_PARAMETER(
apply_name => 'APPLY_STRUMICA',
parameter => 'parallelism',value =>'2');
END;
/

but I allways got the following error

Exception - oracle.sysman.emSDK.admObj.AdminObjectException: java.sql.SQLException: ORA-23605: invalid value "2" for Streams parameter PARALLELISM ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 161 ORA-06512: at "SYS.DBMS_APPLY_ADM", line 83 ORA-06512: at line 2


At metalink I didn't find any suggestion.
I need help !

Edited by: user8710043 on Mar 24, 2011 11:23 AM