企业官网建设流程全解析

一、环境准备与下载清单

系统要求

Oracle Golden Gate 19c 以上版本受限于系统内核，参考Oracle官网文档
https://docs.oracle.com/en/middleware/goldengate/core/19.1/coredoc/index.html

操作系统: RHEL 7.x/8.x 或 Oracle Linux 7.x/8.x
内存: 至少 4GB (推荐 8GB+)
磁盘: 至少 20GB 可用空间

下载准备 (官方链接)

Oracle Golden Gate 19.1.0.0.4 微服务版 (核心安装包)
版本: 19.1.0.0.4 (OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054)
文件名: V1054774-01.zip (fbo_ggs_Linux_x64_Oracle_services_shiphome.zip)
官方下载步骤:
登录 https://edelivery.oracle.com/osdc/faces/SoftwareDelivery
搜索 Release Oracle Golden Gate 19c

oracle Instant Client 19.24 (用于数据库连接)
基础包: instantclient-basiclite-linux.x64-19.24.0.0.0dbru.zip
SQL*Plus 包: instantclient-sqlplus-linux.x64-19.24.0.0.0dbru.zip
官方下载链接:
https://download.oracle.com/otn_software/linux/instantclient/1924000/instantclient-basiclite-linux.x64-19.24.0.0.0dbru.zip
https://download.oracle.com/otn_software/linux/instantclient/1924000/instantclient-sqlplus-linux.x64-19.24.0.0.0dbru.zip

二、基础环境配置

安装相关依赖

yuminstall-yunziprpm-ivhcompat-libstdc++-33-3.2.3-72.el7.x86_64.rpmrpm-ivhlibstdc++-4.8.5-16.el7.x86_64.rpm

创建目录结构

# 创建OGG相关目录mkdir-p/data/oraclemkdir-p/data/oracle/oggmkdir-p/data/oracle/oggwebmkdir-p/data/oracle/oraInventorymkdir-p/data/oracle/instantclient_19_24# 创建用户和组groupaddoinstalluseradd-goinstall oracle# 设置权限chown-Roracle:oinstall /data/oraclechmod-R775/data/oracle

配置环境变量

切换到 oracle 用户配置环境变量:

su- oraclevi~/.bash_profile

# Oracle Client 环境变量exportORACLE_HOME=/data/oracle/instantclient_19_24exportLD_LIBRARY_PATH=$ORACLE_HOME:/data/oracle/ogg/lib:$LD_LIBRARY_PATHexportPATH=$ORACLE_HOME:$PATH# OGG 环境变量exportOGG_HOME=/data/oracle/oggexportPATH=$OGG_HOME/bin:$PATH

# 使环境变量生效:source~/.bash_profile

# 验证环境变量echo$ORACLE_HOMEecho$LD_LIBRARY_PATH

三、Oracle Instant Client 安装

# 解压安装unzipinstantclient-basiclite-linux.x64-19.24.0.0.0dbru.zip-d/data/oracle/unzipinstantclient-sqlplus-linux.x64-19.24.0.0.0dbru.zip-d/data/oracle/# 验证SQL*Plus安装sqlplus-V

四、Oracle GoldenGate 19c 软件静默安装

解压 OGG 安装包

# 上传V1054774-01.zip到/data目录cd/dataunzipV1054774-01.zip

静默安装 OGG 软件

# 以oracle用户执行静默安装su- oracle# 进入安装目录cd/data/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/

./runInstaller-silent\INSTALL_OPTION=ORA19c\SOFTWARE_LOCATION=/data/oracle/ogg\INVENTORY_LOCATION=/data/oracle/oraInventory\UNIX_GROUP_NAME=oinstall\-ignoreSysPrereqs

执行 root 脚本

安装完成后，切换到 root 用户执行配置脚本:

sh/data/oracle/oraInventory/orainstRoot.sh

五、OGG Web 服务部署 (oggca 响应文件配置)

创建响应文件 (oggca.rsp)

su- oraclevi/data/oracle/oggca.rsp

添加以下完整配置:

oracle.install.responseFileVersion=/oracle/install/rspfmt_oggca_response_schema_v20_1_0# 配置选项(新增部署)CONFIGURATION_OPTION=ADDDEPLOYMENT_NAME=OGGDEPLOY# 管理员账号密码ADMINISTRATOR_USER=oggadminADMINISTRATOR_PASSWORD=ogg@123Z# 安全设置(禁用SSL,适合测试环境)SECURITY_ENABLED=falseSTRONG_PWD_POLICY_ENABLED=false# ServiceManager配置CREATE_NEW_SERVICEMANAGER=trueSERVICEMANAGER_DEPLOYMENT_HOME=/data/oracle/oggweb/ServiceManagerHOST_SERVICEMANAGER=0.0.0.0PORT_SERVICEMANAGER=6770REGISTER_SERVICEMANAGER_AS_A_SERVICE=falseINTEGRATE_SERVICEMANAGER_WITH_XAG=false# OGG软件和部署目录OGG_SOFTWARE_HOME=/data/oracle/oggOGG_DEPLOYMENT_HOME=/data/oracle/oggweb/OGGDEPLOY# Oracle环境变量配置ENV_ORACLE_HOME=/data/oracle/instantclient_19_24ENV_LD_LIBRARY_PATH=/data/oracle/instantclient_19_24:/data/oracle/ogg/libENV_TNS_ADMIN=/data/oracle/instantclient_19_24/network/admin# 启用各组件服务ADMINISTRATION_SERVER_ENABLED=truePORT_ADMINSRVR=6771DISTRIBUTION_SERVER_ENABLED=truePORT_DISTSRVR=6772NON_SECURE_DISTSRVR_CONNECTS_TO_SECURE_RCVRSRVR=falseRECEIVER_SERVER_ENABLED=truePORT_RCVRSRVR=6773METRICS_SERVER_ENABLED=truePORT_PMSRVR=6774UDP_PORT_PMSRVR=6775PMSRVR_DATASTORE_TYPE=BDB# OGG数据库SchemaOGG_SCHEMA=OGGADMIN

# 清理残留(如重新部署)rm-rf/data/oracle/oggwebrm-rf/tmp/OraInstall*# 创建部署目录mkdir-p/data/oracle/oggweb/ServiceManager /data/oracle/oggweb/OGGDEPLOY# 权限配置chown-Roracle:oinstall /data/oracle/oggwebchmod600/data/oracle/oggca.rsp

执行静默部署 Web 服务

# 执行oggca静默部署/data/oracle/ogg/bin/oggca.sh-silent-responseFile/data/oracle/oggca.rsp

清理端口占用 (如部署失败重试)

# 清理所有OGG相关进程pkill-fservicemanager2>/dev/nullpkill-fadminsrvr2>/dev/nullpkill-fogg2>/dev/null# 强制关闭占用端口的进程lsof-i:6770-i:6771-i:6772-i:6773-i:6774-i:6775|awk'NR!=1{print $2}'|xargskill-92>/dev/null

六、验证部署结果

检查 OGG 服务进程

ps-ef|grep-E'ServiceManager|adminsrvr|distsrvr|recvsrvr|pmsrvr'

访问 Web 管理界面

打开浏览器访问:

http://IP:6770
使用配置的账号密码登录: oggadmin/ogg@123Z

使用 adminclient (替代 ggsci)

# 进入adminclient交互式命令行/data/oracle/ogg/bin/adminclient# 连接到OGG部署CONNECT http://localhost:6771 DEPLOYMENT OGGDEPLOYUSERoggadmin PASSWORD ogg@123Z

# 查看OGG版本INFO ALL