ogg21.3双向配置oracle19c

https://blog.51cto.com/u_11682417/5824820
OGG21C微服务的安装和配置

https://mp.weixin.qq.com/s?__biz=MzI3OTE0NDIyNw==&mid=2247488921&idx=1&sn=56196c3f78574e56e09d48f62c6382cf&chksm=eb4d67d5dc3aeec3951f5f0bce0cf69eb870b873bff143caa423bb0f5eda08fc50019dd9ecd3&scene=21#wechat_redirect
OGG21C 双向配置

数据库配置

sqlplus / as sysdba
SQL> !lsnrctl start
SQL> alter system register;

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/product/19c/dbhome_1/dbs/arch
Oldest online log sequence 96
Next log sequence to archive 98
Current log sequence 98
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2382363352 bytes
Fixed Size 8899288 bytes
Variable Size 1157627904 bytes
Database Buffers 1207959552 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/product/19c/dbhome_1/dbs/arch
Oldest online log sequence 96
Next log sequence to archive 98
Current log sequence 98
SQL>

开启数据库级别附加日志

NAME SUPPLEME FORCE_LOGGING LOG_MODE

P19C YES YES ARCHIVELOG

开启方法如下：
alter database add supplemental log data;
alter database add supplemental log data (all) columns;

3 开启强制日志
alter database force logging;

4 参数为设置
SQL> show parameter enable_goldengate_replication;
SQL> alter system set enable_goldengate_replication=TRUE;
SQL> startup force

5 OGG管理用户
SQL> select username from dba_users where username=‘OGG’;

CREATE USER ogg identified by ogg;
grant SELECT ANY DICTIONARY to ogg;
GRANT EXECUTE ON SYS.DBMS_LOCK TO ogg;
grant select any transaction to ogg;
grant select any table to ogg;
grant flashback any table to ogg;
grant alter any table to ogg;

exec dbms_goldengate_auth.grant_admin_privilege(‘OGG’,’*’,TRUE);

6 业务用户，源库操作
CREATE USER it_mes identified by it_mes;
GRANT DBA to it_mes ;
grant SELECT ANY DICTIONARY to it_mes;
GRANT EXECUTE ON SYS.DBMS_LOCK TO it_mes;

7 启动监听
lsnrctl start
lsnrctl status

8.源端添加SCHEMATRANDATA

GGSCI (node66) 8> dblogin useridalias target_p19c
已成功登录到数据库。

GGSCI（node66，作为 ogg@p19c） 9> ADD SCHEMATRANDATA IT_MES

2023-02-09 09:51:54 INFO OGG-01788 已在方案 “IT_MES” 上添加 SCHEMATRANDATA。.

2023-02-09 09:51:54 INFO OGG-01976 已在方案 “IT_MES” 上添加针对调度列的 SCHEMATRANDATA。.

2023-02-09 09:51:54 INFO OGG-10154 方案 “IT_MES” 上的方案级别 PREPARECSN 已设置为模式 NOWAIT.

9…源端和目标端创建脉动表
GGSCI（node66，作为 ogg@p19c） 10> ADD HEARTBEATTABLE

2023-02-09 09:52:53 ERROR OGG-14041 “ogg”.“GG_HEARTBEAT_SEED” 已存在。.

GGSCI（node66，作为 ogg@p19c） 11> INFO HEARTBEATTABLE

HEARTBEAT 表 ogg.gg_heartbeat 已存在。

HEARTBEAT 表 ogg.gg_heartbeat_seed 已存在。

HEARTBEAT 表 ogg.gg_heartbeat_history 已存在。

HEARTBEAT 表的 ogg.gg_heartbeat 补充日志记录处于 ENABLED 状态。

HEARTBEAT 表的 ogg.gg_heartbeat_seed 补充日志记录处于 ENABLED 状态。

HEARTBEAT 表的 ogg.gg_heartbeat_history 分区处于 DISABLED 状态。

频率间隔：60 秒。

清除频率间隔：1 天。

保留时间：30 天。

ogg —安装
cd /opt/soft/
unzip 213000_fbo_ggs_Linux_x64_Oracle_shiphome.zip
cd /opt/soft/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1/response
[root@node01 response]# cat oggcore.rsp | grep -Ev ‘^$|#’

cat </opt/soft/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1/response/oggcore.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v19_1_0
INSTALL_OPTION=ORA19c
SOFTWARE_LOCATION=/opt/ogg
START_MANAGER=
MANAGER_PORT=
DATABASE_LOCATION=
INVENTORY_LOCATION=/u01/app/oraInventory
UNIX_GROUP_NAME=oinstall

EOF

ps -ef|grep ogg |awk ‘{print $2}’ |xargs kill -9
rm -rf /opt/ogg
sed -i “/LOC=/d” /u01/oraInventory/ContentsXML/inventory.xml

mkdir /opt/ogg && chown oracle.oinstall /opt/ogg
su - oracle -c “cd /opt/soft/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1&&./runInstaller -silent -nowait -responseFile /opt/soft/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1/response/oggcore.rsp”

[OGG] [INS-75012] GoldenGate重装报错
问题原因：已经安装过OGG
解决方案：删除ogg相关的那一行即可
vi /u01/oraInventory/ContentsXML/inventory.xml
············

————————————————
find /u01 -iname “inventory.xml”

原文链接：https://blog.csdn.net/qq_18671415/article/details/103328362

export OGG_HOME=/opt/ogg
export PATH=$PATH:$OGG_HOME
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$OGG_HOME
export TNS_ADMIN=ORACLE_HOME/network/admin 环境变量生效 [oracle@node01 Disk1] source ~/.bash_profile

ggsci

https://www.jianshu.com/p/3f656e07e28a

dblogin userid ogg@192.168.101.169:1521/p19c password ogg

create subdirs
edit params mgr

PORT 7809
DYNAMICPORTLIST 7810-7815
AUTOSTART EXTRACT *
AUTORESTART EXTRACT , RETRIES 4, WAITMINUTES 2
STARTUPVALIDATIONDELAY 5
PURGEOLDEXTRACTS /opt/ogg/dirdat/, USECHECKPOINTS, minkeepdays 9
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
ACCESSRULE, PROG SERVER, ALLOW

–创建身份证明
ggsci

add credentialstore
alter credentialstore add user ogg@192.168.101.159:1521/p19c,password ogg alias target_p19c
alter credentialstore add user ogg@192.168.101.169:1521/p19c,password ogg alias source_p19c

–登录数据库
dblogin useridalias source_p19c
dblogin useridalias target_p19c

OGG 21C 登陆及启动进程报错.
OGG 21c自带了客户端lib文件，如果软件位于中间层（某些特殊架构下，OGG软件与Oracle软件不在同一台服务器上），可以不需要安装Oracle客户端。但是自此，通过GGSCI连接数据库就需要指定TNS，环境变量则需要配置TNS_ADMIN的具体路径。

vi ~/.bash_profile

cat >> .bash_profile << “EOF”
export OGG_HOME=/opt/ogg
export PATH=$PATH:$ORACLE_HOME/bin:OGG_HOME ##加入了TNS_ADMIN export TNS_ADMIN=ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib
export LD_LIBRARY_PATH=$OGG_HOME:$LD_LIBRARY_PATH
alias ggsci=‘cd $OGG_HOME;ggsci’

EOF

more $ORACLE_HOME/network/admin/tnsnames.ora

同时要增增加tns的配置，tns配置如下：

[oracle@rhel64 ~]$ more $ORACLE_HOME/network/admin/tnsnames.ora


ogg =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node6)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = p19c)
    )
  )

于是再次登陆就OK了
[oracle@rhel64 ~]$ ggsci

dblogin userid ogg@ogg,password ogg 






-------------------------------------------------


A主机  到 主机 B 的同步


> edit params exta

EXTRACT exta
USERIDALIAS target_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS EXCLUDETAG 99
EXTTRAIL ./dirdat/eb
TABLE IT_MES.*;

ADD EXTRACT exta INTEGRATED TRANLOG BEGIN NOW
ADD EXTTRAIL ./dirdat/eb EXTRACT exta
dblogin useridalias target_p19c
unregister extract exta database
REGISTER EXTRACT exta DATABASE





ADD REPLICAT repb INTEGRATED EXTTRAIL ./dirdat/eb

delete REPLICAT repb 


> edit params repb
REPLICAT repb
USERIDALIAS source_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS SETTAG 99
MAP IT_MES.*, TARGET IT_MES.*;







------------------------------------------------------------------------------------------







B主机  到 主机 A 的同步


> edit params extb

EXTRACT extb
USERIDALIAS source_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS EXCLUDETAG 99
EXTTRAIL ./dirdat/eb
TABLE IT_MES.*;

ADD EXTRACT extb INTEGRATED TRANLOG BEGIN NOW
ADD EXTTRAIL ./dirdat/eb EXTRACT extb
dblogin useridalias source_p19c
unregister extract extb database
REGISTER EXTRACT extb DATABASE





ADD REPLICAT repa INTEGRATED EXTTRAIL ./dirdat/eb

delete REPLICAT repa 


> edit params repa
REPLICAT repa
USERIDALIAS target_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS SETTAG 99
MAP IT_MES.*, TARGET IT_MES.*;


----TABLEEXCLUDE IT_MES.TEST4;   #过滤不同步的表,重启进程

-------------------验证测试
create table IT_MES.TESTB5 (id number primary key,name varchar2(255));

insert into IT_MES.TESTB5  select object_id,object_name from dba_objects where object_id<=20;
commit;
select count(*) from IT_MES.TESTB5;
 
 
drop table IT_MES.TEST3;
 
 
create table IT_MES.TESTA38 (id number primary key,name varchar2(255));

insert into IT_MES.TESTA38  select object_id,object_name from dba_objects where object_id<=20;
commit;
select count(*) from IT_MES.TESTA38;
 
 
 drop table IT_MES.TEST11; 

 select count(*) from IT_MES.TEST7;

复制