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 184.108.40.206
appsTier and dbTier on separate vm machines oel 5u3
SID 220.127.116.11 = VIS
dont want to install golden gate here as per the client.
B. oracle goldengate 12.2 on OEL 6u6 64bit having oracle db 18.104.22.168
SID 22.214.171.124 = 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='126.96.36.199.0' scope=spfile sid='*';
On B-(msdb GoldenGate Downstream VM)
alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/msdb
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?
I am able to solve the issue by copying the password file to downstram server (msdb).
Now I can receive redo and apply my integrated capture.