GoldenGate安装

 mkdir /u01/app/oracle/product/gg

export GG_HOME=/u01/app/oracle/product/gg

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

 

 

 

mkdir /u01/soft

unzip V983658-01.zip -d /u01/soft/

 

cd /u01/soft/fbo_ggs_Linux_x64_shiphome/Disk1/ 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

create user c##gguser identified by aabb1234 default tablespace users

temporary tablespace TEMP container=all;

grant DBA to c##gguser container=all;

 

 exec dbms_goldengate_auth.grant_admin_privilege('c##gguser') ;

 

 

create user gguser identified by aabb1234

default tablespace gg  temporary tablespace TEMP;

grant connect,resource to gguser;

alter user gguser quota unlimited on gg;

 

ALTER SESSION SET CONTAINER=cdb$root;

select supplemental_log_data_min,force_logging from v$database;

alter database force logging;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

 

ALTER SYSTEM SWITCH LOGFILE;