This discussion is archived
1 Reply Latest reply: Oct 20, 2013 11:26 AM by user296828 RSS

Golden Gate binaries upgrade

user296828 Expert
Currently Being Moderated

hello,

 

Our current environment (both Source & Target) is GG 11.2.1.0.6 on 64bits Redhat 5.7 EE.

 

We do have a few Integrated Extracts running (with DDL supprt ) on the current Oracle 11.2.0 environments.

 

Can somebody share an idea or help on how we can upgrade

     *** current GG 11.2.1.0. 6 to 11.2.1.0.13 including current Extract & Replicat on Target database running.

I have downloaded the binaries/tar for 11.2.1.0.13 version but it does not include proper "How to instructions".

 

A direction to some web links or metalink will be much appreciated.

 

Regards,

 

Pradeep

  • 1. Re: Golden Gate binaries upgrade
    user296828 Expert
    Currently Being Moderated

    I believe it should be straight forward as below but not sure if that is right.

     

    1. stop all extracts & replicates

    2.  backup current binaries on both source & target side.

    3. Extract binaries 11.2.1.0.13 on /tmp directory.  

    4. Override 11.2.1.0.6 binaries with 11.2.1.0.13 on /tmp

    5. do not change default dirprm .. directories.

    6. Check the version

    ./ggsci

    7. Upgrade checkpointtable ggs_owner.chkptab  on target side.

     

    On Source

    SQL> @ddl_disable

    SQL> @ddl_remove

    SQL> @marker_remove

    SQL> @marker_setup

    SQL> @ddl_setup

    ..

    ..

    SQL> @ddl_enable

     

    alter extract <> etrollover

    On target

     

    alter replicat <> extseqno <next number>

    On source

     

    start extract <>

    start replicat <>

     

    finished.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points