Monday, July 4, 2011

ORA-01403: no data found Error in Oracle Downstreams.

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

Problem: ORA-01403: no data found Error in Oracle Downstreams.


Log files:
++ ERROR QUEUE ++

Apply
Name Source
Database Source
Commit
Scn Message in
Txn causing
Error Total
Messages
in Txn Local
Transaction
ID Apply
Error
Message Error
Creation
Timestamp Source
Transaction
ID
APPLY_DEC_PROC UDPP.DUBAIWORLD .AE 1158911000920 3 7 5.22.50689 ORA-01403: no data found 04:15:34 05/21/09 4.20.47663
UDPP.DUBAIWORLD .AE 1158911001108 4 6 4.18.46373 ORA-01403: no data found 13:16:09 05/21/09 265.35.11029


APPLY_DEC_PROC STRMADMIN.APP_DEC_QUEUE Captured ABORTED STRMADMIN 00 STRMADMIN.RULESET$_1215

APPLY_DEC_PROC ABORTED 13:16:11 05/21/09 26714 ORA-26714: User error encountered while applying

DISABLE_ON_ERROR Y (for all apply processes)

Solution:

1403 error normally refers to inconsistency in the data between source and target, so you need to compare the data between the two sites to find the differences and manually fix them before starting the apply again.

It is recommended to set the apply parameter "disable_on_error" to false instead of its current value of true, so in the future any such errors doesn't stop the apply process, and then manually you can fix the errors without stopping the replication.

The following article used to find the steps needed to identify the transaction that caused the 1403 error :
Note.405541.1 Procedure to Print LCRs

References:

Run the Streams Health Check SQL scripts on the instances where
Streams is configured.
 
Note.273674.1 Streams Configuration Report and Health Check Script
Note.405541.1 Procedure to Print LCRs
More in depth information on how to diagnose the 1403 errors :
Note.265201.1 Troubleshooting Streams Apply Error ORA-1403, ORA-26787 or ORA-26786
How to manually resync the data :
Note.749036.1 How to Re-Synchronize Streams Replicated Objects Online

    
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: