Oracle Glodengate管理-19C 集群部署OGG

最新推荐文章于 2024-08-11 11:29:21 发布

执笔画情ora

最新推荐文章于 2024-08-11 11:29:21 发布

阅读量562

点赞数

分类专栏： Goldgate管理与应用文章标签： oracle 数据库 java

原文链接：https://blog.csdn.net/m15217321304/article/details/112245469

版权

Goldgate管理与应用专栏收录该内容

44 篇文章 7 订阅

订阅专栏

本文详细介绍了在RAC19.7环境下，使用OracleGoldenGate19.1版本在VMware上的RedHatEnterpriseLinux7.2系统中如何配置ACFS并进行OGG的上传、解压以及图形化安装过程。安装完成后，在两个节点上都能看到OGG的相关数据。

摘要由CSDN通过智能技术生成

1 环境概述

RAC版本为19.7
OGG版本为19.1
平台为VMware
操作系统为 Red Hat Enterprise Linux Server release 7.2

最新的OGG版本下载地址
https://www.oracle.com/middleware/technologies/goldengate-downloads.html

--//这篇文章的前提是已经配置好了ACFS，ACFS的配置可以参考
https://blog.csdn.net/m15217321304/article/details/112236321

2 上传文件并解压

--//上传19.1版本的OGG到节点1配置的ACFS目录并解压

[root@dm01 ogg]# ls -ltr
total 548944
drwx------ 2 root root 65536 Jan 5 16:28 lost+found
-rw-r--r-- 1 root root 556240981 Jan 5 16:58 191004_fbo_ggs_Linux_x64_shiphome.zip
[root@dm01 ogg]# chown oracle:oinstall 191004_fbo_ggs_Linux_x64_shiphome.zip

--//切换到root用户解压OGG压缩包
[root@dm01 ogg]# unzip 191004_fbo_ggs_Linux_x64_shiphome.zip

3 安装部署

--//运行
cd fbo_ggs_Linux_x64_shiphome/
cd Disk1/
./runInstaller
调用图形界面

1) 运行./runInstaller

2）、选择19c版本的数据库

3）、软件安装目录为ACFS目录(目录ORACLE用户要有权限)

4）、安装预览

5）、点击install安装

6）、安装完成

7）、在节点1安装成功之后，2节点同样可以看到数据，因为是配置的ACFS

[root@dm02 /]# su - oracle
Last login: Tue Jan 5 15:07:17 CST 2021 on pts/0
c[oracle@dm02 ~]$ cd /ogg/
[oracle@dm02 ogg]$ ls
191004_fbo_ggs_Linux_x64_shiphome.zip lost+found OGG-19.1.0.0-README.txt
fbo_ggs_Linux_x64_shiphome ogg OGG_WinUnix_Rel_Notes_19.1.0.0.4.pdf
[oracle@dm02 ogg]$ ls -ltr ogg
total 255508
-rwxrwxr-x 1 oracle oinstall 759 Oct 15 2010 tcperrs
-rwxr-xr-x 1 oracle oinstall 248 Oct 15 2010 sqlldr.tpl
-rwxr-xr-x 1 oracle oinstall 1968 Oct 15 2010 freeBSD.txt
-rwxr-xr-x 1 oracle oinstall 159 Oct 15 2010 db2cntl.tpl
-rwxr-xr-x 1 oracle oinstall 1725 Oct 15 2010 bcrypt.txt
-rwxr-xr-x 1 oracle oinstall 426 Oct 15 2010 bcpfmt.tpl
-rwxr-xr-x 1 oracle oinstall 1272 Dec 28 2010 prvtclkm.plb
-rwxr-xr-x 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb
-rwxr-xr-x 1 oracle oinstall 1033 Oct 19 2016 zlib.txt
-rwxr-xr-x 1 oracle oinstall 312546 May 2 2019 help.txt
-rwxr-xr-x 1 oracle oinstall 32284 May 3 2019 notices.txt
-rwxr-xr-x 1 oracle oinstall 52402576 Oct 17 2019 ggparam.dat
-rwxr-xr-x 1 oracle oinstall 2581584 Oct 17 2019 ggMessage.dat
-rwxr-xr-x 1 oracle oinstall 1010 Oct 17 2019 version4j.jar
-rw-rw-r-- 1 oracle oinstall 7278 Oct 17 2019 ulg.sql
-rw-rw-r-- 1 oracle oinstall 35254 Oct 17 2019 sequence.sql
-rw-rw-r-- 1 oracle oinstall 1532 Oct 17 2019 remove_seq.sql
-rw-rw-r-- 1 oracle oinstall 2724 Oct 17 2019 prvtlmpg_uninstall.sql
-rw-rw-r-- 1 oracle oinstall 3146 Oct 17 2019 params.sql
-rw-rw-r-- 1 oracle oinstall 2 Oct 17 2019 noop.sql
-rw-rw-r-- 1 oracle oinstall 675 Oct 17 2019 marker_status.sql
-rw-rw-r-- 1 oracle oinstall 3309 Oct 17 2019 marker_setup.sql
-rw-rw-r-- 1 oracle oinstall 1553 Oct 17 2019 marker_remove.sql
-rw-rw-r-- 1 oracle oinstall 56 Oct 17 2019 label.sql
-rw-rw-r-- 1 oracle oinstall 2305 Oct 17 2019 demo_ora_pk_befores_updates.sql
-rw-rw-r-- 1 oracle oinstall 1013 Oct 17 2019 demo_ora_pk_befores_insert.sql
-rw-rw-r-- 1 oracle oinstall 1056 Oct 17 2019 demo_ora_pk_befores_create.sql
-rw-rw-r-- 1 oracle oinstall 1943 Oct 17 2019 demo_ora_misc.sql
-rw-rw-r-- 1 oracle oinstall 3597 Oct 17 2019 demo_ora_lob_create.sql
-rw-rw-r-- 1 oracle oinstall 504 Oct 17 2019 demo_ora_insert.sql
-rw-rw-r-- 1 oracle oinstall 583 Oct 17 2019 demo_ora_create.sql
-rw-rw-r-- 1 oracle oinstall 649 Oct 17 2019 demo_more_ora_insert.sql
-rw-rw-r-- 1 oracle oinstall 2383 Oct 17 2019 ddl_trace_on.sql
-rw-rw-r-- 1 oracle oinstall 2133 Oct 17 2019 ddl_trace_off.sql
-rw-rw-r-- 1 oracle oinstall 2118 Oct 17 2019 ddl_staymetadata_on.sql
-rw-rw-r-- 1 oracle oinstall 2122 Oct 17 2019 ddl_staymetadata_off.sql
-rw-rw-r-- 1 oracle oinstall 8401 Oct 17 2019 ddl_status.sql
-rw-rw-r-- 1 oracle oinstall 292051 Oct 17 2019 ddl_setup.sql
-rw-rw-r-- 1 oracle oinstall 629 Oct 17 2019 ddl_session.sql
-rw-rw-r-- 1 oracle oinstall 1 Oct 17 2019 ddl_session1.sql
-rw-rw-r-- 1 oracle oinstall 3184 Oct 17 2019 ddl_remove.sql
-rw-rw-r-- 1 oracle oinstall 216 Oct 17 2019 ddl_pin.sql
-rw-rw-r-- 1 oracle oinstall 12564 Oct 17 2019 ddl_ora9.sql
-rw-rw-r-- 1 oracle oinstall 13471 Oct 17 2019 ddl_ora11.sql
-rw-rw-r-- 1 oracle oinstall 1725 Oct 17 2019 ddl_ora10upCommon.sql
-rw-rw-r-- 1 oracle oinstall 12220 Oct 17 2019 ddl_ora10.sql
-rw-rw-r-- 1 oracle oinstall 2036 Oct 17 2019 ddl_filter.sql
-rw-rw-r-- 1 oracle oinstall 88 Oct 17 2019 ddl_enable.sql
-rw-rw-r-- 1 oracle oinstall 90 Oct 17 2019 ddl_disable.sql
-rw-rw-r-- 1 oracle oinstall 3176 Oct 17 2019 ddl_ddl2file.sql
-rw-rw-r-- 1 oracle oinstall 8573 Oct 17 2019 ddl_create.sql
-rw-rw-r-- 1 oracle oinstall 455 Oct 17 2019 ddl_cleartrace.sql
-rw-rw-r-- 1 oracle oinstall 1021 Oct 17 2019 chkpt_ora_create.sql
-rw-rw-r-- 1 oracle oinstall 121 Oct 17 2019 archivelog.sql
-rw-rw-r-- 1 oracle oinstall 28299 Oct 17 2019 usrdecs.h
-rw-rw-r-- 1 oracle oinstall 37535 Oct 17 2019 ucharset.h
-rw-rw-r-- 1 oracle oinstall 4811 Oct 17 2019 SQLDataTypes.h
-rw-rw-r-- 1 oracle oinstall 3187 Oct 17 2019 role_setup.sql
-rw-rw-r-- 1 oracle oinstall 882 Oct 17 2019 demo_more_ora_create.sql
-rw-rw-r-- 1 oracle oinstall 2186 Oct 17 2019 ddl_tracelevel.sql
-rwxrwx--- 1 oracle oinstall 11533760 Oct 17 2019 libggnnzitp.so
-rwxrwxr-x 1 oracle oinstall 4594960 Oct 17 2019 emsclnt
-rwxrwxr-x 1 oracle oinstall 4098888 Oct 17 2019 checkprm
-rwxrwxr-x 1 oracle oinstall 3915544 Oct 17 2019 server
-rwxrwxr-x 1 oracle oinstall 7664936 Oct 17 2019 pmsrvr
-rwxrwxr-x 1 oracle oinstall 689056 Oct 17 2019 libPocoXML.so.60
-rwxrwxr-x 1 oracle oinstall 1238272 Oct 17 2019 libPocoNet.so.60
-rwxrwxr-x 1 oracle oinstall 90824 Oct 17 2019 libgcc_s.so.1
-rwxrwx--- 1 oracle oinstall 2190856 Oct 17 2019 libdb-6.1.so
-rwxrwxr-x 1 oracle oinstall 244656 Oct 17 2019 libboost_system-mt.so.1.67.0
-rwxrwx--- 1 oracle oinstall 110888 Oct 17 2019 libantlr3c.so
-rwxrwx--- 1 oracle oinstall 7934856 Oct 17 2019 ggsci
-rwxrwx--- 1 oracle oinstall 12361928 Oct 17 2019 extract
-rwxrwxr-x 1 oracle oinstall 9696 Oct 17 2019 db_upgrade
-rwxrwxr-x 1 oracle oinstall 4124000 Oct 17 2019 convchk
-rwxrwxr-x 1 oracle oinstall 1637112 Oct 17 2019 retrace
-rwxrwx--- 1 oracle oinstall 11310280 Oct 17 2019 replicat
-rwxrwxr-x 1 oracle oinstall 6035504 Oct 17 2019 logdump
-rwxrwx--- 1 oracle oinstall 4668552 Oct 17 2019 libxerces-c-3.2.so
-rwxrwxr-x 1 oracle oinstall 1651920 Oct 17 2019 libstdc++.so.6
-rwxrwxr-x 1 oracle oinstall 331496 Oct 17 2019 libPocoJSON.so.60
-rwxrwx--- 1 oracle oinstall 86960 Oct 17 2019 liblmdb.so
-rwxrwxr-x 1 oracle oinstall 31552960 Oct 17 2019 libicudata.so.62
-rwxrwx--- 1 oracle oinstall 112760 Oct 17 2019 libggutil.so
-rwxrwx--- 1 oracle oinstall 751848 Oct 17 2019 libggrepo.so
-rwxrwx--- 1 oracle oinstall 194680 Oct 17 2019 libggperf.so
-rwxrwxr-x 1 oracle oinstall 5307976 Oct 17 2019 defgen
-rwxrwxr-x 1 oracle oinstall 1592032 Oct 17 2019 cachefiledump
-rwxrwxr-x 1 oracle oinstall 1641208 Oct 17 2019 oggerr
-rwxrwxr-x 1 oracle oinstall 6775328 Oct 17 2019 mgr
-rwxrwx--- 1 oracle oinstall 1115360 Oct 17 2019 libudt.so
-rwxrwxr-x 1 oracle oinstall 458080 Oct 17 2019 libPocoUtil.so.60
-rwxrwxr-x 1 oracle oinstall 283320 Oct 17 2019 libPocoNetSSL.so.60
-rwxrwxr-x 1 oracle oinstall 1993664 Oct 17 2019 libPocoFoundation.so.60
-rwxrwxr-x 1 oracle oinstall 228568 Oct 17 2019 libPocoCrypto.so.60
-rwxrwxr-x 1 oracle oinstall 2095288 Oct 17 2019 libicuuc.so.62
-rwxrwxr-x 1 oracle oinstall 3030640 Oct 17 2019 libicui18n.so.62
-rwxrwx--- 1 oracle oinstall 1206792 Oct 17 2019 libggssl.so
-rwxrwx--- 1 oracle oinstall 22082808 Oct 17 2019 libggparam.so
-rwxrwx--- 1 oracle oinstall 1430176 Oct 17 2019 libgglog.so
-rwxrwxr-x 1 oracle oinstall 108824 Oct 17 2019 keygen
-rwxrwxr-x 1 oracle oinstall 4627856 Oct 17 2019 ggcmd
-rwxrwxr-x 1 oracle oinstall 5332160 Oct 17 2019 convprm
-rw-r----- 1 oracle oinstall 56 Jun 9 2020 oraInst.loc
drwxr-xr-x 7 oracle oinstall 20480 Jan 5 17:07 UserExitExamples
drwxr-xr-x 3 oracle oinstall 20480 Jan 5 17:07 diagnostics
drwxr-xr-x 3 oracle oinstall 20480 Jan 5 17:07 diretc
drwxr-xr-x 4 oracle oinstall 20480 Jan 5 17:07 dirsca
drwxr-xr-x 3 oracle oinstall 20480 Jan 5 17:07 srvm
drwxr-xr-x 2 oracle oinstall 20480 Jan 5 17:07 deinstall
drwxr-xr-x 2 oracle oinstall 20480 Jan 5 17:08 crypto
drwxr-xr-x 2 oracle oinstall 20480 Jan 5 17:08 dirout
drwxr-xr-x 2 oracle oinstall 20480 Jan 5 17:08 healthcheck
drwxr-xr-x 6 oracle oinstall 20480 Jan 5 17:08 jdk
drwxr-xr-x 12 oracle oinstall 20480 Jan 5 17:08 OPatch
drwxr-xr-x 8 oracle oinstall 20480 Jan 5 17:08 oui
drwxr-x--- 13 oracle oinstall 20480 Jan 5 17:08 inventory
drwxr-xr-x 3 oracle oinstall 20480 Jan 5 17:08 install
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirchk
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirsql
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirdef
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirdat
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirtmp
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dircrd
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirwlt
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirdmp
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirprm
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirrpt
drwxr-x--- 2 oracle oinstall 20480 Jan 5 17:08 dirpcs
-rw-r----- 1 oracle oinstall 717 Jan 5 17:08 ggserr.log
drwxr-xr-x 3 oracle oinstall 20480 Jan 5 17:08 cfgtoollogs
[oracle@dm02 ogg]$