一、环境准备与下载清单系统要求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 19coracle Instant Client 19.24 (用于数据库连接)基础包: instantclient-basiclite-linux.x64-19.24.0.0.0dbru.zipSQL*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.ziphttps://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_OPTIONORA19c\SOFTWARE_LOCATION/data/oracle/ogg\INVENTORY_LOCATION/data/oracle/oraInventory\UNIX_GROUP_NAMEoinstall\-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_OPTIONADDDEPLOYMENT_NAMEOGGDEPLOY# 管理员账号密码ADMINISTRATOR_USERoggadminADMINISTRATOR_PASSWORDogg123Z# 安全设置(禁用SSL,适合测试环境)SECURITY_ENABLEDfalseSTRONG_PWD_POLICY_ENABLEDfalse# ServiceManager配置CREATE_NEW_SERVICEMANAGERtrueSERVICEMANAGER_DEPLOYMENT_HOME/data/oracle/oggweb/ServiceManagerHOST_SERVICEMANAGER0.0.0.0PORT_SERVICEMANAGER6770REGISTER_SERVICEMANAGER_AS_A_SERVICEfalseINTEGRATE_SERVICEMANAGER_WITH_XAGfalse# 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_ENABLEDtruePORT_ADMINSRVR6771DISTRIBUTION_SERVER_ENABLEDtruePORT_DISTSRVR6772NON_SECURE_DISTSRVR_CONNECTS_TO_SECURE_RCVRSRVRfalseRECEIVER_SERVER_ENABLEDtruePORT_RCVRSRVR6773METRICS_SERVER_ENABLEDtruePORT_PMSRVR6774UDP_PORT_PMSRVR6775PMSRVR_DATASTORE_TYPEBDB# OGG数据库SchemaOGG_SCHEMAOGGADMIN# 清理残留(如重新部署)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|awkNR!1{print $2}|xargskill-92/dev/null六、验证部署结果检查 OGG 服务进程ps-ef|grep-EServiceManager|adminsrvr|distsrvr|recvsrvr|pmsrvr访问 Web 管理界面打开浏览器访问:http://IP:6770使用配置的账号密码登录: oggadmin/ogg123Z使用 adminclient (替代 ggsci)# 进入adminclient交互式命令行/data/oracle/ogg/bin/adminclient# 连接到OGG部署CONNECT http://localhost:6771 DEPLOYMENT OGGDEPLOYUSERoggadmin PASSWORD ogg123Z# 查看OGG版本INFO ALL