1 Reply Latest reply: Oct 20, 2013 1:26 PM by 12cdb RSS

    Golden Gate binaries upgrade

    12cdb

      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
          12cdb

          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.