Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem Description: ACTIVE: APPLY PROCESS ABORTED AND NOT STARTING
### Detailed Problem Statement ###
Env:
CDC is esablished as the follwoing:
3 source systems:
1-BB01 -10.2.0.2 database
2-DB02 -10.2.0.2 database
3-DB03 -10.2.0.3 database
Destination is a 10.2.0.4 database (DB00)
The apply processes for source system DB01 (CDC$C_CTMS) is not starting with
"ORA-26701: STREAMS process CDC$C_CTMS does not exist"
this apply process was running before but got aborted beacuase of data error.
"ORA-01438: value larger than specified precision allowed for this column"
however on printing the problamatic LCR as per Note:265201.1 :
SET SERVEROUTPUT ON;
DECLARE
lcr SYS.AnyData;
BEGIN
lcr := DBMS_APPLY_ADM.GET_ERROR_MESSAGE
(<MESSAGE_NUMBER>, <LOCAL_TRANSACTION_ID>);
print_lcr(lcr);
END;
/
it is showing the transaction as an update field
Table structures are exactly the same on source and destinations.
Troubleshooting:
1. Please run the Streams Health Check SQL scripts on the instances where
CDC is configured and upload the output file to MetaLink.
Note.273674.1 Streams Configuration Report and Health Check Script
2. 10 columns have the table involved in the failed update (ORA-1438):
3. We want to execute the transaction manually, and see if it reproduces the
same error. So kindly follow the below procedure.
exec dbms_apply_adm.execute_error('<x.x.xxxx>') gave the below errors:
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 147
ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 261
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 468
ORA-06512: at line 1
4. There are two bugs about ORA-1438 and CDC. You will find additional information in:
Note.788425.1 CDC Change Table with more than 128 Columns Fails with ORA-1438
Note.745459.1 CDC APPLY FAILS WITH ORA-01722 OR ORA-01438 INTERMITTENTLY BUT RE-EXECUTION WORKS
Solution:
Apply Recommended patches 6454634 & 8680137
MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 8488171 846406
### Detailed Problem Statement ###
Env:
CDC is esablished as the follwoing:
3 source systems:
1-BB01 -10.2.0.2 database
2-DB02 -10.2.0.2 database
3-DB03 -10.2.0.3 database
Destination is a 10.2.0.4 database (DB00)
The apply processes for source system DB01 (CDC$C_CTMS) is not starting with
"ORA-26701: STREAMS process CDC$C_CTMS does not exist"
this apply process was running before but got aborted beacuase of data error.
"ORA-01438: value larger than specified precision allowed for this column"
however on printing the problamatic LCR as per Note:265201.1 :
SET SERVEROUTPUT ON;
DECLARE
lcr SYS.AnyData;
BEGIN
lcr := DBMS_APPLY_ADM.GET_ERROR_MESSAGE
(<MESSAGE_NUMBER>, <LOCAL_TRANSACTION_ID>);
print_lcr(lcr);
END;
/
it is showing the transaction as an update field
Table structures are exactly the same on source and destinations.
Troubleshooting:
1. Please run the Streams Health Check SQL scripts on the instances where
CDC is configured and upload the output file to MetaLink.
Note.273674.1 Streams Configuration Report and Health Check Script
2. 10 columns have the table involved in the failed update (ORA-1438):
3. We want to execute the transaction manually, and see if it reproduces the
same error. So kindly follow the below procedure.
exec dbms_apply_adm.execute_error('<x.x.xxxx>') gave the below errors:
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 147
ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 261
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 468
ORA-06512: at line 1
4. There are two bugs about ORA-1438 and CDC. You will find additional information in:
Note.788425.1 CDC Change Table with more than 128 Columns Fails with ORA-1438
Note.745459.1 CDC APPLY FAILS WITH ORA-01722 OR ORA-01438 INTERMITTENTLY BUT RE-EXECUTION WORKS
Solution:
Apply Recommended patches 6454634 & 8680137
MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 8488171 846406
No comments:
Post a Comment