Streams Changes Propagated to Target But Not Applied - Source Has No Domain Name and Destination Does Have a Domain Name (Doc ID 1126744.1)
Last updated on JUNE 16, 2010
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5 - Release: 10.2 to 10.2 Information in this document applies to any platform.
When attempting to implement Oracle Streams between a source with no domain name as part of its global name and target with a domain name in its global name, it is observed that changes are propagated to the target but not applied. There are no errors.
Further investigation reveals that the source database name used at the target in several key areas has had the target's domain name appended to it, even though there is no such domain name in the global name at the source. This is observed in:
The apply rules at the target.
The DBA_APPLY_PROGRESS view at the target.
The DBA_APPLY_INSTANTIATED_OBJECTS view at the target
For example, if the source global name is RED, and the target global name is BLUE.WORLD, setting up Streams between these using normal methods can result in the source database name RED.WORLD appearing in the views above at the target. This difference between the actual source global name and the source global name recorded in the target views will result in LCRs from the source being discarded by the target apply process.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms