[oracle@db-ora01]$>
sqlplus / as sysdba
alter database archivelog;
alter database add supplemental log data;
alter system set log_archive_config='dg_config=(dbquik01,dbquik02,ds)';
alter system set enable_goldengate_replication=true;
alter system set archive_lag_target = 300;
-- ggadmin
create tablespace gg_data datafile '/u01/oradata/dbquik/gg_data_01.dbf' size 100m autoextend on next 100m maxsize unlimited;
create user ggadmin identified by *** default tablespace gg_data temporary tablespace temp;
grant connect,resource,create session, alter session to ggadmin;
grant select any dictionary, select any table,create table to ggadmin;
grant alter any table to ggadmin;
grant execute on utl_file to ggadmin;
grant flashback any table to ggadmin;
grant execute on dbms_flashback to ggadmin;
--Doc ID 1628986.1
grant alter system to ggadmin;
GRANT UNLIMITED TABLESPACE TO ggadmin;
alter user ggadminquota unlimited on GG_DATA;
grant select on system.logmnr_session$ to ggadmin;
begin
dbms_goldengate_auth.grant_admin_privilege('GGADMIN');
end;
/
2. Adding aliases to the tnsnames.ora file
vi $ORACLE_HOME/network/admin/tnsnames.ora
dbquik01 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db-quik01.oracak.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = dbquik01)))
dbquik02 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db-quik02.oracak.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = dbquik02)))
ds = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ogg-srv.oracak.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ds)))
3. Adding the path for sending logs to the Downstream server
alter system set log_archive_dest_10 = 'SERVICE=ds ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) TEMPLATE=/u01/oradata/downstream/gg_arch_%t_%s_%r.arc DB_UNIQUE_NAME=ds';
