OraFAQ Forum: Replication » Getting errors while using mixed versions of Golden Gate Software

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting errors while using mixed versions of Golden Gate Software [message #617392]

Sat, 28 June 2014 16:01

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

Report message to a moderator

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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

have you added in pump & master extract ?

- babu

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:13:10 CST 2025