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

    Can EBS 12.1.3 ship redo to goldengate downstream site?



      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

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

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

             SID = 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='' 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?