Problem solve Get help with specific problems with your technologies, process and projects.

Replicating with master and snapshot sites on different Oracle versions

Can you tell me if replication with the master site on version 10 and the snapshot site on version 9 will work? Currently the master site is on 8.0.6, and the snapshot site is on 8.1.6.

Why? If your sites aren't at the same releases now and you're considering upgrading both sites, then you should upgrade them to the same release.

I remember seeing a MetaLink note quite a long time ago on replication compatibility between Oracle releases. From what I recall, I think that it depends on what type of replication you're using and whether or not updates happen at more than one node. You mention a snapshot site which suggests that you're not using multi-master replication, but you don't say whether or not your snapshot sites can be updated or not. You'll need to find the note to be sure, but compatibility may be different depending on whether or not the snapshot sites can be updated or are read-only.

If I were a gambling man, I'd bet that you'll have pretty good compatibility with read-only snapshots, especially if they are using complete refreshes (no snapshot logs on the master site). For any other combinations, I would keep my money in my pocket and start reading some documentation.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.