Home » Server Options » Replication » Getting errors while using mixed versions of Golden Gate Software (Golden Gate 12.1 and 11.2 between sql server 2008 and Oracle 11.2)
Getting errors while using mixed versions of Golden Gate Software [message #617392] Sat, 28 June 2014 16:01 Go to next message
chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member
Hello

We are trying to replicate data from SQL Server to Oracle

Source : sql server 2008 R2

Golden gate Version on Source
Version 12.1.2.0.1 17597485 OGGCORE_12.1.2.0.T2_PLATFORMS_131206.0309

Target : Oracle 11.2.0.4.0 on Linux

Golden gate Version on Target
Version 11.2.1.0.16 17781910 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_131205.0902_FBO

During Initial load we are getting following error on Target

ERROR OGG-01332 File /u03/mygg/dirdat/ex01, with compatibility level 4, is not compatible with the current software version's compatibility level of 3. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 3 option.

I tried to use "Format Release" parameter in the defgen parameter file but no luck!!

I tried to use version 11.1 as well as 11.2 in the format release but it did not work

defsfile c:\<goldengatedir>\mytable.def format release 11.2
sourcedb <databasedsn>
table <schema>.mytable;

Could you please suggest on the same?

Thanks and Regards
Chetan
Re: Getting errors while using mixed versions of Golden Gate Software [message #617692 is a reply to message #617392] Wed, 02 July 2014 12:43 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

have you added in pump & master extract ?

- babu
Re: Getting errors while using mixed versions of Golden Gate Software [message #617901 is a reply to message #617692] Fri, 04 July 2014 05:22 Go to previous messageGo to next message
chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member
Hello babu

Thanks for your reply

Thankfully I got the same version installed on the source database and everything went well

I have not tried the pump however

Thanks and Regards
Chetan
Re: Getting errors while using mixed versions of Golden Gate Software [message #617939 is a reply to message #617901] Fri, 04 July 2014 11:13 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

As long as you already set FORMAT RELEASE parameter in master / and extract process .. You should be good but in case if still getting same error then I would suggest contact Oracle support.

Previous Topic: SQL Server software compatibility for Golden gate Replication
Next Topic: create DDL scripts from SQL server to Oracle
Goto Forum:
  


Current Time: Fri Mar 29 07:31:41 CDT 2024