Sunday, October 23, 2011

knlc_ProcessMVDD-1: MISSING Streams multi-version data dictionary!!!

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 Description: knlc_ProcessMVDD-1: MISSING Streams multi-version data dictionary!!!


found the following errors in alert.log:
knlc_ProcessMVDD-1: MISSING Streams multi-version data dictionary!!!
knlldmm: gdbnm=PROMISP.DUBAIWORLD.AE
knlldmm: objn=-40016384
knlldmm: objv=1
knlldmm: scn=1169006882675
knlldmm: opnum=7

Troubleshooting:


1-Please run the Streams Health Check SQL scripts on the instances where CDC is configured and investigate and errors from the generated files.

Note.273674.1 Streams Configuration Report and Health Check Script

Explanation:


-- Problem Statement:
DB0 is a 10.2.0.4 database which has 3 dowstream capture process and capture changes from 3 databases:

1- DB1 database 10.2.0.2
2- DB2 database 10.2.0.2
3- DB3 10.2.0.3

In the alert.log file for DB0, we can see the following errors reported.

knlc_ProcessMVDD-1: MISSING Streams multi-version data dictionary!!!
knlldmm: gdbnm=PROMISP.DUBAIWORLD.AE
knlldmm: objn=-40016384
knlldmm: objv=1
knlldmm: scn=1169006882675
knlldmm: opnum=7

The information is always referencing database DN02, but object_id referenced does change.
There are no objects corresponding to these numbers in source neither in destination

Solution:





Bug 7257038 ...fixed on 11.2

REDISCOVERY INFORMATION:
If you get
"knlc_ProcessMVDD-1: MISSING Streams multi-version data dictionary!!!"
in the capture database, it's likely to be this bug.



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: