This content has been marked as final. Show 6 replies
Gosh, this is confusing:
From the certification matrix, it looks like compatible, but from a metalink note, it doesn't:
Certification matrix: http://www.oracle.com/technetwork/middleware/data-integration/goldengate1111-cert-matrix-349179.xls
Conflicting metalink note:
Compatibility Between OGG Builds and Oracle Database Versions [ID 1086154.1]
Compatibility between Oracle GoldenGate (OGG) builds and Oracle database Versions
Can I use an OGG build for Oracle 10G to extract / replicate from /to Oracle 9i or oracle 11G database?
Using a OGG 10g build you can replicate to oracle 10.1 or 10.2 but not to Oracle 9i or Oracle 11G
For an extract - The database version should match exactly with the Oracle GG build
GG oracle 10G Build - Can extract from Oracle 10.1 or Oracle 10.2 and not from any other Oracle version
GG oracle 10.1 build – Can extract only from Oracle 10.1 and not from any other Oracle version
GG oracle 10.2 build – Can extract Only from Oracle 10.2 and not from any other Oracle version
For a replicat – The major database version should match with the Oracle GG build
GG oracle 10G Build – Can replicate to Oracle 10.1 or Oracle 10.2 and not to any other Oracle version
GG oracle 10.1 build – Can replicate to Oracle 10.1 , Oracle 10.2 and not to any other Oracle version
GG oracle 10.2 build – Can replicate to Oracle 10.1, Oracle 10.2 and not to any other Oracle version
The case is same with Oracle GG 9i build or GG 11g build.
The reason behind these requirements is that the data dictionary calls may be different from one version of the database to the other and our code is database version specific.
To clarify it differently, OGG always refers the Oracle DB software version and not the COMPATIBLE parameter, which might point to older versions for backward compatibility.
That's because you're probably using the "right" version for the extract side and are getting lucky using that same version for the replicat side because not all the system tables changed between 10g and 11g. Try capturing with that "wrong" version from your target system. Just test it you'll see if it works.