1 Reply Latest reply on Jul 8, 2016 3:27 PM by UDA

    Can EBS 12.1.3 ship redo to goldengate downstream site?

    UDA

      Hi

      This is a test environment with three vms
      similating an environment for a client to show zero downtime upgrade and migration


      A.   EBS R12.1.3 on OEL 5u3 64 bit with database 11.2.0.4

             appsTier and dbTier on separate vm machines oel 5u3
             SID 11.2.0.4 = VIS
             dont want to install golden gate here as per the client.


      B.  oracle goldengate 12.2 on OEL 6u6 64bit having oracle db 12.1.0.2

             SID 12.1.0.2 = msdb
            
      I want to ship redo from A- dbTier-VIS instance to B- msdb 


      Did follwoing steps

      On A-(VIS dbTier)

      ALTER SYSTEM set log_archive_dest_3='service=msdb ASYNC NOREGISTER
                      valid_for=(online_logfiles,primary_role) REOPEN=10 db_unique_name=msdb' SID='*';  
      ALTER SYSTEM set log_archive_dest_state_3=enable;
      ALTER SYSTEM set log_archive_config='DG_CONFIG=(VIS,GGV,msdb)' scope=both;
      alter system set compatible='11.2.0.4.0' scope=spfile sid='*';

      ./addbctl stop
      ./addbctl start


      On B-(msdb GoldenGate Downstream VM)

      alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/msdb
                                           VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)' scope=both;

       

      alter system set log_archive_dest_2='LOCATION=/u01/app/oracle/archivelog/VIS
                                           VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)' scope=both SID='*';

      alter system set log_archive_config='DG_CONFIG=(VIS,msdb)' scope=both;
      alter system set fal_server = VIS scope=both;

       

      created standby logs on msdb.


      Result: Not able to receive redo logs from A to B.

      Question: please advise what is missing or wrong?